WordPress.org

1. itsdesire
   Member
   Posted 3 years ago #

   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.

2. makemead
   Member
   Posted 3 years ago #

   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.

3. Chris_K
   Administrator
   Posted 3 years ago #

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

4. makemead
   Member
   Posted 3 years ago #

   ¿Qué?

5. Ellerbestyle
   Member
   Posted 3 years ago #

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

6. vkaryl
   Member
   Posted 3 years ago #

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

7. Ellerbestyle
   Member
   Posted 3 years ago #

   I dont see a wp-cache folder

8. itsdesire
   Member
   Posted 3 years ago #

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

   anyone?

9. makemead
   Member
   Posted 3 years ago #

   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;}

10. Ellerbestyle
    Member
    Posted 3 years ago #

    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?

11. itsdesire
    Member
    Posted 3 years ago #

    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.

12. Ellerbestyle
    Member
    Posted 3 years ago #

    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?

13. itsdesire
    Member
    Posted 3 years ago #

    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?

14. haydin
    Member
    Posted 3 years ago #

    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

Topic Closed

This topic has been closed to new replies.