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!
7:02 pm on July 21st, 2008
[...] Go to the author’s original blog: Categories disappeared while upgrading to wordpress 2.6 [...]
6:26 am on July 22nd, 2008
thanks for this post – it looks like it’s fixed my wordpress upgrade hell!
3:20 am on July 23rd, 2008
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!
6:34 pm on July 23rd, 2008
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…
10:07 pm on July 23rd, 2008
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.
7:09 am on July 24th, 2008
Thanks, I updated the article as well to remove the notice
Always good to give credit :p
12:44 pm on July 30th, 2008
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
4:37 am on August 12th, 2008
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!
11:12 am on September 12th, 2008
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.
2:18 pm on February 13th, 2009
Hi You did a great job with this blog. I loved categories disappeared while upgrading to wordpress 2.6