Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT tf_usergroup.usergroupid, tf_usergroup.isstaff, tf_usergroup.title,
COUNT(tf_user.userid) AS membercount
FROM tf_usergroup
LEFT JOIN tf_user
ON tf_user.usergroupid=tf_usergroup.usergroupid
OR FIND_IN_SET(tf_usergroup.usergroupid, tf_user.membergroupids)
WHERE usergroup.isstaff = '1'
GROUP BY tf_usergroup.usergroupid
ORDER BY tf_usergroup.title ASC;
MySQL Error : Unknown column 'usergroup.isstaff' in 'where clause'
Error Number : 1054
Request Date : Wednesday, June 3rd 2009 @ 10:50:38 PM
Error Date : Wednesday, June 3rd 2009 @ 10:50:38 PM
Script :
http://www.x.net
Referrer :
http://www.x.net
IP Address : xxx.xxx.xxx.xxx
Username : xx
Classname : vB_Database
MySQL Version : 5.0.67.d7-ourdelta-log