Announcement

Collapse
No announcement yet.

Error When Editing User

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

  • Error When Editing User

    Hey guys. I get this error when I edit a user through the AdminCP. I can edit, but when I click save, it gives me the following error:

    Code:
    Database error in vBulletin 3.6.0:
    
    Invalid SQL:
    UPDATE vbuser SET
        ### Bitfield: vbuser.options ###
            options = IF(options & 8, options - 8, options),
            options = IF(options & 1024, options, options + 1024),
            options = IF(options & 16, options, options + 16),
            options = IF(options & 256, options - 256, options),
            options = IF(options & 512, options - 512, options),
            options = IF(options & 32, options - 32, options),
            options = IF(options & 2048, options, options + 2048),
            options = IF(options & 4096, options - 4096, options),
            options = IF(options & 1, options, options + 1),
            options = IF(options & 2, options, options + 2),
            options = IF(options & 4, options, options + 4),
            options = IF(options & 64, options, options + 64),
            options = IF(options & 128, options - 128, options),
            options = IF(options & 32768, options - 32768, options),
        ### Bitfield: vbuser.adminoptions ###
            adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
            adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
        usertitle = 'New Member',
        customtitle = 0,
        username = 'novius nat1o',
        email = '[email protected]',
        languageid = 1,
        homepage = '',
        birthday_search = '1984-04-28',
        birthday = '04-28-1984',
        showbirthday = 2,
        icq = '',
        aim = '',
        yahoo = '',
        msn = '',
        skype = '',
        parentemail = '',
        referrerid = 0,
        ipaddress = '68.233.110.120',
        posts = 0,
        usergroupid = 16,
        reputationlevelid = 5,
        reputation = 10,
        warnings = 0,
        infractions = 0,
        ipoints = 0,
        pmpopup = 0,
        autosubscribe = -1,
        threadedmode = 0,
        showvbcode = 1,
        styleid = 0,
        timezoneoffset = '-5',
        daysprune = 0,
        joindate = 1155671100,
        lastactivity = 1155672120,
        lastpost = -3601,
        membergroupids = ''
    WHERE userid = 6694;
    
    MySQL Error  : Unknown column 'warnings' in 'field list'
    Error Number : 1054
    Date         : Tuesday, August 15th 2006 @ 03:10:54 PM
    Script       : http://www.brutehalo.com/forum/admincp/user.php?do=update
    Referrer     : http://www.brutehalo.com/forum/admincp/user.php?do=edit&u=6694
    IP Address   : 69.245.182.55
    Username     : blockbusted
    Classname    : vB_Database
    The error has something to do with the Warnings (part of the infractions system?) ...

    Here are some screenshots of my different infraction areas...

    ADMIN CP:


    Notice how the warnings area is blank?


    USER INFRACTIONS AREA:


    Again, the Warnings area is blank...

    Any kind of help would be greatly appreciated. I'm not sure how to fix this at all... Thanks again.

  • #2
    There is no 'warnings' field in the vB 3.6.0 user table. This query is form a hack you've installed. To fix this, reupload the original 3.6.0 files.
    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
      Well, I decided to just add a field in the DB and it worked. Ha, I didn't want to reinstall the whole thing. Thanks though.

      Comment


      • #4
        You will likely run into other errors due to your hacked files.
        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

        Loading...
        Working...
        X