Trying to give member private forum access ?

Client Joined: Dec 04, 2004 Posts: 757

Hello all, I have set up a private forum on my site and have been giving members permissions to be able to use it, unfortunately I got a few that when I try to add them I get 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.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 : 559
File : admin_ug_auth.php

any idea`s where to start?

cheers all
mrix

Posted: Tue Mar 25, 2008 3:10 pm

Try the fixgroup script

Posted: Tue Mar 25, 2008 3:11 pm

Try the fixgroup script ?

Where would I find that?

thanks
mrix

Posted: Tue Mar 25, 2008 7:04 pm

mrix, I don't mean to be rude, but I used "fixgroup script" in the Google search of RavenPHPScripts above and the very first link on that results has a link to where to get it... Sad

Posted: Wed Mar 26, 2008 3:43 am

Sorry I havnt responed to this post, I did the same thing and the fix worked fine, what a script! Very Happy

many thanks for the help
cheers
mrix