| Author |
Message |
Citore |
|
Post subject: PHPBB Permission Error
 Posted: Apr 08, 2009 - 08:40 PM
|
|
Joined: Jul 11, 2008
Posts: 16
Status: Offline
|
|
Hi all...
I am trying to give permissions to 1 user to be able to moderate some of my forums.
It seems fine on everyone except for 1 particular user. Everyone else seems to work just fine.
When I try to give him moderator status I get the following:
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.' 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 : 529
File : admin_ug_auth.php
If you have the answer - please go step by step for me 
FYI - I did have 1 "group" set up - I had no idea what it was and due to this error I simply removed it. I'm still getting the error.
Thank you all in advance. |
|
|
| |
|
|
|
 |
|
Citore |
|
|
Post subject: RE: PHPBB Permission Error
Posted: Apr 08, 2009 - 08:40 PM
|
|
Joined: Jul 11, 2008
Posts: 16
Status: Offline
|
|
| Just in case - but I realize nobody would have access: www.immortalreigns.com |
|
|
| |
|
|
|
|
|
mars |
|
|
Post subject: RE: PHPBB Permission Error
Posted: Apr 08, 2009 - 09:21 PM
|
|
Site Admin
Joined: Aug 15, 2004
Posts: 4277
Status: Offline
|
|
|
|
|
|
|
Citore |
|
|
Post subject: RE: PHPBB Permission Error
Posted: Apr 08, 2009 - 10:12 PM
|
|
Joined: Jul 11, 2008
Posts: 16
Status: Offline
|
|
I had seen that as well. I looked at quite a few forums, but Mars...you have a way of putting things in an easier way
That link refers to all users having the issue. I just have it on one. The strange thing is that it was just working last week.
I basically went to add another moderator to a forum and noticed his name gone - I then tried to add him on and that's when I get the error. But, it seems that all my other users can be added or removed as moderators.
I think I'll recommend that we remove that user and just add him back in - I doubt he has much in there that needs saving. I'll let you all know if that works.
Mars - thanks as always for your quick responses! |
|
|
| |
|
|
|
|
|
mars |
|
|
Post subject: RE: PHPBB Permission Error
Posted: Apr 09, 2009 - 12:17 AM
|
|
Site Admin
Joined: Aug 15, 2004
Posts: 4277
Status: Offline
|
|
| Glad to help |
|
|
| |
|
|
|
|
|
|
|
|
FAQ
Search
Register
Log in to check your private messages
Log in
