Can't add moderators

[arasmama]

I'm getting an error code in forum admin when I try to add someone as a moderator. This is what is says:

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

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 : 529
File : admin_ug_auth.php

[nathan_anderson]

I'm getting an error code in forum admin when I try to add someone as a moderator. This is what is says:

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

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 : 529
File : admin_ug_auth.php


Do you have a firewall (i.e. norton or Zone alarms) running? If so can you temporarily disable them and try it again.

Nathan.

[arasmama]

I disabled my firewall and it gives me the same error. I know Meg said she gets the same error.

[nathan_anderson]

I disabled my firewall and it gives me the same error. I know Meg said she gets the same error.

Hmm, weird -- Reading the SQL, the group information isn't being transfered... I will take a look at upgrading phpnuke to see if that will fix the bug...

Nathan.