Announcement

Collapse
No announcement yet.

Upgrading, Can't Edit Users

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

  • Upgrading, Can't Edit Users

    I am upgrading a 3.5.4 board to 3.6.2. I disabled hook system and uninstalled all hacks. I'm want to keep this version of my board as vanilla as I can, but I've run into a problem:

    Code:
    Database error in vBulletin 3.6.2:
    
    Invalid SQL:
    UPDATE vb3_user SET
    	### Bitfield: vb3_user.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 & 131072, options - 131072, options),
    		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: vb3_user.adminoptions ###
    		adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
    		adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
    	usertitle = 'Administrator',
    	customtitle = 0,
    	username = 'Reager',
    	email = '[email protected]',
    	languageid = 1,
    	homepage = '',
    	birthday_search = '1984-08-05',
    	birthday = '08-05-1984',
    	showbirthday = 0,
    	icq = '',
    	aim = '',
    	yahoo = '',
    	msn = '',
    	skype = '',
    	parentemail = '',
    	referrerid = 0,
    	ipaddress = '65.78.218.129',
    	posts = 0,
    	usergroupid = 6,
    	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 = 1162352820,
    	lastactivity = 1162352820,
    	lastpost = 0,
    	membergroupids = '',
    	displaygroupid = 0
    WHERE userid = 155;
    
    MySQL Error  : Unknown column 'warnings' in 'field list'
    Error Number : 1054
    Date         : Tuesday, October 31st 2006 @ 10:59:29 PM
    Script       : http://www.thechillcenter.com/forums/admincp/user.php?do=update
    Referrer     : http://www.thechillcenter.com/forums/admincp/user.php?do=edit&u=155
    IP Address   : 67.141.79.197
    Username     : Karsinogen
    Classname    : vb_database
    I get this when I try to edit a user's usergroup. All hooks are disabled, all templates reverted, no hacks installed, so I'm not sure whats wrong.

  • #2
    This means you missed a step during the upgrade. Run this query to add that field:

    ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0'
    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
      Thanks, any idea what part of the upgrade I could have missed for this to have happened? Or should I re-run the whole upgrade script?

      Comment


      • #4
        No I don't. I would not run the upgrade again. Just run that query and if you have more errors post themn here.
        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
          I had this exact problem myself, (which is weird, because I followed the upgrade instructions and simply clicked next, and then poof it was done and I was moved to the admincp index, like it was done :S)

          But, when I try to run this (ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0') query, I get this error:

          An error occurred while attempting to execute your query. The following information was returned.
          error number: 1146
          error desc: Table 'warunee_vbulletin.user' doesn't exist

          My database is named 'warunee_vbulletin', and the prefix is 'vb3_' (without the '' of course).

          Comment


          • #6
            Then you need to run

            ALTER TABLE vb3_user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0'

            The only way the warning table would not be is if you uninstalled the warning hack AFTER the upgrade.

            Comment


            • #7
              Originally posted by Zachery View Post
              Then you need to run

              ALTER TABLE vb3_user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0'

              The only way the warning table would not be is if you uninstalled the warning hack AFTER the upgrade.
              Duuh on the vb3_user part, silly me! Sorry! Been staring at the problem for a while, made me blind :P

              Does the warning table have anything to do with the new infractions system? If not, then I uninstalled this warning hack some time ago...

              Comment


              • #8
                Yes it does.

                Comment

                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                Working...
                X