Title: database error can’t open file
Last modified: August 18, 2016

---

# database error can’t open file

 *  [brave3](https://wordpress.org/support/users/brave3/)
 * (@brave3)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/database-error-cant-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) 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)

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/database-error-cant-open-file/#post-115272)
 * Email the hosts definitely.
 *  Thread Starter [brave3](https://wordpress.org/support/users/brave3/)
 * (@brave3)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/database-error-cant-open-file/#post-115305)
 * Thanks. Host was able to get the table repaired on their end.

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

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [brave3](https://wordpress.org/support/users/brave3/)
 * Last activity: [21 years, 6 months ago](https://wordpress.org/support/topic/database-error-cant-open-file/#post-115305)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics