Announcement

Collapse
No announcement yet.

Upgrading, Can't Edit Users

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

  • Zachery
    replied
    Yes it does.

    Leave a comment:


  • Julieh
    replied
    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...

    Leave a comment:


  • Zachery
    replied
    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.

    Leave a comment:


  • Julieh
    replied
    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).

    Leave a comment:


  • Steve Machol
    replied
    No I don't. I would not run the upgrade again. Just run that query and if you have more errors post themn here.

    Leave a comment:


  • TruthElixirX
    replied
    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?

    Leave a comment:


  • Steve Machol
    replied
    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'

    Leave a comment:


  • TruthElixirX
    started a topic Upgrading, Can't Edit Users

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X