[wp-hackers] Categories empty on all blogs after PHP upgrade

[Peter Westwood]

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?

Cheers

westi
-- 
Peter Westwood
http://blog.ftwr.co.uk | http://westi.wordpress.com
C53C F8FC 8796 8508 88D6 C950 54F4 5DCD A834 01C5