Automatically detect and repair/remove corrupted posts? (2 posts)

  1. d.a.jackson
    Posted 5 years ago #

    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?

  2. d.a.jackson
    Posted 5 years ago #

    I've been doing some further testing on our test server and I found that exporting, deleting and then re-importing the affected months' posts using phpMyAdmin cured the problem. What I don't understand is why that would help? I'm reluctant to try something on our live server without having some idea of why it's working.

    Does anyone have any ideas?

Topic Closed

This topic has been closed to new replies.

About this Topic