"1030 Got error 28 from storage engine" while updating category/attributes

[ocsand]

NOW Products will not display in the cart as items display similar messages
http://www.seasidestampin.com/zencar...=index&cPath=1
Now what? version 1.3.8
Please help....


1030 Got error 28 from storage engine
in:
[select p.products_image, p.products_model, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, 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 zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_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]

[kuroi]

Never experienced it personally, but I believe that it means your database doesn't have enough space left to complete the query.

[DrByte]

Error code 28: No space left on device

One or more partitions on your server is out of space or doesn't have enough space to complete this operation. You need to contact your host immediately. You or your host will need to find out which partition is low on disk space and either add more space or free up some.

Or maybe your hosting account has reached the limit of disk space allowed.

[agamic]

NOW Products will not display in the cart as items display similar messages
http://www.seasidestampin.com/zencar...=index&cPath=1
Now what? version 1.3.8
Please help....


1030 Got error 28 from storage engine
in:
[select p.products_image, p.products_model, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, 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 zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_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]

Hi
I am getting the same error all of a sudden when going into admin-catalog and also on the site only some categories display the error, other categories display the products just fine?
ZC 1.3.7

[ocsand]

will the problem resolve itself when host-99 frees up enough space?

[ocsand]

do you usse host-99 as your cart and webhost?

[agamic]

do you usse host-99 as your cart and webhost?

I use host-99 and it has just started


Thanks Dr Byte for the heads up

[ocsand]

I use host-99 and it has just started


Thanks Dr Byte for the heads up

i just cut & pasted the replies here and e-mailed them to host-99 support...

[duffy]

You can add me to this list also and yes, I too use Host-99. Is there an issue with Host-99?

[knuckle-101]

Hello,

NO there is not an issue with our servers the issue is that you maybe on a plan that is to small for your business and the tmp folder fills a lot quicker on smaller servers.

The bigger your website grows the more resources it requires. There were only a few hard drives effected and apparently your two websites were the hardrives effected.

However we cleaned your database and optimized this for you, we recommend keeping your database optimized and well maintained for future issues.

Or maybe think about upgrading to a plan that can handle your needs. (Means bigger plan = bigger hardrives)

We are keeping an eye on this for a few days and see what happens.