Support » Fixing WordPress » 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.

    Thread Starter mardy

    (@mardy)

    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.