[Taurus1]

Database error in vBulletin 4.1.8:

Invalid SQL:

SELECT COUNT(*) AS count
FROM vbuserlist
WHERE userlist.userid = 5798
AND userlist.relationid IN
(
SELECT relationid
FROM vbuserlist
WHERE userlist.userid = 3
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'
)
AND userlist.type = 'buddy'
AND userlist.friend = 'yes';

MySQL Error : Unknown column 'userlist.userid' in 'where clause'
Error Number : 1054
Request Date : Saturday, December 17th 2011 @ 11:15:18 PM
Error Date : Saturday, December 17th 2011 @ 11:15:18 PM
Script : ******************
Referrer : ****************
IP Address : *************
Username : ***********
Classname : vB_Database
MySQL Version : 5.1.56-log

Please advise. Thanks.