Can't create/write to file '/tmp/#sql_77f9_0.MYI' (Errcode: 122)

I have this error when I try to access Catalog/Categories/Products.

My wife and I were on 2 separate computers working on the admin section under the same account name.

1 Can't create/write to file '/tmp/#sql_77f9_0.MYI' (Errcode: 122)
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.

All my products now read

1 Can't create/write to file '/tmp/#sql_77f9_0.MYI' (Errcode: 122)
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 = '66' order by p.products_sort_order, pd.products_name]

Sorry! I restarted my server and everything is back.

maxilious:

1 Can't create/write to file '/tmp/#sql_77f9_0.MYI' (Errcode: 122)

That's a MySQL error ... typically resulting from an out-of-disk-space or disk quota condition.
You should check to be sure that your server's disk space thresholds are not maxed out.

Thank you for taking the time to read my post. My server shows about 1/8 of my disk space used. But the server is getting slow and other things are begging to flake out. I think my server is having some major troubles.

This is getting interesting If you look at one of my categories such as decks (I have a skateboard shop) it looks fine. You can even select one of the boards from below under featured products and it will even let you purchase that deck.
http://www.skatopia-skateshop.com/index.php?main_page=index&cPath=1

Now if you click on one of the deck companies such as Black Label you get a error message printed right on the screen-
1 Can't create/write to file '/tmp/#sql_3dec_0.MYI' (Errcode: 122)
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 = '162' order by p.products_sort_order, pd.products_name]

It is as if my categories are mesed up but the products are not.

In the Admin menu everything works except Categories/Products

I tried to optimize my database and i got yhis message-

1016 Can't open file: 'configuration.MYI' (errno: 144)

Sounds like your database server is having some serious issues. These must be handled by the server administrator.

The server admin at Lunarpages.com is blaming this on my inode max being reached. They give you 200000 inodes for a VPS account. They have raised mine to 250000 but we are still getting this error. I erased most of my cache and now only have about 140000 Inodes yet my cart is still not working.

I am not sure if I should rebuild from backup or just take my business to another host.

It seems you've outgrown your hosting environment.

Check out alternate hosting options designed for Zen Cart by clicking the "hosting" link at the top of this page.

Thank you I will check out the hosts from above.

I was snooping around myphpadmin and I have found that the table "configuration" appears to be corrupted. When i try to browes this table I get the error code-
#1016 - Can't open file: 'configuration.MYI' (errno: 144)

If your operating system is limiting you, then that doesn't necessarily indicate corruption, but rather a limitation in access.

maxilious:

The server admin at Lunarpages.com is blaming this on my inode max being reached. They give you 200000 inodes for a VPS account. They have raised mine to 250000 but we are still getting this error. I erased most of my cache and now only have about 140000 Inodes yet my cart is still not working.

I am not sure if I should rebuild from backup or just take my business to another host.

Even 200,000 sounds small for a VPS but then again, I work with Dedicated Servers and their numbers can be in the Millions. Not even sure why, though, they would be monkeying around with Inode settings to begin with. Sometimes defaults are good.

As you've seen, Inodes are attached to files and some files use a lot more Inodes than others. A major one is your Apache 'error_log'. You could stop Apache, rename the 'error_log' then restart Apache and check your Inodes again -- Apache will recreate the 'error_log' file for you. If no appreciable decrease then stop Apache, remove the 'error_log' and restart your VPS.

Otherwise, then yes, time to find another Hosting solution. Perhaps you "do need" a Dedicated? Which could be good news if your site is busy and also pulling in lots of orders. :wink:

Thank you Rob and Dr. Byte. You guys are what I love about the internet - people helping people.

This happened on a weekend and you know how it is when something goes wrong with a vps type server on a Friday(no offense to Lunar support but its not always the A-team on the weekend shift). So I bit the bullet and restored from a 1 week old backup. It's working fine for now but I will take your advice and change hosts and or plans.