Categories not working after 2.7.1 upgrade

reset your permalinks
admin – settings – permalinks

I was hoping that would help… but so far I see the same issues. All posts in the pages say they’re in “uncategorized”.

Upgraded from ‘what’ version?

See if rebuilding/repairing your database tables via phpMyAdmin helps.

Oh sorry… good question! I upgraded from 2.7 to 2.7.1 but I’ve been using wordpress since (I think version 2.5).

Well if your tables are okay, then I’d consider deactivating plugins. The 2.7 to 2.7.1 had NO changes to the database.

I only have three plugins…

Akismet
Wordpress.com stats
wp-phpmyadmin

Turned all of them off. Still not working.

I also noticed that in the post_category column in the wp_posts always has zero for a value. Even with new posts…

I just don’t even get what’s going on here… ??

The post_category field would be zero in wp_posts as it it not used. The terms/taxonomy tables are where categories exist and the term_relationship links your posts to their categories.

Did you rebuild your tables?

I did a repair of the tables. How do I do a *rebuild* of the tables? phpMyAdmin doesn’t have rebuild – just repair.

Sorry, that’s what I meant. Repair. If you look at Posts->Edit, do the posts displayed show the categories?

Every post shows “Uncategorized” and no tags (even tho I’ve tagged them) in the view you directed me to.

HOWEVER – If I go to edit a post the categories are still showing as correctly assigned to the post.

HOWEVER – If I go to edit a post the categories are still showing as correctly assigned to the post.

Well that is too weird…

And if you edit a given post and update it, does the category and tag info then reflect on that post when you view your blog?

Another thought, make sure the indexes on your tables agree with the indexes shown for each table in Database Description. The ‘term’ tables are the one to check and don’t worry about the Cardinality column.

Michael,

And if you edit a given post and update it, does the category and tag info then reflect on that post when you view your blog?

Nope. Tried that.

Here’s another thing. I exported the database from the hosted server and pulled it to my mac, updated the data in the SQL script to reflect the local server, and set up a copy of my blog on my mac. The tables worked fine.

So I thought “OH, OK.. I’ll just export the tables, drop them in the MySQL prompt and re-import them…!”

Nope.. same problem.

If I created a WordPress export of the site from the admin tool in that XML format that wordpress uses, and I import it, all of the categories are blown out then also. It’s only when I fetch the SQL dump that I can make it work correctly on my Mac.

And then I look this morning and everything is working fine… and then an hour later it’s doing this weird crap again…

The hosted MySQL server is 4.0.18 (I think) and the one on my Mac is 5.0.28 (not sure about the .28 but I know it’s a 5.0 variant).

The ‘term’ tables are the one to check and don’t worry about the Cardinality column.

Those appear to be fine. In fact all of them appear to be fine.

My previous hosting server is being migrated to a new one with MySQL 5. Perhaps that will solve the problem and there’s something going on with the previous MySQL database server. All I know is this is cheesing me off. WordPress normally “just works” and I don’t have to screw around with this stuff.

*sigh*

Any update on this?

I am experiencing the exact same thing all of the sudden out of nowhere. I upgraded from 2.7 to 2.7.1, but this didn’t happen until a little bit after that – at least a day or two after.

In my admin dashboard it says I have no categories and no tags – but the terms table still has all my categories and tags in it. I tried repairing the database tables, but that made no difference. All my posts show as uncategorized.

After more comparing I see what happened in my case – but NO IDEA how.
The tables wp_term_relationships and wp_term_taxonomy were dropped from my database. I know I didn’t do it, but I have no idea how it happened. Unfortunately, I hadn’t done another backup since October, so I have to go back to my previous few months worth of posts and re-categorize them – ugh.

Yea see I still have the term relationships and term taxonomy tables.

Near as I can tell it’s something related to MySQL 4.0.x. Because in a 5.0.x environment on my Mac system everything just rips and tears new ones… so to speak.