Support » Installing WordPress » WordPress database error: [Unknown column ‘user_nickname’ in ‘field list’]

  • I am trying to upgrade my WP install.

    I was using 2.X install and upgrading to 2.3.3

    Downloaded the wordpress-2.3.3.tar.gz off the site and proceeded to overwrite the files I was supposed to (and not the ones I didn’t need to since it was an upgrade, I followed the directions on the site.)

    However I have been stuck. I get this message when I tr to login to my wp-admin section:

    Database Upgrade Required

    Your WordPress database is out-of-date, and must be upgraded before you can continue.

    The upgrade process may take a while, so please be patient.
    Upgrade WordPress ยป

    I click the Upgrade link and get:

    WordPress database error: [Unknown column ‘user_nickname’ in ‘field list’]
    SELECT ID, user_nickname, user_nicename FROM wp_users

    I don’t think it upgraded my database.

    I have tried searching for similar people with this problem ( no one’s seemed to be resolved), I have also tried:

    *fresh WP install (all files from previous install trashed, new ones uploaded)

    *the login patch

    *this link: http://remysharp.com/2008/02/06/how-i-fixed-wordpress-broken-upgrade/

    *dropping my MySQL database and creating a new one and importing my tables into THAT and then directing the config file ( i thought maybe my host has upgraded mySQl and somehow WP wasn’t “recognizing” my db)

    I’ve looked for user_nickname in my users table but I don’t really know WHAT I’m looking for or how to fix it given that error message.

    I guess I’m asking:

    does anyone recognize this problem/error message?

Viewing 15 replies - 1 through 15 (of 24 total)
  • Hey, so if it didn’t upgrade my database (for whatever reason) is there a way to check if it did in PhpMy Admin?

    What would I be looking for to see if it DID upgrade? Can i manually upgrade the DB if upgrade.php isn’t doing it for me?

    this is all guess work for me, assuming i’m getting the

    WordPress database error: [Unknown column ‘user_nickname’ in ‘field list’]
    SELECT ID, user_nickname, user_nicename FROM wp_users

    message because upgrade.php didn’t Upgrade my old tables?

    I am having the exact same problem and also don’t know what to do. Luckily the site is still taking content from my offline post writer, but not having access is annoying as hell.

    If I find a solution that works I will post it here, but in the mean time I am looking for help as well. Please help if you can.

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    What does the table structure of your users table look like in phpMyAdmin?

    From my phpmyadmin wp_users Structure tab.

    Error
    SQL query:

    SHOW INDEX FROM wp_users ;

    MySQL said:

    #1142 – SELECT command denied to user ”@’localhost’ for table ‘wp_users’

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    Sounds like your database has some kind of permissions problem. Give yourself permissions to access the table. If you can’t do it, have your host do it.

    Actually… I am getting that for every wp_* table. ๐Ÿ™ Should that be?

    How do I give myself permissions? I don’t see that in phpmyadmin.. ?

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    Maybe your phpMyAdmin is using the wrong username and password to access the database. It should be the same username/password as your WordPress config file has in it.

    I really can’t teach you how to use phpMyAdmin, because I’m not an expert on it myself.

    ok yeah sorry was using the wrong username to access phpmyadmin posting table structure for wp_users now.

    http://img.skitch.com/20080324-3tp3ns15kmcdfgc3ytedkufmn.jpg

    Thats a link to a screen grab showing the print version of the table structure.

    Here is the paste:

    ID 	bigint(20)	No
    user_login 	varchar(60)	No
    user_pass 	varchar(64)	No
    user_nicename 	varchar(50)	No
    user_email 	varchar(100)	No
    user_url 	varchar(100)	No
    user_registered 	datetime	No 	0000-00-00 00:00:00
    user_activation_key 	varchar(60)	No
    user_status 	int(11)	No 	0
    display_name 	varchar(250)	No

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    Well, that is correct. That’s what it is supposed to be.

    Looking closer at the upgrade sequence, you should not be getting that user-nickname field in there unless you’re upgrading from before WordPress version 1.5.

    What is the value of the db_version option in the options table?

    option_name “db_version” has option_value “1”in the wp_options table.

    Is that what you are asking?

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    Yes, and that’s big time wrong and the cause of your major problem. I have no idea how you got “1” in there. It should be somewhere in the 4000-7000 range.

    Is there, by any chance, more than one entry with the name of db_version? See if you can find a second one. If so, then delete the first one with ‘1’ and rerun the upgrade. But only try that if you find another db_version entry that is not ‘1’.

    whoa…

    No there is no other db_version in the wp_options table… ๐Ÿ™

    The interesting thing is the site is still up and running, it’s the dashboard that won’t display complains of wanting a db upgrade.

    All my articles are there and I can post new content via an offline editor. ๐Ÿ™

    Is there anyway to fix this?

    Otto? anyone? Help!

Viewing 15 replies - 1 through 15 (of 24 total)
  • The topic ‘WordPress database error: [Unknown column ‘user_nickname’ in ‘field list’]’ is closed to new replies.