Jul
21
Categories disappeared while upgrading to wordpress 2.6

samir05:47 pm Visited 2,848 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


Filed Under Tutorials" and "Wordpress hacks   |  

Comments

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

  1. pingback pingback:
    Posted: Jul 21st, 2008 at 7:02 pm
    1
    Categories disappeared while upgrading to wordpress 2.6

    [...] Go to the author’s original blog: Categories disappeared while upgrading to wordpress 2.6 [...]
  2. AvatarSimon
    Posted: Jul 22nd, 2008 at 6:26 am
    2

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

    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!
  4. AvatarDavid Cumps
    Posted: Jul 23rd, 2008 at 6:34 pm
    4

    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…
  5. Avatarsamir
    Posted: Jul 23rd, 2008 at 10:07 pm
    5
    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.
  6. AvatarDavid Cumps
    Posted: Jul 24th, 2008 at 7:09 am
    6

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

    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
  8. AvatarNiagaraFalls
    Posted: Aug 12th, 2008 at 4:37 am
    8

    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!
  9. AvatarEnk.
    Posted: Sep 12th, 2008 at 11:12 am
    9

    Well, I was finding this solution long back but I didn’t find any and re-installed WP and error existed.
    Somehow I managed it, but this time when I’ve switched to pretty permalinks my categories crash down.
    Any reasons or help ? I’ve tried editing .htaccess.
    Can u help me more?

    My Blog: http://www.GEXTOP.com
    You can check movies categories.

    Regards,
    Enk.
  10. AvatarFranky
    Posted: Feb 13th, 2009 at 2:18 pm
    10

    Hi You did a great job with this blog. I loved categories disappeared while upgrading to wordpress 2.6
SexyComments by BorkWeb

Leave a Reply




Samir Kamble Designed by Samir Kamble.
Powered by WordPress.