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)

  • 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

    (@davilac)

    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.