Database error

[pallam]

Greetings I have this problem and how to fix it please help Thans in advance ..

Database error in vBulletin 4.2.5:

Invalid SQL:

SELECT
thread.forumid as forumid, thread.visible, post.title as title, thread.threadid as threadid, thread.replycount, thread.dateline, post.postid, post.pagetext as pagetext, icon.iconid, post.iconid as iptal, attachment.attachmentid AS attachmentid
FROM prince_thread as thread
LEFT JOIN prince_post as post on (thread.firstpostid = post.postid)
LEFT JOIN prince_forum as forum on (thread.forumid = forum.forumid)
LEFT JOIN prince_icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN (prince_attachment AS attachment
INNER JOIN prince_filedata AS filedata ON (attachment.filedataid = filedata.filedataid) ) ON (attachment.contentid = thread.firstpostid AND filedata.extension IN('jpg', 'gif', 'png', 'jpeg', 'bmp'))
WHERE thread.visible = 1 AND thread.dateline > 1534949270 AND thread.forumid IN (0,)
GROUP BY threadid
ORDER BY replycount DESC
LIMIT 0,6;

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 ')
GROUP BY threadid
ORDER BY replycount DESC
LIMIT 0,6' at line 9
Error Number : 1064
Request Date : Sunday, October 21st 2018 @ 02:47:50 PM
Error Date : Sunday, October 21st 2018 @ 02:47:50 PM
Script :
Referrer :
IP Address : *******
Username : Jikuu
Classname : vB_Database_MySQLi
MySQL Version : 5.6.41-84.1
Server : ********
User Agent :

[x iJailBreak x]

Originally Posted by pallam

Greetings I have this problem and how to fix it please help Thans in advance ..

Have you installed any plugins recently? It looks like something is messing with the forum IDs being retrieved in the query:

AND thread.forumid IN (0,)

That last comma in the brackets is what's causing your error.

[TheLastSuperman]

Check for modifications that allow you to list forumid's in the settings, i.e. a plugin that in the settings allows you to specify the forumid #'s of the forums to use it in etc. It appears you left it blank or removed a forumid but also forgot to remove the comma in the list.

[pallam]

Thank you guys for the help problem solved.