I've been running ZenCart with no problems for about a year now. A couple weeks ago NameSecure decided to update their MySQL database version and change permisions so that I can no longer use the /tmp folder.

Because of the above I get the following error on the store front:
1 Can't create/write to file '/tmp/#sql_3a2a_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') order by rand()]

In addition to the above admin section is flaky if it works at all.

I found one thread on the forum describing the error I'm getting and it suggested that you have the sys admin change your permissions. After many hours on the phone I found out that I can't have that done. So, it leaves me up the proverbial creek.

Namesecure told me to create a tmp folder at my root and insert the following line on every PHP page and before the session_start line:
session_save_path('.../web/tmp')

It seems that this might work but that it would only have to be applied at a couple of places in the ZenCart files structure...problem is I don't know enough yet to know where...

Could anyone help shed some light on this problem?

Thanks!