I'm getting this error and I have no idea why. Does anyone know how I can fix this? Many thanks
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT attachment.attachmentid, thread.threadid, thread.title
FROM vb3_attachment AS attachment
LEFT JOIN vb3_post AS post ON (attachment.postid=post.postid)
LEFT JOIN vb3_thread AS thread ON (post.threadid=thread.threadid)
WHERE attachment.extension IN ('bmp','gif','jpe','jpeg','jpg','png') AND thread.forumid NOT IN(44,42,129,87,,40,87,101,129)
ORDER BY rand()
LIMIT 0, 10;
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 '40,87,101,129)
ORDER BY rand()
LIMIT 0, 10' at line 5
Error Number : 1064
Request Date : Thursday, January 8th 2009 @ 02:32:16 PM
Error Date : Thursday, January 8th 2009 @ 02:32:18 PM
Script :
http://www.rwf-forum.co.uk/vBulletin...splay.php?f=70
Referrer :
IP Address : xx.xx.xxx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :