WordPress.org

Ready to get started?Download WordPress

Forums

Archive Error after Editing Posts (5 posts)

  1. moneydick
    Member
    Posted 8 years ago #

    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.

  2. Samuel B
    moderator
    Posted 8 years ago #

    I could read posts back to March 2005 and up to March 2006.
    The 2004 archives went to your old site.

  3. maerk
    Member
    Posted 8 years ago #

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

  4. moneydick
    Member
    Posted 8 years ago #

    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

  5. maerk
    Member
    Posted 8 years ago #

    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 :)

Topic Closed

This topic has been closed to new replies.

About this Topic