When i turn on Admin Blocks:
Code:
Datenbankfehler in vBulletin 4.0.1:
Invalid SQL:
SELECT user.userid, user.username, user.usertitle
FROM user
JOIN usergroup AS ugroup
ON ugroup.usergroupid=user.usergroupid
LEFT JOIN usergroup
ON (FIND_IN_SET(usergroup.usergroupid, user.membergroupids))
WHERE ugroup.usergroupid=6,2,7,5 OR usergroup.usergroupid=6,2,7,5
GROUP BY user.userid
ORDER BY RAND()
LIMIT 4;
MySQL-Fehler : 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 '2,7,5 OR usergroup.usergroupid=6,2,7,5
GROUP BY user.userid
ORDER BY RAN' at line 7
Fehler-Nr. : 1064
Fehler-Zeit : Monday, 18.01.2010 @ 17:29:03
Datum : Monday, 18.01.2010 @ 17:29:03
Admins Usergoup = 6
Usergoup = all other and 6
When i turn off admin block and usergroup all is ok.
Only ADmin blocks or Usergroups = error
EDIT: I can only change one Group, not more.
Then it goes when i add one group, bu i will change more
EDIT2: Top Posters (Overall) is the Wrong User