Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 14 Nov 2019, 19:46
Milance Milance is offline
Join Date: Jun 2011
vBulletin Database Error

I have a problem. I'm getting an error message on the email.

Database error in vBulletin 4.2.4:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible,, user.usergroupid, user.displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND!='10' AND thread.forumid NOT IN(3,)
ORDER BY lastpost DESC
LIMIT 0, 15;

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, 15' at line 4
Error Number : 1064
Reply With Quote
Old 14 Nov 2019, 20:02
Dave Dave is offline
Join Date: Jun 2010
Does it say in which PHP script and line number it happens? I tried looking for that SQL query in the default vBulletin 4 files but was unable to find it.
Reply With Quote
Old 14 Nov 2019, 20:07
Milance Milance is offline
Join Date: Jun 2011
Request Date : Thursday, November 14th 2019 @ 07:47:40 PM
Error Date : Thursday, November 14th 2019 @ 07:47:41 PM
Script : http://www.!!!!!/forumdisplay.php?f=16
Referrer :
IP Address :
Username : Neregistrovan
Classname : vB_Database_MySQLi
MySQL Version :
Reply With Quote
Old 16 Nov 2019, 01:49
x iJailBreak x's Avatar
x iJailBreak x x iJailBreak x is offline
Join Date: Jan 2011
Sounds like a plugin issue - try disabling each product one by one until you figure out which product is causing the issue. It'll help narrow down the issue massively.
Professional web developer & sysadmin. Former bad man.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 19:09.

Layout Options | Width: Wide Color: