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

Home » FUDforum Development » Bug Reports » SQL error?
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
SQL error? [message #23654] Fri, 25 March 2005 10:53 Go to next message
likesthisforum   United States
Messages: 18
Registered: March 2005
Karma: 0
Junior Member
I found this error in the error logs of a forum I setup. I personally haven't encountered it myself.

(/home/me/public_html/forum/index.php:125
/home/me/public_html/forum/index.php:225
/home/me/public_html/forum/theme/default/post.php:3457
/home/me/public_html/forum/index.php:1182
) 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 'ORDER BY user_id ASC LIMIT 1' at line 1
Query: SELECT group_cache_opt, 0 as md FROM fud26_group_cache WHERE user_id IN(0,2147483647) AND resource_id= ORDER BY user_id ASC LIMIT 1
_GET: t=post&frm_id=2&rid=0&S=8bb57d92fcd187138d54eeb4139cd5b7&
Server Version: 4.0.22-standard
Re: SQL error? [message #23665 is a reply to message #23654] Fri, 25 March 2005 19:28 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
What version of the forum? How many instances of this particular error did you find?

FUDforum Core Developer
Re: SQL error? [message #23672 is a reply to message #23665] Fri, 25 March 2005 20:57 Go to previous messageGo to next message
likesthisforum   United States
Messages: 18
Registered: March 2005
Karma: 0
Junior Member
FUDForum 2.6.12. In the SQL error log, I found this specific SQL error about 3 times so far at the same URL each time.

[Updated on: Fri, 25 March 2005 20:57]

Report message to a moderator

Re: SQL error? [message #23695 is a reply to message #23672] Sat, 26 March 2005 15:14 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
fixed in cvs.

The bug is likely due to an orphen topic, running consistency checker should make it go away.


FUDforum Core Developer
Re: SQL error? [message #23709 is a reply to message #23695] Sun, 27 March 2005 01:08 Go to previous message
likesthisforum   United States
Messages: 18
Registered: March 2005
Karma: 0
Junior Member
Ok. I ran the consistency checker and applied your patch. Thanks.
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: 0.0.0.0 posting IP in FUDForum 2.6.12?
Next Topic: Error after deleting smilies - index.php:137 post.php:2140 post.php:4147 index.php:412 - SQL 1064
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 02:22:20 GMT 2024

Total time taken to generate the page: 0.02303 seconds