
04-24-2009, 07:03 PM
|
|
|
Join Date: Feb 2006
Location: Netherlands
Posts: 1,392
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Why do I get:
Quote:
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 : Friday, April 24th 2009 @ 10:02:41 PM
Error Date : Friday, April 24th 2009 @ 10:02:41 PM
|
?
Heck, can't even uninstall this:
Quote:
Database error in vBulletin 3.8.1:
Invalid SQL:
ALTER TABLE usergroup DROP staff;
MySQL Error : Can't DROP 'staff'; check that column/key exists
|
|