Title: WordPress database error
Last modified: August 18, 2016

---

# WordPress database error

 *  Resolved [matson](https://wordpress.org/support/users/matson/)
 * (@matson)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/)
 * WordPress database error: [Can’t create/write to file ‘C:\WINDOWS\TEMP\#sql_abc_0.
   MYI’ (Errcode: 2)]
    SELECT DISTINCT * FROM nwp_posts WHERE 1=1 AND post_date_gmt
   <= ‘2005-07-26 15:08:59’ AND (post_status = “publish” OR post_author = 1 AND 
   post_status != ‘draft’ AND post_status != ‘static’) GROUP BY nwp_posts.ID ORDER
   BY post_date DESC LIMIT 0, 10
 * how to solve it?Although I create a new DB for install WP, when I create new 
   post it comes out.

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

 *  [Class](https://wordpress.org/support/users/class/)
 * (@class)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-239752)
 * I haven’t tried MySQL on Windows for years, but maybe it’s a permission problem?
   Does MySQL have write access to that directory?
 *  Thread Starter [matson](https://wordpress.org/support/users/matson/)
 * (@matson)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-239771)
 * yes, i set the user is ALL PRIVILEGES.
 *  Thread Starter [matson](https://wordpress.org/support/users/matson/)
 * (@matson)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-239971)
 * I also found this mes in Custom Fields
 * WordPress database error: [Can’t create/write to file ‘C:\WINDOWS\TEMP\#sql_abc_0.
   MYI’ (Errcode: 2)]
    SELECT meta_key FROM wp_postmeta GROUP BY meta_key ORDER 
   BY meta_id DESC LIMIT 10
 *  Moderator [James Huff](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-239978)
 * The problem isn’t the user, it’s the file’s permissions, or privileges, unfortunately
   I have never used a Windows server, so I don’t know which it uses. The error 
   states that MySQL cannot create or write to the file ‘C:\WINDOWS\TEMP\#sql_abc_0.
   MYI’. And, that is what the problem is. It has nothing to do with the users privileges.
   It has everything to do with MySQL’s ability (and/or authority) to create and/
   or edit the file ‘C:\WINDOWS\TEMP\#sql_abc_0.MYI’.
 *  Thread Starter [matson](https://wordpress.org/support/users/matson/)
 * (@matson)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-239984)
 * So, do i need to set the chmod?
 *  Moderator [James Huff](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-239988)
 * If that’s what you do on a Windows server to set file permissions, then yes.
 *  Thread Starter [matson](https://wordpress.org/support/users/matson/)
 * (@matson)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-240059)
 * but which file should i set to 777?
 *  [Class](https://wordpress.org/support/users/class/)
 * (@class)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-240094)
 * C:\WINDOWS\TEMP\#sql_abc_0.MYI or whatever the error message says.
 *  Thread Starter [matson](https://wordpress.org/support/users/matson/)
 * (@matson)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-240302)
 * ar…
    there is no a dir called”TEMP” under “Windows” so i just create one…and 
   solve it… thx for your help!
 *  [dalyasp](https://wordpress.org/support/users/dalyasp/)
 * (@dalyasp)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-240475)
 * Hi!
    Well, I’ve been using my blog for about a month and a half, and today I 
   coudn’t log in, because there’s an error… Blogsome doesn’t recognizes me.
 * How can I solve this?? I don’t want to abandon my blog for this reason!
 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-240476)
 * Have you contacted Blogsome ?
 *  [christoball](https://wordpress.org/support/users/christoball/)
 * (@christoball)
 * [19 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-240574)
 * Well I hope Yahoo! is paying attention…

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

The topic ‘WordPress database error’ is closed to new replies.

## Tags

 * [(Errcode:](https://wordpress.org/support/topic-tag/errcode/)
 * [(Errcode: 2)](https://wordpress.org/support/topic-tag/errcode-2/)
 * [db](https://wordpress.org/support/topic-tag/db/)
 * [window](https://wordpress.org/support/topic-tag/window/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 12 replies
 * 6 participants
 * Last reply from: [christoball](https://wordpress.org/support/users/christoball/)
 * Last activity: [19 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-1-2-3-4-5-6-7-8/#post-240574)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics