Database error

[RichieBoy67]

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

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

PHP Code:

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.