database error can’t open file
-
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) ASyear, MONTH(post_date) ASmonth, 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!
The topic ‘database error can’t open file’ is closed to new replies.