So last night, out of the blue (no changes, updates, nothing) my store starts acting up! You can see the main page just fine, but when you click on a product to view, you get this error message:

1 Can't create/write to file '/tmp/#sql_2562_0.MYI' (Errcode: 122)
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 = '50' and pa.options_id = '3' 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]

I'm thinking it's a database error since some of the other programs on my site that run on different databases are acting wonky, any ideas?