Database error

[RichieBoy67]

Hey all, I hope everyone is having a great holiday season.

I am getting some of these lately. Any ideas??

Database error in vBulletin 4.1.7: Invalid SQL: SELECT IF(thread.visible = 2, 1, 0) AS isdeleted, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid, post.pagetext AS description, thread.* FROM vb_thread AS thread LEFT JOIN vb_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = AND subscribethread.canview = 1) LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid) WHERE thread.threadid = 2127; 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) LEFT JOIN vb_post AS post ON(post.po' at line 11 Error Number : 1064

Thanks,
Richie

[kh99]

Well, it looks like it comes from function fetch_threadinfo() in includes/functions.php, and the problem is that $vbulletin->userinfo['userid'] is blank. But that function is called from a lot of places so I have no idea why it would happen.

[RichieBoy67]

Thanks much friend.

Yeah, I know it functions.php but I am still trying to figure out why..It happens when members are in cms and sometimes searching.

[kh99]

Yeah, sorry, I knew that wasn't going to be a lot of help. Maybe someone else will recognize the error.

[RichieBoy67]

haha, oh no, I didn't mean it like that. I really appreciate the reply mate. Thanks for trying.