Home »
General »
FUDforum in eGroupWare »
SQL syntax error when trying to enter forums
SQL syntax error when trying to enter forums [message #29379] |
Fri, 16 December 2005 13:55  |
sommer
 Messages: 21 Registered: December 2005 Location: Denmark
Karma:
|
Junior Member |
|
|
Hi!
I have recently installed the egroupware system including fudforum 2.6.0. The installation worked fine, egroupware works fine and administration of fudforum works fine. I have created a number of categories and some forums for each categori.
Unfortunately I get an error when trying to enter any one of my forums!
URL:
www_root/egroupware/fudforum/3814588639/index.php?t=thread&frm_id=3& ;
Typical error-message:
(/Library/WebServer/Documents/egroupware/fudforum/3814588639/index.php:131
/Library/WebServer/Documents/egroupware/fudforum/3814588639/theme/default/t hread.php:305
/Library/WebServer/Documents/egroupware/fudforum/3814588639/theme/default/t hread.php:328
/Library/WebServer/Documents/egroupware/fudforum/3814588639/index.php:414
) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reads FROM phpgw_fud_fc_view v INNER JOIN phpgw_fud_forum f ON f.id=v.f ' at line 1
Query: SELECT f.id, f.name, c.name, c.id, CASE WHEN 0 < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END AS reads FROM phpgw_fud_fc_view v INNER JOIN phpgw_fud_forum f ON f.id=v.f INNER JOIN phpgw_fud_cat c ON c.id=v.c LEFT JOIN phpgw_fud_msg m ON m.id=f.last_post_id LEFT JOIN phpgw_fud_forum_read fr ON fr.forum_id=f.id AND fr.user_id=2 ORDER BY v.id
Server Version: 5.0.16-standard
[Referring Page] http://localhost/egroupware/fudforum/3814588639/index.php?
Does anyone know how to solve this problem?
On the same server I have installed a standalone version of FUDforum (ver. 2.7.3) that works fine. Is there a way to migrate this into my egroupware FUDforum?
My server configuration is:
mac os x 10.4
apache 1.3.33
php5
mysql 5
egroupware 1.2.001RC4
fudforum 2.6.0
Thanks,
Henrik
|
|
|
 |
|
SQL syntax error when trying to enter forums
By: sommer on Fri, 16 December 2005 13:55
|
 |
|
Re: SQL syntax error when trying to enter forums
By: Ilia on Fri, 16 December 2005 20:43
|
 |
|
Re: SQL syntax error when trying to enter forums
By: sommer on Sat, 17 December 2005 16:41
|
 |
|
Re: SQL syntax error when trying to enter forums
By: Ilia on Sun, 18 December 2005 14:13
|
 |
|
Re: SQL syntax error when trying to enter forums
By: sommer on Sun, 18 December 2005 14:23
|
 |
|
Re: SQL syntax error when trying to enter forums
By: Ilia on Sun, 18 December 2005 14:30
|
 |
|
Re: SQL syntax error when trying to enter forums
By: sommer on Sun, 18 December 2005 16:17
|
 |
|
Re: SQL syntax error when trying to enter forums
By: Ilia on Mon, 19 December 2005 16:45
|
 |
|
Re: SQL syntax error when trying to enter forums
By: sommer on Mon, 19 December 2005 23:18
|
 |
|
Re: SQL syntax error when trying to enter forums
By: Ilia on Wed, 21 December 2005 05:09
|
 |
|
Re: SQL syntax error when trying to enter forums
By: paulbau on Wed, 15 February 2006 19:22
|
 |
|
Re: SQL syntax error when trying to enter forums
By: paulbau on Sun, 12 March 2006 21:34
|
 |
|
Re: SQL syntax error when trying to enter forums
By: paulbau on Sun, 12 March 2006 21:57
|
 |
|
Re: SQL syntax error when trying to enter forums
By: razvu on Sat, 18 March 2006 09:25
|
 |
|
Re: SQL syntax error when trying to enter forums
|
 |
|
Re: SQL syntax error when trying to enter forums
By: kalmarek on Sat, 20 January 2007 00:27
|
Goto Forum:
Current Time: Thu Feb 20 10:20:54 GMT 2025
Total time taken to generate the page: 0.05083 seconds