WordPress.org

1. matson
   Member
   Posted 6 years ago #

   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.

2. Class
   Member
   Posted 6 years ago #

   I haven't tried MySQL on Windows for years, but maybe it's a permission problem? Does MySQL have write access to that directory?

3. matson
   Member
   Posted 6 years ago #

   yes, i set the user is ALL PRIVILEGES.

4. matson
   Member
   Posted 6 years ago #

   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

5. James
   Happiness Engineer
   Posted 6 years ago #

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

6. matson
   Member
   Posted 6 years ago #

   So, do i need to set the chmod?

7. James
   Happiness Engineer
   Posted 6 years ago #

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

8. matson
   Member
   Posted 6 years ago #

   but which file should i set to 777?

9. Class
   Member
   Posted 6 years ago #

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

10. matson
    Member
    Posted 6 years ago #

    ar...
    there is no a dir called"TEMP" under "Windows"
    so i just create one...and solve it...
    thx for your help!

11. dalyasp
    Member
    Posted 6 years ago #

    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!

12. Mark (podz)
    Support Maven
    Posted 6 years ago #

    Have you contacted Blogsome ?

13. christoball
    Member
    Posted 6 years ago #

    Well I hope Yahoo! is paying attention...

Topic Closed

This topic has been closed to new replies.