Error when changing user settings

[jpietrowiak]

Hi all,
Had this happen any ideas? basically I had used impex to import from punbb originally. I recieved this error when I was editing a user profile then when I hit save this is what came up.

Database error in vBulletin 3.8.0:

Invalid SQL:
UPDATE moderator SET
userid = '110',
forumid = 26,
### Bitfield: moderator.permissions ###
permissions = IF(permissions & 1, permissions, permissions + 1),
permissions = IF(permissions & 2, permissions, permissions + 2),
permissions = IF(permissions & 131072, permissions - 131072, permissions),
permissions = IF(permissions & 4, permissions - 4, permissions),
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 - 256, permissions),
permissions = IF(permissions & 512, permissions - 512, permissions),
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),
permissions = IF(permissions & 33554432, permissions - 33554432, permissions),
### Bitfield: 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 = 6;

MySQL Error : Duplicate entry '110-26' for key 2
Error Number : 1062
Request Date : Sunday, February 8th 2009 @ 11:04:03 PM
Error Date : Sunday, February 8th 2009 @ 11:04:03 PM
Script :

[snakes1100]

Do you have any hacks installed?

If so, disable the plugin system via vb options in the admincp & see if the error goes away.