[inciarco]

Originally Posted by atmaca

I'm upgradeded to v3.2 and then getting db error:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT usergroup.usergroupid, usergroup.title, usergroup.isstaff
COUNT(user.userid) AS membercount
FROM usergroup AS usergroup
LEFT JOIN 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 usergroup AS usergroup
LEFT JOIN user AS ' at line 2
Error Number  : 1064
Request Date  : Monday, March 16th 2009 @ 07:25:54 PM
Error Date    : Monday, March 16th 2009 @ 07:25:54 PM
Script        : ...../staff.php
Referrer      : .../index.php
IP Address    : ...
Username      : Supervisor
Classname     : vB_Database
MySQL Version : 5.0.45

Read the Last Posts of this Thread regarding the Addition of a Comma on the staff.php File, it Solves all the Problems Regarding this Last Update of the Mod.

Thanks Hasann for the Update, with the Comma Solution provided by sheppardzwc a few Posts Above the Mod Works Fine and the New Features are Really Nice. :up:

My Best Regards.