Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT vb_usergroup.usergroupid, vb_usergroup.isstaff, vb_usergroup.title,
COUNT(vb_user.userid) AS membercount
FROM vb_usergroup
LEFT JOIN vb_user
ON vb_user.usergroupid=vb_usergroup.usergroupid
OR FIND_IN_SET(vb_usergroup.usergroupid, vb_user.membergroupids)
WHERE usergroup.isstaff = '1'
GROUP BY vb_usergroup.usergroupid
ORDER BY vb_usergroup.title ASC;
MySQL Error : Unknown column 'usergroup.isstaff' in 'where clause'
Error Number : 1054
Request Date : Thursday, February 26th 2009 @ 03:03:58 PM
Error Date : Thursday, February 26th 2009 @ 03:03:58 PM
Script :
http://bfcentral.oi.com.br/forum/staff.php
Referrer :
http://bfcentral.oi.com.br/forum/
IP Address : 32.104.18.240
Username : S.Templar
Classname : vB_Database
MySQL Version : 5.0.45-log
Using 3.2 on a 3.8.1 board