Automatically detect and repair/remove corrupted posts?

  • d.a.jackson

    (@dajackson)


    14 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?

Viewing 1 replies (of 1 total)
  • Thread Starter d.a.jackson

    (@dajackson)

    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?

Viewing 1 replies (of 1 total)
  • The topic ‘Automatically detect and repair/remove corrupted posts?’ is closed to new replies.

Tags