Critical Error with DB Query

[cessam]

I just have upgraded from 1.3 to 1.4 and am getting a Critical Error.
There was an error while processing a database query

While executing query "SELECT * FROM copperminepictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8" on 0

mySQL error: Can't create/write to file '/var/tmp/#sql_131b1_0.MYI' (Errcode: 28)

I have tried to look around however nothing seems to be an exact match

[Nibbler]

You'll need to take this up with your webhost. Apparently they don't know how to run MySQL properly.

[cessam]

what exactly should I say?
I have these guys on the phone now.
Thanks

[Nibbler]

Tell them /var/tmp needs more free space.

[cessam]

It seems as though I didnt get the brightess person on the phone. They are not sure what that is.....

[cessam]

They are working on it as I type.
Now I am getting the error below: I assume its based on what they are doing?
Fatal error :

.

While executing query "delete from `"myuserID"_coppermine`.copperminesessions where time<1186960771 and remember=0;" on Resource id #6

mySQL error: Got error 127 from table handler

[Sami]

Now you have a corrupted table ,
Use your mysql tool (phpmyadmin) and run this sql
REPAIR TABLE table name

[cessam]

I did the repair on the table however now still getting the same error. It seems as though the number is increasing. I am wonderding if this host is still doing repairs on their end.

While executing query "delete from `userID_coppermine`.copperminesessions where time<1186993943 and remember=0;" on Resource id #6

mySQL error: Got error 127 from table handler

[Joachim Müller]

Ask your webhost for support then. Maybe you don't even have permission to actually repair the table, or it is broken beyond repair. Yours isn't actually a coppermine issue, but a mysql issue - we can't help you with this anyway.