Issue: Error when Updating Moderator Permissions

Issue Tools
- View Changes

August 12, 2009 12:12 PM

Mokonzi

Senior Member

Error when Updating Moderator Permissions

An Error occurs on some wiki forums when updating the moderator permissions on a per moderator basis

An Error occurs on some wiki forums when updating the moderator permissions on a per moderator basis.

This didn't happen when I edited it for the main wiki namespace forum, but it did happen on all other namespaces, including a couple I created.

The errors are similar, but below is the gist of one:

Code:

Database error in vBulletin 3.8.3:

Invalid SQL:
UPDATE ext_moderator SET
	userid = '2865',
	forumid = 181,
	### Bitfield: ext_moderator.permissions ###
		permissions = IF(permissions & 1, permissions, permissions + 1),
		permissions = IF(permissions & 2, permissions, permissions + 2),
		permissions = IF(permissions & 131072, permissions, permissions + 131072),
		permissions = IF(permissions & 4, permissions, permissions + 4),
		permissions = IF(permissions & 8, permissions, permissions + 8),
		permissions = IF(permissions & 16, permissions, permissions + 16),
		permissions = IF(permissions & 1048576, permissions - 1048576, permissions),
		permissions = IF(permissions & 32, permissions, permissions + 32),
		permissions = IF(permissions & 64, permissions, permissions + 64),
		permissions = IF(permissions & 128, permissions, permissions + 128),
		permissions = IF(permissions & 256, permissions, permissions + 256),
		permissions = IF(permissions & 512, permissions, permissions + 512),
		permissions = IF(permissions & 65536, permissions - 65536, permissions),
		permissions = IF(permissions & 1024, permissions, permissions + 1024),
		permissions = IF(permissions & 2048, permissions - 2048, permissions),
		permissions = IF(permissions & 4096, permissions - 4096, permissions),
		permissions = IF(permissions & 8192, permissions - 8192, permissions),
		permissions = IF(permissions & 262144, permissions - 262144, permissions),
		permissions = IF(permissions & 524288, permissions - 524288, permissions),
		permissions = IF(permissions & 2097152, permissions - 2097152, permissions),
		permissions = IF(permissions & 4194304, permissions - 4194304, permissions),
		permissions = IF(permissions & 16384, permissions - 16384, permissions),
		permissions = IF(permissions & 32768, permissions - 32768, permissions),
	### Bitfield: vb3_moderator.permissions2 ###
		permissions2 = IF(permissions2 & 1, permissions2, permissions2 + 1),
		permissions2 = IF(permissions2 & 2, permissions2, permissions2 + 2),
		permissions2 = IF(permissions2 & 4, permissions2 - 4, permissions2),
		permissions2 = IF(permissions2 & 8, permissions2, permissions2 + 8),
		permissions2 = IF(permissions2 & 64, permissions2 - 64, permissions2),
		permissions2 = IF(permissions2 & 128, permissions2 - 128, permissions2),
		permissions2 = IF(permissions2 & 2097152, permissions2 - 2097152, permissions2),
		permissions2 = IF(permissions2 & 256, permissions2, permissions2 + 256),
		permissions2 = IF(permissions2 & 2048, permissions2, permissions2 + 2048),
		permissions2 = IF(permissions2 & 512, permissions2, permissions2 + 512),
		permissions2 = IF(permissions2 & 1024, permissions2 - 1024, permissions2),
		permissions2 = IF(permissions2 & 131072, permissions2, permissions2 + 131072),
		permissions2 = IF(permissions2 & 1048576, permissions2, permissions2 + 1048576),
		permissions2 = IF(permissions2 & 262144, permissions2, permissions2 + 262144),
		permissions2 = IF(permissions2 & 524288, permissions2 - 524288, permissions2),
		permissions2 = IF(permissions2 & 16, permissions2 - 16, permissions2),
		permissions2 = IF(permissions2 & 32, permissions2 - 32, permissions2),
		permissions2 = IF(permissions2 & 65536, permissions2, permissions2 + 65536),
		permissions2 = IF(permissions2 & 32768, permissions2, permissions2 + 32768),
		permissions2 = IF(permissions2 & 8192, permissions2, permissions2 + 8192),
		permissions2 = IF(permissions2 & 16384, permissions2 - 16384, permissions2),
		permissions2 = IF(permissions2 & 4096, permissions2, permissions2 + 4096)
WHERE moderatorid = 550;

MySQL Error   : Duplicate entry '2865-181' for key 2
Error Number  : 1062
Request Date  : Wednesday, August 12th 2009 @ 07:57:36 PM
Error Date    : Wednesday, August 12th 2009 @ 07:57:36 PM
Script        : http://www.mysite.com/forum/admincp/moderator.php?do=update
Referrer      : http://www.mysite.com/forum/admincp/moderator.php?do=edit&moderatorid=550&redir=showlist
IP Address    : 86.27.233.91
Username      : Username
Classname     : vB_Database
MySQL Version : 5.0.81-community

Issue Details

Issue Number 771

Issue Type Bug

Project VaultWiki 3.x Series

Category Admin Panel

Status Not a Bug

Priority 6 - Dev-Related Tasks

Affected Version 2.3.1

Fixed Version (none)

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 12, 2009 5:09 PM

pegasus

VaultWiki Team

Sorry but VaultWiki doesn't mess with the moderator table or moderator permissions at all. The closest thing it does is have a page that appears in the Moderator CP.

I have no trouble editing moderators on this site. I can't imagine how it's even possible to get the "Duplicate entry" error on an UPDATE command (because, depending on what happened first, either you wouldn't be able to have 2 to UPDATE or the key wouldn't have been created), but this appears to be a data integrity issue in your database. You should see if vBulletin's support staff can assist you with this.

Reply
August 12, 2009 6:33 PM

Mokonzi

Senior Member

The method I was using was to set the permissions for one forum, backspace to the page, select a new forum, save, etc.

I can work around it if I do each individually, so it's not a major issue. Will report it to vBulletin.

Thanks for the feedback.

Reply

+ Reply

All times are GMT -4. The time now is 12:56 AM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Error when Updating Moderator Permissions

Issue Tools