We have a WordPress 2.6 installation we're trying to upgrade to 3.1. When we do the upgrade process, what we end up with is 0 posts/pages/etc. in the WordPress Dashboard.
However, after much messing around on our test server, I've found that if I delete posts from wp_posts in the database with dates between 2010-10-01 and 2011-01-17 then the post and page counts reappear correctly.
I've been trying to narrow things down by hand but it's an extremely long-winded process, so my question is, is there a way to automatically detect and either repair or remove these corrupted wp_posts entries?