Mysql Error: Can't create/write to file '#sql_5a0_0.MYD' (Errcode: 17)

Hello,

All of sudden a site has started to display this error:

1 Can't create/write to file '#sql_5a0_0.MYD' (Errcode: 17)
in:
[select c.categories_id, cd.categories_name, cd.categories_description, c.categories_image,                                          c.parent_id, c.sort_order, c.date_added, c.last_modified,                                          c.categories_status                                   from zen_categories c, zen_categories_description cd                                   where c.parent_id = '0'                                   and c.categories_id = cd.categories_id                                   and cd.language_id = '1' order by c.sort_order, cd.categories_name]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
```and trying to view a product on the shop side:

1 Can't create/write to file '#sql_5a0_0.MYD' (Errcode: 17)
in:
[select pov.products_options_values_id, pov.products_options_values_name, pa.* from zen_products_attributes pa, zen_products_options_values pov where pa.products_id = '547' and pa.options_id = '2' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '1' order by LPAD(pa.products_options_sort_order,11,"0"), pov.products_options_values_name]

But its also on product pages.

Any ideas whats causing it and a possible solution?

Your database server has a problem with its ability to store data properly. You might be out of allowed disk space on your account, or the server may have a serious problem.

That error message is something you need to report to your hosting company to have them resolve.

Yes sorry, i should of updated this thread. After contacting their host, they sorted it.

This just happened to a site I have on GoDaddy. Have contacted them but they haven't fixed it yet.

Phillip - do you remember (or know) what the host fixed for your client?

Same issue. Maybe the customer's hosting account is out of available disk space?
If not, the hosting company needs to do the fixing.