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

[KityKatze]

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

[Steve Machol]

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.