WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Errcode 17 (16 posts)

  1. Lifespring
    Member
    Posted 9 years ago #

    Can anyone help me with this? Everything was working fine, but after making an edit to a post, my page won't load. In the sidebar, I get the following:

    [Can't create/write to file '/tmp/#sql_52d8_0.MYI' (Errcode: 17)]
    SELECT DISTINCT link_category, cat_name, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, list_limit FROM shownotes_links LEFT JOIN shownotes_linkcategories ON (link_category = cat_id) WHERE link_visible = 'Y' AND list_limit <> 0 ORDER BY cat_name

    http://lifespringonline.com/wordpress

    Thanks!

  2. Mark (podz)
    Support Maven
    Posted 9 years ago #

    Email your host. That is a database error.
    It's not a WP error, or caused by WP.

  3. Lifespring
    Member
    Posted 9 years ago #

    Just spent about 40 min on the phone w/them. They say the database is "working fine".

    What exactly needs to be done with the database? Their tech support guys say they need to know what the errcode: 17 is. BTW, the host is GoDaddy.

  4. birdielou
    Member
    Posted 9 years ago #

    I'm on godaddy, and having the same problem, and am emailing them now.

  5. Lifespring
    Member
    Posted 9 years ago #

    Well, it's nice to know I'm not alone! The tech support guy I talked to was pretty clueless about WordPress.

  6. RustIndy
    Member
    Posted 9 years ago #

    Sounds like someone changed the permissions on the /tmp folder and MySQL can't write to it anymore...

  7. Lifespring
    Member
    Posted 9 years ago #

    Well, I've emailed my support rep at GoDaddy. We'll see if this helps him any.

    If anyone has any more specific help, I'd sure like to hear it here...

  8. birdielou
    Member
    Posted 9 years ago #

    Mine seems to be working again? No reply from the email, though. Fingers crossed.

  9. Lifespring
    Member
    Posted 9 years ago #

    Mine is back too! Must've been GoDaddy's problem. Great!

  10. Mark (podz)
    Support Maven
    Posted 9 years ago #

    "Their tech support guys say they need to know what the errcode: 17 is."

    Is his JOB to KNOW what that is.
    Fire a complaint at godaddy.

  11. Looking at this MySQL Reference Manual :: 15.16.2 Operating System Error Codes.

    That error means that the file it is trying to write to (/tmp/#sql_52d8_0.MYI) already exists.

    That is what the problem is - mysql is trying to create a temporary file to store the query results and failing.

    westi

  12. flak
    Member
    Posted 8 years ago #

    Actually I got this problem too since a week. I've check around and the only thing I've found is other that have the same problem, and this thread :)

    I've check that the file can be created, and have find one other user on my host having the same problem.

    My site is flak.pdp10.org if someone want to have a look.

    Thanks for any suggestion!

  13. flak
    Member
    Posted 8 years ago #

    Arg my sysadmin just fix it but he didn't say to me yet what it was. So nevermind thanks anyway

  14. mmallett
    Member
    Posted 8 years ago #

    I've got Errcode: 17, but everything on my Blog has disappeared! No answers here either.... anyone know of a fix yet?

  15. Mark (podz)
    Support Maven
    Posted 8 years ago #

    All Errcodes - throw them straight at your host. They are the only people who can get in to where the errors are happening and sort them out.
    Copy all error messages to them without delay.

  16. ifelse
    Member
    Posted 8 years ago #

    anyone know of a fix yet?

    There's no fix as such as it's a hosting issue which your webhost will have to resolve. There is nothing that we/you can do on this end. You'll have to get them to investigate and chase them up about it.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags