https://www.icyphoenix.com/viewtopic.php?f=35&t=3939&p=26753#p26753
-----------------------------------
Chaotic
Tue 25 Mar, 2008 00:43

Re: Removing Administrator Rights
-----------------------------------
I made that change and got this error when trying to change the administrator to a user via ACP -> USERS -> PERMISSIONS :

[spoiler]Could not obtain moderator status

DEBUG MODE

SQL Error : 1064 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 ') AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug' at line 3

SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod FROM phpbb_auth_access aa, phpbb_user_group ug WHERE ug.user_id IN () AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_id

Line : 516
File : admin_ug_auth.php[/spoiler]


