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

[PhillipHarrison]

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]

First saw it in the admin panel, by going into Catalog -> Catagories/Products

But its also on product pages.

Any ideas whats causing it and a possible solution?

[DrByte]

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.

[PhillipHarrison]

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

[Duckarina]

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?

[DrByte]

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