![]() |
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.postusername, thread.postuserid, thread.iconid, IF(views<=replycount, replycount+1, views) AS views, thread.visible, thread.open, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM ill_thread AS thread LEFT JOIN illl_user AS user ON (user.username = thread.lastposter) WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open != '10' AND thread.forumid NOT IN(111,180,181,201,213,214,215,216,217,218,219,220 ,222,223,162,165,166,167,198,2 03,204,205,206,208,116,194,171,207,221,193,195,196 ,) ORDER BY lastpost DESC LIMIT 0, 10; MySQL Error : 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 lastpost DESC LIMIT 0, 10' at line 9 Error Number : 1064 Request Date : Monday, September 28th 2009 @ 03:02:32 AM Error Date : Monday, September 28th 2009 @ 03:02:32 AM HOw to solve this issue.. |
That does not look to be a default vbulletin query. Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php PHP Code:
|
plus the sql has some typos:
in the line: "AND thread.forumid NOT IN(111,180,181,201,213,214,215,216,217,218,219,220 ,222,223,162,165,166,167,198,2 03,204,205,206,208,116,194,171,207,221,193,195,196 ,)" --there should not be a trailing comma in the list --you have a space between the 2 and 03 in the list that should be 203: you have "98,2 03,204" and it should be "98,203,204" (he thinks whitespace is a value delimiter). when i fix those two, he stops complaining. |
All times are GMT. The time now is 09:01 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|