error with admin_ug_auth.php when removing admin rights

lonk · Regular Joined: Aug 04, 2006 Posts: 60

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

Susann · Posted: Thu Jul 19, 2007 6:32 pm

Maybe this helps:

Only registered users can see links on this board!
Get registered or login to the forums!

rsebes · New Member Joined: Oct 15, 2008 Posts: 4

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

Susann · 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 to the forums!

rsebes · New Member Joined: Oct 15, 2008 Posts: 4

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

Susann · 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.

rsebes · New Member Joined: Oct 15, 2008 Posts: 4

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

montego · 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"

rsebes · New Member Joined: Oct 15, 2008 Posts: 4

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