When opening /forum/staff.php, the following error:
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff
COUNT(user.userid) AS membercount
FROM vB_usergroup AS usergroup
LEFT JOIN vB_user AS user ON (user.usergroupid = usergroup.usergroupid) OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids)
WHERE usergroup.isstaff = '1'
GROUP BY usergroup.usergroupid
ORDER BY usergroup.title ASC;
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 'COUNT(user.userid) AS membercount
FROM vB_usergroup AS usergroup
LEFT JOIN vB_' at line 2
Error Number : 1064
Request Date : Saturday, February 28th 2009 @ 11:58:27 AM
Error Date : Saturday, February 28th 2009 @ 11:58:28 AM
Script :
http://xxx/staff.php
Referrer :
http://xxx/index.php
IP Address : 91.207.170.131
Username : Martell
Classname : vb_database
MySQL Version : 4.1.22