Database error in vBulletin 3.0.0 Beta 5:
Invalid SQL:
### QUERY THREAD IDS FROM POST TABLE ###
SELECT postid, threadid, visible AS postvisible
FROM post AS post
LEFT JOIN deletionlog AS delpost ON(delpost.primaryid = post.postid AND delpost.type = 'post')
WHERE (postid IN(6436, 6532, 6551, 392723, 476641) OR postid IN(244139, 258276, 299078, 401856, 402288, 417874, 448177, 456959) OR postid IN())
AND delpost.primaryid IS NULL
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 '))
AND delpost.primaryid IS NULL' at line 5
mysql error number: 1064
Date: Monday 01st of September 2003 01:37:05 AM
Script: http://www.sitename.com/search.php
Referer: http://www.sitename.com/search.php?
Username: username
IP Address: xx.xx.xx.xx.xx
Any help on this would be appreciated.
Cheers.
M1th
Invalid SQL:
### QUERY THREAD IDS FROM POST TABLE ###
SELECT postid, threadid, visible AS postvisible
FROM post AS post
LEFT JOIN deletionlog AS delpost ON(delpost.primaryid = post.postid AND delpost.type = 'post')
WHERE (postid IN(6436, 6532, 6551, 392723, 476641) OR postid IN(244139, 258276, 299078, 401856, 402288, 417874, 448177, 456959) OR postid IN())
AND delpost.primaryid IS NULL
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 '))
AND delpost.primaryid IS NULL' at line 5
mysql error number: 1064
Date: Monday 01st of September 2003 01:37:05 AM
Script: http://www.sitename.com/search.php
Referer: http://www.sitename.com/search.php?
Username: username
IP Address: xx.xx.xx.xx.xx
Any help on this would be appreciated.

Cheers.
M1th
Comment