mysql error

[jokotten]

Hello,

suddenly I get a MySql-Error.

*****************************

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

mySQL error: Incorrect key file for table '/var/lib/mysql/.tmp/#sql_e94_0.MYI'; try to repair it

****************************
But on the server ist no file like sql_e94_0.MYI - so I can't repair it.

Please help me to fix this error.

Thank You
jokotten

[Joachim Müller]

Ask your webhost for support. That file is the core of the mysql database. You don't have access to that if you're webhosted. The error means that your mysql database is broken. Not related to coppermine.
If you have further questions, please respect board rules in the future: it's mandatory to post a link to your gallery in each thread you start.