Community & Support

user warning: Can't create/write to file '#sql_17c_0.MYD' (Errcode: 17) query error

Hello All,

I installed and configured the Drupal5.12 on Windows Xp using XAMPP server. i regularly getting the same error as described bellow:

" * user warning: Can't create/write to file '#sql_17c_0.MYD' (Errcode: 17) query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (1) in D:\Hitechpedia_portal\xampp\htdocs\hrs\includes\database.mysql.inc on line 174.
* user warning: Can't create/write to file '#sql_17c_0.MYD' (Errcode: 17) query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 1 ORDER BY v.weight, t.weight, t.name in D:\Hitechpedia_portal\xampp\htdocs\hrs\includes\database.mysql.inc on line 174.
* user warning: Can't create/write to file '#sql_17c_0.MYD' (Errcode: 17) query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'marinelli' AND b.status = 1 AND (r.rid IN (1) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in D:\Hitechpedia_portal\xampp\htdocs\hrs\includes\database.mysql.inc on line 174."

please suggest me the solution for it. when get restart the xampp server again it got fixed but not permanently. Please suggest me the permanent fix for the same

I hope for positive response from your side soon.

Thanks & Regards
Mukesh

Comments

Errocode 17 means "File

Errocode 17 means "File exists". File '#sql_17c_0.MYD' is probably a temporary file created in your temp directory which MySQL can't overwrite.

Find your temp directory specified in MySQL's my.ini file with a tmpdir line.
A few things to try:
- Check/repair the drive partition where your tmp directory is.
- Empty your tmp directory. (This alone will probably fix the problem only temporarily).
- Disable your antivirus program or exclude your tmp directory from virus scanning.
- Check the permissions of your tmp directory. Is it writable by the web server (apache)?

nobody click here