FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Trouble with TestFORUM in new eGroupware install
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Trouble with TestFORUM in new eGroupware install [message #33478] Mon, 04 September 2006 09:27 Go to next message
mbeazley is currently offline  mbeazley   United States
Messages: 10
Registered: September 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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
Re: Trouble with TestFORUM in new eGroupware install [message #33486 is a reply to message #33478] Mon, 04 September 2006 09:49 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
This block
CASE WHEN 0 < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END


Needs to be in brackets.


FUDforum Core Developer
Re: Trouble with TestFORUM in new eGroupware install [message #33495 is a reply to message #33486] Mon, 04 September 2006 10:45 Go to previous messageGo to next message
mbeazley is currently offline  mbeazley   United States
Messages: 10
Registered: September 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thanks for the reply. I'll need a bit more guidance. How and where do I make this correction?
Re: Trouble with TestFORUM in new eGroupware install [message #33496 is a reply to message #33495] Mon, 04 September 2006 10:50 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Open the /opt/lampp/htdocs/egroupware/fudforum/3814588639/theme/default/thread.php file, find the failed query and surround the CASE ... END statement in parenthesis.

FUDforum Core Developer
Re: Trouble with TestFORUM in new eGroupware install [message #33498 is a reply to message #33496] Mon, 04 September 2006 12:05 Go to previous messageGo to next message
mbeazley is currently offline  mbeazley   United States
Messages: 10
Registered: September 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thanks for the quick replies. Followed your instructions. Received this output when attempting to run TestFORUM as 'admin':

(/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
Re: Trouble with TestFORUM in new eGroupware install [message #33500 is a reply to message #33498] Mon, 04 September 2006 14:54 Go to previous messageGo to next message
mbeazley is currently offline  mbeazley   United States
Messages: 10
Registered: September 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
OK. Fixed it! Here's what I did:

1. Replaced 'reads' in 'thread_common.inc.t' with another word.
2. Ran all Checks/Consistency scripts in the FUDforum Admin Control Panel.
3. Re-opened FUDforum and TestFORUM works fine.
Re: Trouble with TestFORUM in new eGroupware install [message #33503 is a reply to message #33478] Mon, 04 September 2006 20:11 Go to previous messageGo to next message
janos is currently offline  janos   Germany
Messages: 2
Registered: September 2006
Location: Frankfurt
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
that is a joke or i am blind, there is no 'thread_common.inc.t' on my system.

Ich have the same Problem on 3 Systems, someone knows a solution?


Re: Trouble with TestFORUM in new eGroupware install [message #33504 is a reply to message #33503] Mon, 04 September 2006 20:30 Go to previous messageGo to next message
mbeazley is currently offline  mbeazley   United States
Messages: 10
Registered: September 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Nope. It's not a joke. Here's the thread that got me pointed in the right direction:

forum/index.php?t=msg&goto=29421&&srch=thread_common.inc.t#msg_ 29421

I'm new to this, but would be happy to try to help.

Mark
icon14.gif  Re: Trouble with TestFORUM in new eGroupware install [message #33505 is a reply to message #33478] Mon, 04 September 2006 21:54 Go to previous messageGo to next message
janos is currently offline  janos   Germany
Messages: 2
Registered: September 2006
Location: Frankfurt
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
forumsel.inc.t reads -> egal and it works, thanks! Very Happy
icon12.gif  Re: Trouble with TestFORUM in new eGroupware install [message #33506 is a reply to message #33505] Mon, 04 September 2006 22:04 Go to previous message
mbeazley is currently offline  mbeazley   United States
Messages: 10
Registered: September 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Excellent news!!!
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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) ] [ RSS ]

Current Time: Thu Jul 19 06:01:31 EDT 2018

Total time taken to generate the page: 0.00771 seconds