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

Hi all

Woke up this morning to grumpy emails from people, all their Zencarts have crashed over night with thsis error

1 Can't create/write to file '/tmp/#sql_2d9_0.MYI' (Errcode: 13)
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 = 'Wide-Banners') order by rand()]

Now I realise this is probably something my hosting company has changed that has caused this, however has anyone come across anything like this before??

Annd just for the record I am pretty sure they have all the banners turned off on these sites

One of the store is v 1.3.7 the other is more recent

and the server has PHP 5.2.10

nigelt74:

Can't create/write to file ...

... folder permissions issue... perhaps?

Yes I thought that, but it seems to have fixed itself now

Here's the information schoolboy didn't bother to explain ...

Error Code 13 means that MySQL cannot create a temporary file for the result set in the temporary directory. So, that means your hosting company's server config is either out of space or they have altered security/permission with respect to how MySQL is allowed to store its data and do its regular operations.
In short, log an urgent ticket with your hosting company if the problem persists.

nigelt74:

Hi all

Woke up this morning to grumpy emails from people, all their Zencarts have crashed over night with thsis error

1 Can't create/write to file '/tmp/#sql_2d9_0.MYI' (Errcode: 13)
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 = 'Wide-Banners') order by rand()]

Now I realise this is probably something my hosting company has changed that has caused this, however has anyone come across anything like this before??

Annd just for the record I am pretty sure they have all the banners turned off on these sites

One of the store is v 1.3.7 the other is more recent

and the server has PHP 5.2.10

Well this is funny mine is doing the same thing this afternoon. I don't know whats going on, but I will take Dr Byte suggestion.