Problems in categories after updating to 3.1.2

Have you tried:

– deactivating all plugins to see if this resolves the problem. If this works, re-activate the plugins one by one until you find the problematic plugin(s).

– switching to the Twenty Ten theme to rule out any theme-specific problems.

– resetting the plugins folder by FTP or PhpMyAdmin. Sometimes, an apparently inactive plugin can still cause problems.

I have this on two separate sites. The term and taxonomy tables are there, the category admin panel shows 2 pages of categories, but displays none of them and categories are not showing up in with the post editing page or the site itself.

The OrganiseSeries plugin is also effectively disabled because it relies on the term and taxonomy tables. Its admin page also shows 2 pages of nothing.

Posts are shown without any tags, category widgets are empty and the Simple Tags tag cloud is not showing any tags.

I’d say this is a problem with WordPress 3.1.2.

Update:

I’ve downloaded the 3.1.1 version, extracted the files mentioned in the 3.1.2 release notes and uploaded them back to the site.

In the category admin page, I can now see all my categories, I can see categories in the post editor, the category widget shows all the categories, but posts are still displayed without them (yes, I cleared the cache and yes, I checked with TwentyTen).

Tags are the same: all good in admin area(s) and widget, but not showing with posts.

Categories are displayed using get_the_category_list(). Tags are displayed using the_tags(). Both of these are standard functions that depend on term and taxonomy functions.

For some reason, in the OrganizeSeries admin page, there is a “cloud” of series, but they are not being listed in the table and series are not displayed correctly anywhere public.

I’ve gone back to a blog that’s still on 3.1.1 and the categories there are also gone everywhere. I’m starting to think this is not a 3.1.2 problem but an earlier one I hadn’t noticed.

I see some people have posted that their categories disappeared after upgrading to 3.1.1, but there’s no solution, and there’s a recorded bug for changes in post selection by category/tag.

OK, so when I’ve had some food (very important), I decided to check my error_log and found this:

[30-Apr-2011 10:08:09] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’) AND tr.object_id IN (3467) ORDER BY t.name ASC made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, adjacent_posts_rel_link_wp_head, adjacent_posts_rel_link, get_adjacent_post_rel_link, get_permalink, get_the_category, get_the_terms, wp_get_object_terms

A quick all-table optimize in phpMyAdmin fixed that up real quick and things are fine even after upgrading again to 3.1.2.

I can sleep now ??

Just to finish off the solution for my case, cPanel includes an easy way to create automatic jobs (cron jobs), so I’ve created a nightly job that runs this command:

/usr/bin/mysqlcheck –optimize –all-databases –user=X –password=Y

To adapt for your own purpose, change X to your MySQL user name and Y to the corresponding password and you’ll never have to worry about unoptimized tables again (I hope).

I had the same problems with categories as described by others. There were also certain pages in the admin panel that wouldn’t display properly and the login screen had links at the bottom, left corner that disappeared if I attempted to click on them. Optimizing the database didn’t work for me.

I opted to go back to the previous version of WordPress.

Optimizing the databases is NOT the solution.

Any other thoughts?

This is very scary.

Also, restarting MySQL doesnt do anything. All tables optimized. The server restarted.

What else can I do?

Thanks.

@erick_paper, try going back to the previous version (software and database), verifying categories, deactivating all the plugins, doing the upgrade, then verifying the categories again.

If this works, activate your plugins one by one and keep checking.

If this doesn’t help, there may be something about your installation that’s getting in the way, so tell us more about it.

One more think to do is make absolutely sure your MySQL has plenty of free space when you run the upgrade and maybe optimize at key points to make sure of that.