Jul
21
Categories disappeared while upgrading to wordpress 2.6

samir05:47 pm Visited 496 times.
1 Star2 Stars3 Stars4 Stars5 Stars (6 votes, average: 4.33 out of 5)
Loading ... Loading ...

Apparently I’m not the only one having problems with the categories after a Wordpress 2.6 upgrade.

So, time to give something back to the Wordpress community, some screenshots on how I fixed it.

First of all, I upgraded from 2.2.3 to 2.6, it’s possible this solution will work for you, but I don’t make any promises.

I started by going to phpMyAdmin and having a look at the wp_term_taxonomy table, and noticed all the descriptions where missing.

When I took a look at the backup file I made, more specifically, the wp_categories piece, I noticed the counts and ids matched up.

I then manually edited each record, just hit the pencil icon, and filled in all my descriptions again. If you know some SQL you could do this faster, but anyway, everyone can do it manually

After I’ve done this, I visited my admin section and noticed the Descriptions were filled in again. But there was no Name, and all my posts still had empty categories linked to them.

To fix this, visit http://your-site/wp-admin/categories.php?action=edit&cat_ID=1 where 1 is the category id to edit. Fill in a Name and a Slug, the url name for your category, and save it.

Repeat this process for all your categories, until they all have a Name again.

And that’s it! Categories fixed, posts linked, category urls working again.

Good luck!

Original source of article by David Cumps

Share This


Filed Under Tutorials and Wordpress hacks Email This Post Email This Post   |   Print this post Print this post

Comments

7 Responses to “Categories disappeared while upgrading to wordpress 2.6”

  1. AvatarSimon
    Posted: Jul 22nd, 2008 at 6:26 am
    1

    thanks for this post - it looks like it’s fixed my wordpress upgrade hell!
  2. AvatarMaria Peagler
    Posted: Jul 23rd, 2008 at 3:20 am
    2

    Thanks for this post. I upgraded to 2.6 and had the same problem. I’m not a programmer, so this was very helpful. I still can’t fix my links and Blogroll - those categories won’t let me edit them, but the rest work.

    Thanks again!
  3. AvatarDavid Cumps
    Posted: Jul 23rd, 2008 at 6:34 pm
    3

    It would be MUCH appreciated if you LINK to my site, instead of simply stealing my article and posting it on your site!

    So rude…
  4. Avatarsamir
    Posted: Jul 23rd, 2008 at 10:07 pm
    4
    Author Comment

    Dear David,

    My apologies towards you for not putting your link back.I have forgot to do so.

    I have added it now.Please have a check.
    Regards,
    Sam.
  5. AvatarDavid Cumps
    Posted: Jul 24th, 2008 at 7:09 am
    5

    Thanks, I updated the article as well to remove the notice ;)
    Always good to give credit :p
  6. AvatarDaniel Staemmler
    Posted: Jul 30th, 2008 at 12:44 pm
    6

    Hi ,

    thank you so much for this it really helped me to solve the same problem as you did.

    Cheers and keep up the good work!
    Daniel
  7. AvatarNiagaraFalls
    Posted: Aug 12th, 2008 at 4:37 am
    7

    Fortunately I only had one category with hundreds of event posts (800 ). I am now trying to get my event plugin post sorter back to life. Many thanks!
SexyComments by BorkWeb

Leave a Reply




Vertigo Electrified Theme by Brian Gardner.
Powered by WordPress.
Close
E-mail It