https://www.icyphoenix.com/viewtopic.php?f=35&t=5823
-----------------------------------
ankur0412
Mon 11 May, 2009 13:55

RC1 - Problem With Adding Moderators
-----------------------------------
I add new moderators to certain forums and some extra members get added as moderators to that forum. I remove them, but they don't get removed. I remove the moderators I made, and all of them get removed. Is it just me who is getting this problem or anyone else has that problem too?


-----------------------------------
Lopalong
Mon 11 May, 2009 14:28

Re: RC1 - Problem With Adding Moderators
-----------------------------------
There's nothing in the Bug Tracker, and no one else has reported it yet?

When you make your changes, try clearing the cache's. ;)


-----------------------------------
tbird412
Mon 11 May, 2009 21:40

Re: RC1 - Problem With Adding Moderators
-----------------------------------
I learned that lesson real quick in IP ... always clear the cache if you change something.   Solved half my problems.


-----------------------------------
ankur0412
Fri 15 May, 2009 18:57

Re: RC1 - Problem With Adding Moderators
-----------------------------------
Are you sure there's no problem? Because I get this error now, when i try changing any users permissions:

"Couldn't update private forum permissions

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 ' 1)' at line 2

INSERT INTO phpbb_auth_access (forum_id, group_id, auth_mod) VALUES (10, , 1)

Line : 445
File : admin_ug_auth.php"


-----------------------------------
spydie
Fri 15 May, 2009 19:03

Re: RC1 - Problem With Adding Moderators
-----------------------------------
Did you call your db phpBB ??

normaly its called ip

if not its probably an coding error


-----------------------------------
Mighty Gorgon
Sat 23 May, 2009 12:49

Re: RC1 - Problem With Adding Moderators
-----------------------------------
[quote user="ankur0412" post="39339"]INSERT INTO phpbb_auth_access (forum_id, group_id, auth_mod) VALUES (10, , 1)[/quote]
This error may be related to some errors in your groups table in the DB.

Did you upgrade from phpBB?

Or did you install from scratch?


-----------------------------------
ankur0412
Sat 23 May, 2009 12:56

Re: RC1 - Problem With Adding Moderators
-----------------------------------
Installed RC1 from the setup file you provided.


-----------------------------------
Mighty Gorgon
Sat 23 May, 2009 12:59

Re: RC1 - Problem With Adding Moderators
-----------------------------------
The script is not getting the correct group ID.

Try to update to RC2... make sure you have a backup first.

If it is not a live site, I would suggest to reinstall.


-----------------------------------
ankur0412
Sat 23 May, 2009 13:50

Re: RC1 - Problem With Adding Moderators
-----------------------------------
[quote user="Mighty Gorgon" post="39665"]The script is not getting the correct group ID.

Try to update to RC2... make sure you have a backup first.

If it is not a live site, I would suggest to reinstall.[/quote]

It is a live site sir, or I would have reinstalled by now.


-----------------------------------
Mighty Gorgon
Sun 31 May, 2009 20:10

Re: RC1 - Problem With Adding Moderators
-----------------------------------
Unfortunately I can't tell where the error is. :sad:

Maybe it is the auth or the groups tables that got corrupted.

Check that the ID of the group you are adding is in really in the DB in all groups and usergroups table.


