View Single Post
  #1  
Old 28 Sep 2009, 18:44
PHILIPS-08 PHILIPS-08 is offline
 
Join Date: May 2008
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..
Reply With Quote