WordPress.org

Forums

[resolved] WordPress database error (13 posts)

  1. matson
    Member
    Posted 10 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 10 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 10 years ago #

    yes, i set the user is ALL PRIVILEGES.

  4. matson
    Member
    Posted 10 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 Huff
    Volunteer Moderator
    Posted 10 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 10 years ago #

    So, do i need to set the chmod?

  7. James Huff
    Volunteer Moderator
    Posted 10 years ago #

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

  8. matson
    Member
    Posted 10 years ago #

    but which file should i set to 777?

  9. Class
    Member
    Posted 10 years ago #

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

  10. matson
    Member
    Posted 10 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 9 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 9 years ago #

    Have you contacted Blogsome ?

  13. christoball
    Member
    Posted 9 years ago #

    Well I hope Yahoo! is paying attention...

Topic Closed

This topic has been closed to new replies.

About this Topic