I'm upgradeded to v3.2 and then getting db error:
Code:
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