Forums / General Questions / Can you help me figure out this error?

Can you help me figure out this error?

Locked

Started by karstensmommy on 22 Aug 2006, 6:24 PM · Views: 1,017

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
22 Aug 2006, 6:24 PM
#1
karstensmommy avatar

karstensmommy

New Zenner

Join Date:
Aug 2005
Posts:
36
Plugin Contributions:
0

Can you help me figure out this error?

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?

22 Aug 2006, 11:58 PM
#2
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,688
Plugin Contributions:
0

Re: Can you help me figure out this error?

Yes, it is the database. Restart MTSQL and do a repair on the tables.

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.