SQL error? [message #23654] |
Fri, 25 March 2005 10:53 |
likesthisforum
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 |
Ilia
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 #23695 is a reply to message #23672] |
Sat, 26 March 2005 15:14 |
Ilia
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
|
|
|
|