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.
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