[tidefans]

I am getting this same error

Originally Posted by sgrisole

I installed version 3.2 and now I get the following error when visiting staff.php

Database error in vBulletin 3.7.4:

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 A' at line 2
Error Number  : 1064
Request Date  : Saturday, March 14th 2009 @ 11:43:48 AM
Error Date    : Saturday, March 14th 2009 @ 11:43:48 AM
Classname     : vB_Database
MySQL Version : 5.0.67-community

I tried to uninstall / reinstall the product several times but it didn't fix the problem...
BTW is the PRO version available somewhere?