error with admin_ug_auth.php when removing admin rights

Regular Joined: Aug 04, 2006 Posts: 64

When i try and remove a users admin right in the forum admin panel i get this error. I can add admin rights to members but i can not remove them.

General 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.user_' at line 3

SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod FROM nuke_bbauth_access aa, nuke_bbuser_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 : 524
File : admin_ug_auth.php

Posted: Thu Jul 19, 2007 6:32 pm

Maybe this helps:
[ Only registered users can see links on this board! Get registered or login! ]

New Member Joined: Oct 15, 2008 Posts: 4

I am having the same problem but this is with phpnuke.

Posted: Wed Oct 15, 2008 5:20 pm

What Nuke and forums version ?

Backup your files and db before so that you can change it back and try the fixgroup.
[ Only registered users can see links on this board! Get registered or login! ]

Posted: Sat Oct 18, 2008 11:58 pm

Nuke 8.0 and phpbb 2.0.7 (upgraded from 2.0.6) i suppose.

Posted: Sun Oct 19, 2008 6:23 pm

Included in 8.0 is version phpBB 2.0.20.
So I guess you are wrong with your phpBB version. You can check this in the database table nuke_bbconfig.
I don´t know if the fxgroup script will work for you. But you can try it out.

Posted: Sun Oct 19, 2008 9:56 pm

well I did update my phpBB to the latest version available for my application (or so I thought)

My nuke_bbconfig doesn't contain my version

Posted: Mon Oct 20, 2008 7:04 am

rsebes wrote:

My nuke_bbconfig doesn't contain my version

Yes it does. You may need to scroll through a couple pages of data. It has a config_name value of "version" and it will look something like ".0.20"

Posted: Tue Oct 21, 2008 10:47 pm

Oh yes, silly me. I need to make sure I'm awake when checking this stuff out. My version is .0.23 Smile