Ready to get started?Download WordPress


Database error after editing a previous post (3 posts)

  1. Mardy
    Posted 9 years ago #

    All has been fine with my blog http://www.mcseavey.org/blog/ since mid-March when I set it up, until just about a half hour ago when I tried to edit an earlier post I had made. Then suddenly I'm getting errors.

    I can no longer view posts. Here's one of the messages I get:

    WordPress database error: [Can't open file: 'wp_posts.MYI'. (errno: 145)]
    SELECT COUNT(ID) FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2005-05-05 01:10:59' AND (post_status = "publish")

    I really have no idea what's going on or how to fix it.

    Here's another message I'm getting:

    SELECT ID, post_title,post_parent ,UNIX_TIMESTAMP(post_modified) AS time_modified,UNIX_TIMESTAMP(post_date) AS time_created FROM wp_posts WHERE post_status = 'static' ORDER BY menu_order ASC

    Thanks very much for any help or suggestions!

    Mardy ( mard@mcseavey.org )

  2. Kafkaesqui

    Posted 9 years ago #

    Looks like a database table corruption.

    Try accessing your database through whatever admin tool your host provides and run a repair on the tables. If you have phpMyAdmin, select the "check all" option in the main database view, and "repair table" from the dropdown list.

  3. Mardy
    Posted 9 years ago #

    Thank you! That seems to have done it. I simply clicked Repair in MySQL account maintenance. In an instant it was done.

    Thanks again,

Topic Closed

This topic has been closed to new replies.

About this Topic