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
You'll need to take this up with your webhost. Apparently they don't know how to run MySQL properly.
what exactly should I say?
I have these guys on the phone now.
Thanks
Tell them /var/tmp needs more free space.
It seems as though I didnt get the brightess person on the phone. They are not sure what that is.....
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
Now you have a corrupted table ,
Use your mysql tool (phpmyadmin) and run this sql
REPAIR TABLE table name
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
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.