WordPress.org

Forums

Database error after editing a previous post (3 posts)

  1. Mardy
    Member
    Posted 10 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 10 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
    Member
    Posted 10 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,
    Marden

Topic Closed

This topic has been closed to new replies.

About this Topic