Announcement

Collapse
No announcement yet.

Error when changing user settings

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error when changing user settings

    I used impex and forums apprear to be working correctly. However when I tried changing a registered user settings and to a moderator this Error occured. Any ideas

    Thanks

    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 :

  • #2
    To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

    If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

    http://www.vbulletin.com/forum/showt...threadid=44909

    You may have to ask your host to try and repair this for you.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      It said everything was ok when I ran the repair. I assume that means it did nlt find anything? Have not tried the other stuff. A little over my head at this time.

      Comment


      • #4
        Are you still getting that error? If so, run this:

        Admin CP -> Maintenance -> Repair/Optimize Tables -> Fix Unique Indexes
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          It seems to be fine now. I think I also ran the unique indexes after I repaired the tables though the tables said they were ok.

          Comment

          Related Topics

          Collapse

          Working...
          X