• This morning, I found my blog had crashed after working fine through last night. I got an error similar to this, which I read has been tied to lack of memory on the host’s end:
    Database error: [Got error -1 from table handler]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2004-06-22 10:58:59’ AND (post_status = “publish”) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 10
    I read this has been fixed in the past by repairing the database tables so I did so (after making a backup of the db). During the repair I got this error message.
    error : 28 when fixing table
    error : Can’t copy datafile-header to tempfile, error 9
    status : Operation failed
    I got more errors when trying to bring up the blog so I uploaded the backup I created hoping I’d be back to the table handler error. Instead, now I’m getting this at the top (and some more errors under where the archives should be.
    Database error: [Can’t open file: ‘wp_posts.MYI’. (errno: 144)]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2004-12-02 19:10:59’ AND (post_status = “publish”) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 20
    Database error: [Can’t open file: ‘wp_posts.MYI’. (errno: 144)]
    SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < ‘2004-12-02 14:10:17’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
    Should I contact the host about a memory issue on there end still? Did something screwed up during the repair and restoration to the original db file? LMK. Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘database error can’t open file’ is closed to new replies.