Title: wp_posts.MYI ???
Last modified: August 18, 2016

---

# wp_posts.MYI ???

 *  [pixellated](https://wordpress.org/support/users/pixellated/)
 * (@pixellated)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/wp_postsmyi/)
 * We’re getting the following error(s) on our front page:
    ———– Database error:[
   Can’t open file: ‘wp_posts.MYI’. (errno: 145)] SELECT DISTINCT * FROM wp_posts
   LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND (category_id!
   = 2) AND post_date_gmt <= ‘2004-11-22 18:46:59’ AND (post_status = “publish”)
   GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 15 Database error: [Can’t 
   open file: ‘wp_posts.MYI’. (errno: 145)] SELECT DISTINCT YEAR(post_date) AS `
   year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_date
   < ‘2004-11-22 13:46:34’ AND post_status = ‘publish’ GROUP BY YEAR(post_date),
   MONTH(post_date) ORDER BY post_date DESC ————– I’ve never heard of file ‘wp_posts.
   MYI’ … what is this, what’s happening, and how can we fix it? Thanks!

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

 *  Thread Starter [pixellated](https://wordpress.org/support/users/pixellated/)
 * (@pixellated)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/wp_postsmyi/#post-111916)
 * Nevermind.
    Found out that, for whatever reason, it has something to do with 
   changing the post content fieldtype from TEXT to LONGTEXT (as someone in another
   thread suggested doing for extra-long posts)… apparently, while it works for 
   some people, it caused MySQL on our host to go completely berzerk and give the
   errors above. After we were able to log back into PHPMyAdmin and change the content
   fieldtype back to “TEXT” and the host ran a repair on MySQL, everything worked
   fine. We actually tried doing this several times, and each time, the host had
   to run a repair on MySQL… so we’re not touching the field types anymore, and 
   the site owner will just have to be less verbose in the future! 😉
 *  [likoma](https://wordpress.org/support/users/likoma/)
 * (@likoma)
 * [20 years, 2 months ago](https://wordpress.org/support/topic/wp_postsmyi/#post-112117)
 * Thanks for this. I did a “check” my PHP MyAdmin for the SQL DB and saw some error,
   so I did a “repair” and it fixed it and now all is working. Hmm, so a really 
   long post did this? The posts aren’t that long. Hmm.
 * Thanks again for posting this.

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

The topic ‘wp_posts.MYI ???’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [likoma](https://wordpress.org/support/users/likoma/)
 * Last activity: [20 years, 2 months ago](https://wordpress.org/support/topic/wp_postsmyi/#post-112117)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics