Database error in vBulletin 3.8.5:
 

Database error in vBulletin 3.8.5:

Invalid SQL:

SELECT IF(visible = 2, 1, 0) AS isdeleted,


NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,
thread.*


FROM thread AS thread

LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = AND subscribethread.canview = 1)




WHERE thread.threadid = 7479;

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 subscribethread.canview = 1)




WHERE thread.threadid = 7479' at line 10
Error Number : 1064
Request Date : Tuesday, June 8th 2010 @ 09:42:46 AM
Error Date : Tuesday, June 8th 2010 @ 09:42:46 AM
Script : http://forums.cgway.net/newreply.php...uote=1&p=71966
Referrer : http://forums.cgway.net/cg7479/
IP Address : 77.31.222.122
Username : SA7ORA
Classname : vB_Database
MySQL Version :


please help