I Got a Silly error while adding products

[vintageland]

All my product pages now have this error before the master products choose product box. What gives? I didn't do anything that should warranted an error.

 

Here's one of the pages where the error can be seen:

 

 

error here

 

 

1030 - Got error 28 from table handler

 

select p.products_model,pd.products_description, pd.products_name, p.products_id, p.manufacturers_id, p.products_tax_class_id, s.specials_new_products_price, s.status, p.products_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_master = '83' and p.products_status = '1' and pd.language_id = '1' order by p.products_id limit 0, 20

 

[TEP STOP]

[vintageland]

Ok, its magically fixed. I'd still like to know what would cause an error like this. Thanks.

[OceanRanch]

An error code 28 indicates that their was no disk space left on a particular device that mysql was using.

 

It may have been a large query that filled temp doing a sort, or maybe other tempory files that caused the problem. Your host probably had lots of other problems as a result of this and fixed it "behind" the scene for you.

 

If its your stand alone host then you might want to look at your available disk space.

 

HTH

Tom