WordPress.org

Support

Support » How-To and Troubleshooting » Database error after editing a previous post

Database error after editing a previous post

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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.

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

    Thanks again,
    Marden

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database error after editing a previous post’ is closed to new replies.
Skip to toolbar