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

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.

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’

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.. ?

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.

https://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

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?

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!