SQL Error : 1064 Could not obtain moderator status

spurtus · Regular Joined: May 13, 2006 Posts: 89

I have looked all through the threads on the Sql 1064 error, but nothing seems to match this case, so thought I would ask. Here is the error:

Quote:

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

I get this error when I am trying to make a member of my site a moderator for a specific forum. I can make ANYONE ELSE a moderator of that forum, just not this one guy. Is there anything magic in this error that may pinpoint me to a "why" this is happening? Is it a data integrity issue, possibly, in the DB?

Note: I cannot make this person a moderator of ANY forum...without same error.

Thanks for any help you can give me.

Spurt

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4887

The problem is that there is nothing in the IN clause:

Code:

...IN ()...

Not sure why that's the case - have you defined any groups? Assigned any users to groups?

evaders99 · Moderator Joined: Apr 30, 2004 Posts: 2853

The fixgroup script will fix this issue

Doulos · Involved Joined: Jun 06, 2005 Posts: 373

The fixgroup link to NukeFixes is not active. Any other place to get this fix?

Susann · Posted: Thu Sep 14, 2006 7:17 am

I had this error on line 530 in admin_ug_auth.php too and its fixed.

Check this:

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

Doulos · Involved Joined: Jun 06, 2005 Posts: 373

A couple of the groups had user 5 as the moderator. I changed them to 2 (me) and still get the following error when I try to change the permissions of users:

Quote:

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

The weird thing is that if I change the users permissions before I add them to a group everything works fine. If I add them to a group and then try to change the users permissions I get the above error. Also, I tried removing the user from the group and then set the user permissions - but I still get the error. Sad

Getting frustrated.

I guess I don't understand what it is you are saying I need to do, Suzanne.

Susann · Posted: Fri Sep 15, 2006 8:23 am

Because the error is known since 2005 I believe there are several places to download the fixgroup zip.
I did´t use the zip. I fixed my different group errors long time ago deleted some old groups, added moderators through the administration changed the number in the database table etc.
Maybe this is interesting:

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

Doulos · Involved Joined: Jun 06, 2005 Posts: 373

Is this issue something that would be fixed with an upgrade to RN 20202? (currently using RN76 or 1.5 not sure which)

Susann · Posted: Fri Sep 15, 2006 4:44 pm

I thought you are using 7.5. In the newest release of RavenNuke are several fixes
from Evaders and Montego but in 2.02.02 I had these errors with the group moderator.
Did you tried to solve this with the fix in modules/Forums/admin/admin_ug_auth.php:

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

But make a backup !

Doulos · Involved Joined: Jun 06, 2005 Posts: 373

Oh sorry I thought I put that in my post....guess not. I suppose that is what the "Preview" button is for.

I used the fix presented here....

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

The first set of changes were already in place. I then did the fixgroups.php thingy and now it works. Thanks.

ccac · Hangin' Around Joined: May 23, 2006 Posts: 36

Quote:

I used the fix presented here....http://www.karakas-online.de/forum/viewtopic.php?t=3264

Is this also the fix for RavenNuke 7.6 2.02.02 ?

I dont want to screw anything up...

Thanks!!

montego · Posted: Thu Sep 28, 2006 5:42 am

Yes, it is the same fix. We have modified the installation process within RN 2.10.00 from '5' to '2' as well.

Evaders, do you recall how this issue was originally introduced? Is it only an issue with the core nuke SQL file or is there also a code change needed somewhere to ensure that after setup, this doesn't happen again?

evaders99 · Moderator Joined: Apr 30, 2004 Posts: 2853

I believe it came from the core Nuke SQL file.
The other issue is that older phpNuke systems did not have an INSERT for the groups table when an account was created. Thus the forums cannot set any special permissions to them. Essentially the entire permissions in phpBB for groups and users runs the same way

montego · Posted: Fri Sep 29, 2006 6:22 pm

Evaders, would you please look at fkelly's thread in the private RN 2.10.00 forum related to the upgrading of the DB and let him know to do to fix this for folks upgrading from 2.02.02 to 2.10.00? Thanks!

ccac · Hangin' Around Joined: May 23, 2006 Posts: 36

worked for me - thanks!