vBulletin Mods

The Official vBulletin Modifications Site

Database error in vBulletin 3.8.1:
28 Sep 2009 18:44

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..

Lynne 28 Sep 2009 19:58

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

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

gmerin 31 Oct 2009 20:56

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 15:09.

Powered by vBulletin® Version 3.8.14
Copyright © 2021, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.