Uninstalled everything, removed field isstaff, removed all files from /forum and sub folders, re-upped all files from 3.2, reinstalled 3.2 Ok, but:
1) Not showing options in ADMINCP to choose staff groups; the only settings that shows it's in attachment image;
2) When opening /forum/staff.php, still showing the following error:
Code:
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT vb_usergroup.usergroupid, vb_usergroup.isstaff, vb_usergroup.title,
COUNT(vb_user.userid) AS membercount
FROM vb_usergroup AS usergroup
LEFT JOIN vb_user AS user
ON vb_user.usergroupid=vb_usergroup.usergroupid
OR FIND_IN_SET(vb_usergroup.usergroupid, vb_user.membergroupids)
WHERE vb_usergroup.isstaff = '1'
GROUP BY vb_usergroup.usergroupid
ORDER BY vb_usergroup.title ASC;
MySQL Error : Unknown column 'vb_usergroup.usergroupid' in 'field list'
Error Number : 1054
Request Date : Friday, February 27th 2009 @ 09:09:32 AM
Error Date : Friday, February 27th 2009 @ 09:09:32 AM
Script : http://bfcentral.oi.com.br/forum/staff.php
Referrer : http://bfcentral.oi.com.br/forum/showgroups.php
IP Address : 32.104.18.240
Username : S.Templar
Classname : vB_Database
MySQL Version : 5.0.45-log
Note that all values in field "isstaff" in DB is 0, because i can't choose any staff groups from hack settings.
UPDATE: Manually changed Administrator group isstaff field from 0 to 1, in my DB. But the DB error stills the same:
Code:
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT vb_usergroup.usergroupid, vb_usergroup.isstaff, vb_usergroup.title,
COUNT(vb_user.userid) AS membercount
FROM vb_usergroup AS usergroup
LEFT JOIN vb_user AS user
ON vb_user.usergroupid=vb_usergroup.usergroupid
OR FIND_IN_SET(vb_usergroup.usergroupid, vb_user.membergroupids)
WHERE vb_usergroup.isstaff = '1'
GROUP BY vb_usergroup.usergroupid
ORDER BY vb_usergroup.title ASC;
MySQL Error : Unknown column 'vb_usergroup.usergroupid' in 'field list'
Error Number : 1054
Request Date : Friday, February 27th 2009 @ 09:16:21 AM
Error Date : Friday, February 27th 2009 @ 09:16:21 AM
Script : http://bfcentral.oi.com.br/forum/staff.php
Referrer :
IP Address : 32.104.18.240
Username : S.Templar
Classname : vB_Database
MySQL Version : 5.0.45-log
Back to 3.1 working like a charm!