
03-15-2006, 12:52 AM
|
 |
|
|
Join Date: Jan 2003
Location: United States
Posts: 872
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Also getting an error.
It happens when editing a custom mod group in 3.5.4:
Quote:
Invalid SQL:
INSERT INTO moderator (userid, forumid, permissions, moderatorusergroupid, modusergroupid)
SELECT user.userid, moderatorusergroup.forumid, moderatorusergroup.permissions, moderatorusergroup.moderatorusergroupid, moderatorusergroup.usergroupid
FROM moderatorusergroup AS moderatorusergroup
LEFT JOIN user AS user ON (user.usergroupid=moderatorusergroup.usergroupid OR FIND_IN_SET(moderatorusergroup.usergroupid, user.membergroupids))
LEFT JOIN moderator AS moderator ON (moderator.userid=user.userid AND moderator.moderatorusergroupid=moderatorusergroup. moderatorusergroupid)
WHERE ISNULL(moderator.userid) AND (NOT ISNULL(user.userid)) AND moderatorusergroup.moderatorusergroupid=3;
MySQL Error : Not unique table/alias: 'moderator'
|
|