Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
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, thread.open, 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 thread.open!='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
  #2  
Old 14 Nov 2019, 20:02
Dave Dave is online now
 
Join Date: Jun 2010
Real name: Dave
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.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
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 : 114.99.3.20
Username : Neregistrovan
Classname : vB_Database_MySQLi
MySQL Version :
Reply With Quote
  #4  
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
Reply



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

Layout Options | Width: Wide Color: