WordPress.org

Support

Support » How-To and Troubleshooting » Archive Error after Editing Posts

Archive Error after Editing Posts

  • I edited a rather old post, hit ‘save’ and it gave me a MySql error that I have since forgotten. It had something to do with an incorect field or integer in the wp_posts table of my database.
    What it did is a stranger thing. I am now unable to find the post in my manage posts tab, and it screwed up a couple things:
    I had a list of the most recent posts on my sidebar that now shows only 5 posts after the original post I edited (4 months ago).
    A scrolling archive plugin now only shows posts up until right before the post I got an error on.
    IT seems that the stream of posts has a hiccup right before the post that gave me the error.
    Does anyone have any ideas?
    The scrolling archive thing can be found here:
    http://moneydick.com/wordpress/search . It once worked and included all my posts, not just up until August 05.

Viewing 4 replies - 1 through 4 (of 4 total)
  • I could read posts back to March 2005 and up to March 2006.
    The 2004 archives went to your old site.

    Do you know how (or does your host permit you) to use phpMyAdmin?

    Yes. I can use phpmyadmin.
    I guess what I need to know is how to completely delete a post. In phpmyadmin when I go to the table wp_posts and then browse, sort by id, and find the post that I think is giving me trouble (68), it says this when I click the check box, then try to delete:
    SQL query:

    DELETE FROM wp_posts WHERE ID =68 LIMIT 1

    MySQL said: Documentation
    #1034 – Incorrect key file for table ‘wp_posts’; try to repair it

    Try checking the database for errors?

    I have to say, I’m only just beginning with MySQL, so I don’t know how useful I can be here 🙂

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Archive Error after Editing Posts’ is closed to new replies.