PDA

View Full Version : Database error help me plsss

samet54
03-22-2008, 11:17 PM
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT thread.threadid, thread.title AS title, thread.notes AS notes,
thread.forumid AS forumid, thread.postuserid AS userid,
thread.postusername AS username, thread.dateline, thread.firstpostid, pagetext
FROM thread AS thread
LEFT JOIN post AS post ON(thread.firstpostid = post.postid)
WHERE (1 = 0 OR 1=1) AND thread.threadid IN()
ORDER BY thread.lastpost;

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 thread.lastpost' at line 6
Error Number : 1064
Date : Sunday, March 23rd 2008 @ 12:14:04 AM
Script : http://www.belesciforum.com/modcp/moderate.php?do=posts
Referrer : http://www.belesciforum.com/xxxx/index.php?do=nav
IP Address :
Username :
Classname :

--------------- Added 1206232220 at 1206232220 ---------------

help meee
Total666
03-23-2008, 12:32 AM
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT thread.threadid, thread.title AS title, thread.notes AS notes,
thread.forumid AS forumid, thread.postuserid AS userid,
thread.postusername AS username, thread.dateline, thread.firstpostid, pagetext
FROM thread AS thread
LEFT JOIN post AS post ON(thread.firstpostid = post.postid)
WHERE (1 = 0 OR 1=1) AND thread.threadid IN()
ORDER BY thread.lastpost;

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 thread.lastpost' at line 6
Error Number : 1064
Date : Sunday, March 23rd 2008 @ 12:14:04 AM
Script : http://www.belesciforum.com/modcp/moderate.php?do=posts
Referrer : http://www.belesciforum.com/xxxx/index.php?do=nav
IP Address :
Username :
Classname :

--------------- Added 1206232220 at 1206232220 ---------------

help meee


I'm getting the same error :( sometimes
Guest210212002
03-23-2008, 01:27 AM
MySQL 1064 is a version mismatch, iirc.
Dismounted
03-23-2008, 06:03 AM
The error is pointing to this part of the error:
thread.threadid IN()
The brackets after IN should not be empty, but somehow, it is. Unless you have modified the code, I don't believe this error is possible. Try disabling your modifications.
samet54
03-23-2008, 06:42 AM
somehow to smooth how to do
Marco van Herwaarden
03-23-2008, 10:50 AM
To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.