Code:
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT thread.threadid
FROM thread AS thread
LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN vault_link AS link ON (link.postid = thread.firstpostid)
WHERE forum.vault_type > 0
AND link.redirect = 1
WHERE thread.forumid IN(41, 28, 29, 35, 37, 38, 40, 42, 23, 22, 3, 12, 9, 34, 20, 13, 4, 18, 7, 8, 17, 16, 5, 10, 19, 11, 21, 14, 15)
AND thread.visible IN (0,1,2)
AND thread.sticky IN (0,1)
AND thread.open <> 10
ORDER BY thread.lastpost DESC
LIMIT 500;
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 'WHERE thread.forumid IN(41, 28, 29, 35, 37, 38, 40, 42, 23, 22, 3, 12, 9, 34, 20' at line 7
Error Number : 1064
Request Date : Monday, October 27th 2008 @ 08:42:28 PM
Error Date : Monday, October 27th 2008 @ 08:42:28 PM
Script : http://www.bluedragons.co.uk/forums/search.php?do=getnew
Referrer : http://www.bluedragons.co.uk/forums/private.php?do=showpm&pmid=2243
IP Address : 89.240.105.190
Username : Vimto
Classname : vB_Database
MySQL Version : 4.1.20-log