1030 Got error 122 from storage engine?!?!help!

[mieego81]

Hi i went on my website today and when i click on my products instead of showing them it has an error message : 1030 Got error 122 from storage engine
in:
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1' order by p.products_sort_order, pd.products_name]

i am using 2003-2008 Zen Cart™
my website is http://www.mieego.com

I'm a graphic designer therefore not to good with this kinda problem, i will be very grateful for someones help. Thanks

[DrByte]

You should talk to your hosting company about the issue immediately. It's possible that your hosting account has run out of disk space, or maybe the server has run out of disk space or temporary file space.

[Tech-E]

I just ran into the same problem. There is a temporary file on the server that has a 100 meg capacity. You get the error when it exceeds the capacity.

Either the server needs to be rebooted or you need root access to your server in order to clear the file.

If you do not have WHM or root access, Contact your hosting company.

How can I prevent ZenCart from displaying the select statements on the pages if an error like this happens again?

I checked my WordPress sites (all are on a VPS server) and they were working and not displaying the SQL code, but the category links were not displaying on the pages. In other words, WordPress was suppressing the error message, while ZenCart was displaying it.

[thefashionhut]

I am currently experiencing the same problem as the OP.

I have the following so should not be problem:

* 10GB Disk Space
* 320MB RAM
* 300GB Bandwidth
* 3 IP Addresses
* Plesk v9 Control Panel

Any ideas?

[Ajeh]

You site in your signature appears to be working, have you resolved this issue?

[thefashionhut]

Originally Posted by Ajeh

You site in your signature appears to be working, have you resolved this issue?

Yes all OK for now. It was a disk space problem.

[Ajeh]

Thanks for the update ... it is always a help to others to have a solution to problems ...