Can’t Publish or change post’s status? DB table may be corrupted

  • Resolved felthos

    (@felthos)


    14 years, 5 months ago

    Thought I’d throw this tidbit out there in case it helps anyone else.

    I was trying to change the status of a post from “Draft” to “Published” as well as a few other things like pubdate and categories. Nothing would work. Not from the main post edit page or via Quick Edit.

    Resorting to the command line, I ssh’ed into my server and fired up mysql in the hopes of doing it manually. Tried running an UPDATE command only to discover MySQL telling me something along the lines of “Incorrect key file for table ‘wp_posts.MYI'”. Uh-oh.

    A quick Google told me that my wp_posts table was corrupted. Simple fix was to run REPAIR TABLE wp_posts from my mysql cmd line (you can also do this from PHPMyAdmin). You may have more serious corruption which would warrant you having to look up myisamchk in more detail.

    HTH. Cheers.

  • The topic ‘Can’t Publish or change post’s status? DB table may be corrupted’ is closed to new replies.