Title: Admin broken (wp_usermeta) after upgrading
Last modified: August 18, 2016

---

# Admin broken (wp_usermeta) after upgrading

 *  [davilac](https://wordpress.org/support/users/davilac/)
 * (@davilac)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/admin-broken-wp_usermeta-after-upgrading/)
 * Hello,
 * after upgrading to 2.0 following the instructions I only got errors. The files
   are OK, I’m sure. So went to upgrade.php and didn’t upgrade a thing, it showed
   this:
 * WordPress database error: [Unknown column ‘category_count’ in ‘field list’]
    
   SELECT cat_ID, cat_name, category_nicename, category_description, category_parent,
   category_count FROM wp2_categories WHERE cat_ID > 0 ORDER BY cat_name asc
 * After going again and again to upgrade.php this problem dissapeared, but not 
   the main problem:
 * when I go to admin it shows me I don’t have enough level. I have checked the 
   database and did’t created the table wp_usermeta
 * Suggestions?

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Kafkaesqui](https://wordpress.org/support/users/kafkaesqui/)
 * (@kafkaesqui)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/admin-broken-wp_usermeta-after-upgrading/#post-306104)
 * Q. Do you know, or can you find out, if the database user account you use for
   your WordPress db has create priviliges? This *may* account for the usermeta 
   table not being set up.
 * One suggestion: go into your database and in wp_options browse for the db_version
   record. Edit the value for it to something _less_ than what is already there (
   i.e. if 3308, change to 3300). Then run upgrade.php again and see if this improves
   things (as well as adds the usermeta table).
 *  Thread Starter [davilac](https://wordpress.org/support/users/davilac/)
 * (@davilac)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/admin-broken-wp_usermeta-after-upgrading/#post-306106)
 * Thank you for your reply. At last I thiked and fixed that. If anybody have this
   problem I will explain what I have done:
 * Install another wordpress, copy databases wp_users and wp_usermeta and insert
   them into the old copy, but you must know then the old copy will loose old users
   to have new ones like the new blog.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Admin broken (wp_usermeta) after upgrading’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [upgrade](https://wordpress.org/support/topic-tag/upgrade/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [davilac](https://wordpress.org/support/users/davilac/)
 * Last activity: [20 years, 4 months ago](https://wordpress.org/support/topic/admin-broken-wp_usermeta-after-upgrading/#post-306106)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics