[inciarco]

I Uploaded Files and Overwrited Product but an Error is Happening when Trying to Access "staff.php":

ZZZ is Table Prefix.

Perhaps the Table Prefix is missing on "WHERE usergroup.isstaff = " ?
(I can see the Prefix on "SELECT ZZZusergroup.usergroupid, ZZZusergroup.isstaff")

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT ZZZusergroup.usergroupid, ZZZusergroup.isstaff, ZZZusergroup.title,
COUNT(ZZZuser.userid) AS membercount
FROM ZZZusergroup
LEFT JOIN ZZZuser
ON ZZZuser.usergroupid=ZZZusergroup.usergroupid
OR FIND_IN_SET(ZZZusergroup.usergroupid, ZZZuser.membergroupids)
WHERE usergroup.isstaff = '1'
GROUP BY ZZZusergroup.usergroupid
ORDER BY ZZZusergroup.title ASC;

MySQL Error : Unknown column 'usergroup.isstaff' in 'where clause'
Error Number : 1054
Request Date : Wednesday, February 25th 2009 @ 10:39:29 AM
Error Date : Wednesday, February 25th 2009 @ 10:39:30 AM
Script : http://ZZZ/staff.php
Referrer : http://ZZZ/
IP Address : ZZZ
Username : ZZZ
Classname : ZZZDatabase
MySQL Version : 5.0.51a-community