No announcement yet.

Errcode: 17 - "Can't create/write to file ..."

  • Filter
  • Time
  • Show
Clear All
new posts

  • Errcode: 17 - "Can't create/write to file ..."

    Hey guys,

    I got the following error code yesterday from out of the blue. I've changed nothing on the forums for some time, and the hosts confirm they've not made any changes either.

    It's affected two areas that I've found - the private messages and the Admin Options.

    Any ideas?

    Invalid SQL:
    SELECT pm.*, pmtext.*
    , icon.title AS icontitle, icon.iconpath
    FROM pm AS pm
    LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
    LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
    WHERE pm.userid=4 AND pm.folderid=0
    ORDER BY pmtext.dateline DESC
    LIMIT 0, 50;
    MySQL Error : Can't create/write to file 'c:\windows\temp\#sql_7d4_0.MYD' (Errcode: 17) Error Number : 1

    Invalid SQL:
    SELECT setting.*, settinggroup.grouptitle
    FROM settinggroup AS settinggroup
    LEFT JOIN setting AS setting USING(grouptitle)
    WHERE settinggroup.displayorder <> 0
    ORDER BY settinggroup.displayorder, setting.displayorder;
    MySQL Error : Can't create/write to file 'c:\windows\temp\#sql_7d4_0.MYD' (Errcode: 17) Error Number : 1

  • #2
    System error: 17 = File exists

    Something on this server is not clearing out the temp directory on a reguular basis. Tell your host to empty that directory.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.