6.5(7) Changing User Permissions (Forum)

Sergeant Joined: Jan 31, 2003 Posts: 79 Location: UK

Error:

Quote:

Couldn't update private forum permissions

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' 1)' at line 2

INSERT INTO nuke_bbauth_access (forum_id, group_id, auth_mod) VALUES (8, , 1)

Line : 403
File : /home/domains/fourbelowzero.com/user/htdocs/modules/Forums/admin/admin_ug_auth.php

Occurs hwen trying to update an existing membet to have mdoerator status on a particular forum.

Joined: Jan 31, 2004 Posts: -88

ok, being that it's me who seems to be fixing hte forums for this site, I'll take a look.

Artificialintel

Joined: Jan 31, 2004 Posts: -88

I just had a quick look.

Is that user a member of any groups??? I just picked a random user on my site, promoted them to moderator on 1 forum and back again without the slightest hint of an error Rolling Eyes

ArtificialIntel

Sergeant Joined: Jan 31, 2003 Posts: 79 Location: UK

Yeah - they are a member of a custom group.

Worked ok for a user who wasnt in a custom group.

Joined: Jan 31, 2004 Posts: -88

soz dude. I've just tested it again on my site wiht a user who's in a group I created and it still worked fine Confused

ArtificialIntel

Sergeant Joined: Jan 31, 2003 Posts: 79 Location: UK

Hmm - just messed with it - same error every time I try it with someone who's a member of a group.

I'll keep playing see if i can find out a more discrete pattern or a way around it.

Sergeant Joined: Jan 31, 2003 Posts: 79 Location: UK

Hmm - it errors out everytime if the user is a member of any group.

Only works if they aren't in a group.

Joined: Jan 31, 2004 Posts: -88

have you tried adding the group as a moderator???

ArtificialIntel

Sergeant Joined: Jan 31, 2003 Posts: 79 Location: UK

that works aye... though it doesnt display any moderator on the actual forums (not a huge problem).

I made myself a memeber of the group "Moderators" - made "Moderators Group" a Mod of all forums - fine.

Still get the error trying to make an individual a moderator though - unless they dont belong to any group.

Posted: Sun Feb 09, 2003 7:11 pm

This isn't a bug really, it's the way it works in phpbb.

You can't have Moderator permissions as both a user and a Member of a Moderators group or "special group". Confused

mikem

Sergeant Joined: Jan 31, 2003 Posts: 79 Location: UK

K - thanks for the clarification Mike

Maybe worth putting in an error message to handle that? (For newbs like me)

Joined: Jan 31, 2004 Posts: -88

if the group's not showing up as moderator, try setting it as "Closed" rather than "Hidden"

People still can't join it, but it'll show up.

ArtificialIntel

Posted: Mon Feb 10, 2003 6:06 am

I think basically what is happening is the Error message you are getting, and it referring to that line in the auth file, is actually the line that simply displays the error if a value is already inserted in that part of the SQL database. There is already a value for permissions for that user, whether it be as a member of a Group of moderators or a Moderator him or herself. Thus the result is, the system is returning an error saying, "Hey this dude already has permissions for something else"...Maybe needs to be defined better.

"Could not update group permissions" is a little vague...

mikem

Joined: Jan 31, 2004 Posts: -88

soz, my last post was as a response to his "The moderators are not showing up in the actual forum" bit of one of his posts.

Artificialintel

Nuke Soldier Joined: May 02, 2003 Posts: 14

OK, not a fix per se, but a cause, a workaround and future avoidance procedure. Without editing MySQL!

mikem, phpbb2 *is* supposed to allow membership of a Moderator group and be an individual Moderator too. (There are even notes about this in the Forum Admin.)

The cause of the problem is that the group_id is blank.

This link is to the discussion about that at phpBB.com:

http://www.phpbb.com/phpBB/viewtopic.php?t=94498&highlight=update+private+forum+permissions

It also includes a fix if you feel like editing your database. But there is another way.

Best I can tell, if you add a user to a *Moderator* group via Usergroups on the user level Forum menu (at top 'tween Search and Profile), this will not create a group_id record (just creates a normal non-moderator group membership?).

So for users already assigned to the group, take the user out of the group. Add their User Permissions, then put them back into the user group (see below).

To avoid this occurring with new users, don't add them to a *Moderator* group via Usergroup, instead go to Group Admin Management and add them to the group there. You'll have to add them as that group's Moderator, and then go back and re-instate the original moderator, but the user will have a group_id record now. So after that you'll always be able to change their User Permissions.

This should hold you until phpBB guys figure out the root cause.