WordPress.org

Support

Support » Installation » problems with the upgrade from 1.5 to 2.0

problems with the upgrade from 1.5 to 2.0

  • i’ve just upgraded my wp to 2.0 and now it has 2 problems:

    1st, on the front page, the Categories section on sidenav shows like:

    WordPress database error: [Unknown column ‘category_count’ in ‘field list’]
    SELECT cat_ID, cat_name, category_nicename, category_description, category_parent, category_count FROM
    wp_categories WHERE cat_ID > 0 ORDER BY cat_ID asc

    2nd, I tried to login to the admin site but all the pages under http://mysite/blog/wp-admin/ is reported as:

    You do not have sufficient permissions to access this page.

    I’m not sure if someone else asked similiar questions before, but it will be great appreciated if anyone can help me on these, thanks.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The udgrade script doesn’t properly update your admin username. I’ve run into the same problem. I think it has to do with the new usermeta table in the database as nothing gets put in there for your old admin name.

    Chris_K
    Member

    @handysolo

    But first, make sure you ran the upgrade script after copying up the new version!

    ¿Qué?

    Ellerbestyle
    Member

    @ellerbestyle

    I am having the same exact problem. Can anyone help?

    For the permissions error, try clearing the wp-cache folder.

    Ellerbestyle
    Member

    @ellerbestyle

    I dont see a wp-cache folder

    i found cache folder under wp-content and tried to cleanup everything inside, but still no luck with the permissions error.

    anyone?

    Do you have access to phpMyAdmin?

    If so make sure your wp_capabilities in the wp_usermeta table for your admin name is set to a:1:{s:13:"administrator";b:1;}

    Ellerbestyle
    Member

    @ellerbestyle

    Well I am completely screwed. I tried clearing the cache folder and it didnt work. I checked under wp-usermeta and didnt see a wp-capabilities.

    Is this missing?

    ok, at least i fixed the category listing error, just create a new field called category_count in wp_categories and then assign each category the value from 0,1,2…to the end…

    but for the permission error, i still had no luck, i even added the wp-usermeta table manually.

    Ellerbestyle
    Member

    @ellerbestyle

    What if I did a clean install with a new DB and then took the posts from the old DB and comments and put them into the new DB. Would that work?

    one of the important reason i using wp is because its easily and smoothly upgrade, but why this kinda popular error doesnt have a official solution?

    Hey itsdesire,

    I had the same problem. Moved my installation from 1.5.x to 2.0 and got the category_count issue. Then I browsed to http://my.domain/blog/wp-admin/upgrade.php and forced an upgrade, which fixed the database schema.

    hope this helps

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘problems with the upgrade from 1.5 to 2.0’ is closed to new replies.