Easy Fix For Missing Categories in Wordpress 2.6
It happened! The unimaginable! I’d been creating new blogs in Wordpress 2.6 and slowly getting used to the new look and Dashboard changes and thought I would upgrade some of my blogs to this new version. I did a couple and they worked well so I decided to upgrade this one too. That’s when it happened. My categories went missing! And I didn’t know how to get them back again.
They weren’t showing in the menu sidebar - just an empty spot and when I logged into the Dashboard and viewed the Categories list, there were rows of empty tickboxes with no names and a number at the end of each line indicating the number of posts for that invisible category listing.
Searches at Wordpress Support didn’t come up with any answers for me, although many were asking for help on the same thing, but Googling did produce some results with some step-by-steps on how to fix the problem. But there were steps missing! The first part was relatively easy and I was able to successfully make changes inside phpMyAdmin and get the categories list showing but there was no explanation on how to link the tables back up (perhaps that knowledge was assumed by the writers) and since I’ve never done it before I was not going to attempt something with no clear instructions on what to do next.
They also assumed that you had a backup file you could use to find out what all your categories were - wrong! Mine isn’t writeable to the directory so I have xml files I have exported and can import but don’t have a back up file to refer to. I must fix that issue one day too!
However, I discovered a really easy way of doing it in Wordpress, and thought I’d share it here for those who are not game to fiddle with the database on their server.
I did a manual fix.
- After thinking about this a great deal I decided to create a new category to see what would happen. It showed - that was good.
- So I placed one of my posts with that and that worked.
- Then I ticked all the other blank categories listed and clicked on the delete button. Everything automatically defaulted to ‘uncategorised’ which was still showing as blank (and is not removeable) but I knew that the first listing there was the uncategorised list.
- After that I recreated my categories and reconnected everything - there were 118 posts so that wasn’t too bad and only took me 2-3 hours to do.
The good thing about this was I got to rethink all the categories I have listed here and reconnected some posts to belong to more than one category so in effect, my blog got tidied up in the process.
So, if you are too scared to touch the real techy side of your blog and want a fix that you can do, without calling in help, the above should work for you - it did for me!
It already 2.6.1 version of WP now. But I’m still afraud to upgrade it. lol. I dont want my blog messed up again.
Thx for pointing into my tutorial
Btw link the table back up? Oh… I also dont understand that. I just re-upload entire database back up. ehheehehe
You cant open your SQL data base backup file? My backup file is on SQL extention but I open it with notepad++. Thats why I can searching my category ID with that.
I also want to do similar way like U to manually re enter category. But with my slow connection and more than 500 post, I think I dont want to do that. lol So I try to find another way like in my tutorial ^^
Great thing U already able to fix Ur problems ^^
No, unfortunately I don’t have an sql backup - at least I don’t think so. I know there is a fix for getting my directory writeable too - I had a cpanel crash early last month and we shifted to a new server but unfortunately a number of my blogs are rendered ‘not writable’ to the server so we can’t get the back up to work. Exporting to xml is my best fix at the moment.
Such a shame you’re on slow connection as that would make it tedious for you. I was on the phone last week and just sat updating things online as I participated in the phone discussion. And then finished it afterwards while watching TV.
This was of no use to me with the categories issue. It would appear that there are more than one issue with disappearing categories.
When I add a new category as you suggested it shows for a moment. But hit refresh and it is gone just like the others. And since it does not show as a selectable category under the post, there is no way to attach the post to the new category or any other for that matter.
Thanks for the effort but unfortunately it does not work for me.
So sorry to hear that Jesse. I assume you’re working with version 2.6? Might be worth checking the wordpress support forum to see if there is any updates or if anyone describes a similar problem to you. If you do find out how to resolve it, please do come back and let us know!