• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
    • Wiki
    • Support
      • Manage Subscriptions
      • FAQ
      • Support For
        • VaultWiki 4.x Series
        • VaultWiki.org Site
    • What's New?
    • Buy Now
    • Manual
    • 
    • Support
    • VaultWiki 3.x Series
    • Bug
    • Error when Updating Moderator Permissions

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

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

    Issue: Error when Updating Moderator Permissions

    • Issue Tools
      • View Changes
    1. issueid=771 August 12, 2009 12:12 PM
      Mokonzi Mokonzi is offline
      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)




    1. August 12, 2009 5:09 PM
      pegasus pegasus is offline
      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 Reply  
    2. August 12, 2009 6:33 PM
      Mokonzi Mokonzi is offline
      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  
    + Reply

    Assigned Users
    Loading Please Wait
    Tags
    Loading Please Wait
    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    All times are GMT -4. The time now is 11:03 PM.
    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
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.