Support » Fixing WordPress » Archive Error after Editing Posts

  • moneydick

    (@moneydick)


    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)
  • Samuel B

    (@samboll)

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

    maerk

    (@maerk)

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

    moneydick

    (@moneydick)

    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

    maerk

    (@maerk)

    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.