Support » How-To and Troubleshooting » [Resolved] WordPress database error

[Resolved] WordPress database error

  • 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)
  • I haven’t tried MySQL on Windows for years, but maybe it’s a permission problem? Does MySQL have write access to that directory?

    yes, i set the user is ALL PRIVILEGES.

    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


    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’.

    So, do i need to set the chmod?

    Moderator James Huff


    If that’s what you do on a Windows server to set file permissions, then yes.

    but which file should i set to 777?

    C:\WINDOWS\TEMP\#sql_abc_0.MYI or whatever the error message says.

    there is no a dir called”TEMP” under “Windows”
    so i just create one…and solve it…
    thx for your help!

    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!

    Have you contacted Blogsome ?

    Well I hope Yahoo! is paying attention…

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘[Resolved] WordPress database error’ is closed to new replies.