[wp-hackers] Categories empty on all blogs after PHP upgrade
peter.westwood at ftwr.co.uk
Wed Apr 8 06:57:16 GMT 2009
On 8 Apr 2009, at 07:46, Hacker Scot wrote:
> OK, here's a weird one. Upgraded PHP 5.2.8 to 5.2.9 on a server
> today. The server hosts 90 WP sites on 50 or so domains. Immediately
> afterwards, all categories on all blogs are empty.
> wp-admin/categories.php lists all categories with the number of
> posts in each; click on a category and it shows zero posts. Same on
> the public/front-end. If I then run Repair Tables via phpmyadmin,
> wp-admin/categories.php shows zero posts in each category, same on
> front end. In other words, repair tables seems to make things worse.
> All WP installations are 2.7.1. None of them were upgraded. This was
> just a PHP upgrade on a cPanel system with MySQL 4.1.22.
> Findings lots of solutions in the forums for fixing individual
> blogs, but nothing about server-wide category problems.
This sounds like you've lost all the post<>category relationships
which would be stored in the term_relationships table.
Is this table empty?
http://blog.ftwr.co.uk | http://westi.wordpress.com
C53C F8FC 8796 8508 88D6 C950 54F4 5DCD A834 01C5
More information about the wp-hackers