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]

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.