FUDforum: FUDforum Installation Issues » Trouble with TestFORUM in new eGroupware install

Home » FUDforum » FUDforum Installation Issues » Trouble with TestFORUM in new eGroupware install

Show: Today's Messages :: Polls :: Message Navigator

Trouble with TestFORUM in new eGroupware install [message #33478]

Mon, 04 September 2006 13:27

mbeazley

Messages: 10
Registered: September 2006

Karma:

Junior Member

I am trying to run FUDforum in eGroupware with XAMP on an Ubuntu box. Everything seemed to install OK, but I cannot get the TestFORUM to work. As 'admin' this is the output is receive:

(/opt/lampp/htdocs/egroupware/fudforum/3814588639/index.php:131
/opt/lampp/htdocs/egroupware/fudforum/3814588639/theme/default/thread.php:3 05
/opt/lampp/htdocs/egroupware/fudforum/3814588639/theme/default/thread.php:3 28
/opt/lampp/htdocs/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.21
[Referring Page] http://71.162.140.187:8080/egroupware/fudforum/3814588639/index.php?

Under non-admin user I receive the following:

Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /opt/lampp/htdocs/egroupware/fudforum/3814588639/index.php on line 71

This is line 71 of index.php:

trigger_error('SQL Error has occurred, please contact the <ahref="mailto:'.$GLOBALS['ADMIN_EMAIL'].'?subject=SQL%20Error">administrator </a> of the forum and have them review the forum's SQL query log', E_USER_ERROR);

Any help would be greatly appreciated.

Mark

Report message to a moderator

[Message index]

		Trouble with TestFORUM in new eGroupware install By: mbeazley on Mon, 04 September 2006 13:27
		Re: Trouble with TestFORUM in new eGroupware install By: Ilia on Mon, 04 September 2006 13:49
		Re: Trouble with TestFORUM in new eGroupware install By: mbeazley on Mon, 04 September 2006 14:45
		Re: Trouble with TestFORUM in new eGroupware install By: Ilia on Mon, 04 September 2006 14:50
		Re: Trouble with TestFORUM in new eGroupware install By: mbeazley on Mon, 04 September 2006 16:05
		Re: Trouble with TestFORUM in new eGroupware install By: mbeazley on Mon, 04 September 2006 18:54
		Re: Trouble with TestFORUM in new eGroupware install By: janos on Tue, 05 September 2006 00:11
		Re: Trouble with TestFORUM in new eGroupware install By: mbeazley on Tue, 05 September 2006 00:30
		Re: Trouble with TestFORUM in new eGroupware install By: janos on Tue, 05 September 2006 01:54
		Re: Trouble with TestFORUM in new eGroupware install By: mbeazley on Tue, 05 September 2006 02:04

Previous Topic:	Installation and tips for several languages on the same page
Next Topic:	post attachments don't work

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 01:42:54 GMT 2024

Total time taken to generate the page: 0.03856 seconds