Major problem with Database

[philip56]

Hi.

I have spent the afternoon adding meta tags to some of my items. Just come back to the computer after a break, gone into admin/catalogue/, clicked on category/products and got the following error

1 Can't create/write to file '/var/lib/mysql/#sql_7cd_0.MYI' (Errcode: 13)
in:
[select c.categories_id, cd.categories_name, cd.categories_description, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Clicking on an item under "new items for May" in the site (now down for maintenance gives the following

1 Can't create/write to file '/var/lib/mysql/#sql_7cd_0.MYI' (Errcode: 13)
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 = '114' order by p.products_sort_order, pd.products_name]


Any help would really appreciated


Philip

[DrByte]

Contact your hosting company.
That's a problem with the MySQL database server, which they will have to resolve for you.

[philip56]

Contact your hosting company.
That's a problem with the MySQL database server, which they will have to resolve for you.

Many thanks DrByte. I was begining to wonder if that was the case. Not long ago, I logged into my hosting companies forum and discovered that they were installing a Redhat update on my server this evening. Looks like something got a little messed up.

Kind regards

Philip

[Website Rob]

You should also use your Hosting control panel and check your Web space; could be you have used up all your allotted space.

Just a thought.