Page 1 of 1

debug error when giving mod status

PostPosted: Sat May 20, 2006 7:52 pm
Author: ayasha
was adding a couple of moderators to my forum tonight and all went well until i was on the second one, when i was granting her permissions, i got this error

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.use' 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 : 586
File : admin_ug_auth.php


any help would be appreciated <img>

PostPosted: Sun May 21, 2006 10:36 am
Author: ayasha
can someone help with this? <img>

Re: debug error when giving mod status

PostPosted: Thu May 25, 2006 6:20 am
Author: Skywalker
got the same error in the past don't know exactly wat was causing it on my board i thougt when i deleted a user out of a moderator group.
when i used reset user level mod the problem was solved

PostPosted: Thu May 25, 2006 6:51 am
Author: Adrian Rea

PostPosted: Thu May 25, 2006 7:11 am
Author: ayasha
sorry A, it did not help me <img>