Hope someone can help. Nothing like this has ever happened to me b4.

I was adding new products to my store which isn't new and I was even surfing my store to copy descriptions from other products to paste into the new ones.

Everything was fine and after adding 3 products I went ot look at them in the store and it appeared as it is now, please have a look, http://www.easybeading.com.au

There is an odd error on the store section as such: 1 Can't create/write to file '/tmp/#sql_1ac8_0.MYI' (Errcode: 30)
in:
[select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows, banners_url from zen_banners where status = 1 and ( banners_group = 'SideBox-Banners') and banners_on_ssl= 1 order by rand()]

And also I have another error message in the admin section when I go to CATEGORIES/PRODUCTS and the categories arent showing. The message is 1 Can't create/write to file '/tmp/#sql_1ac8_0.MYI' (Errcode: 30)
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 zen_categories c, zen_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.

To get to my products I have to use the drop down menu. I hope someone can help, my store is absolutely useless like that and I have no clue what it could be.

Thank you.