mySQL error: Incorrect key file

[dcbrit2003]

Hi All,

When I go the album index/home page in my Coppermine installation I just started getting an error message and when itno debug mode. I saw this error message :

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

mySQL error: Incorrect key file for table '/tmp/#sql_179e_0.MYI'; try to repair it

I logged into MySQL manually and tried to repair the table with "repair table cpg143_pictures;" but this did not work. Any suggestions?

Regards, Mark

[kegobeer]

Do a check table on the pictures table to get an actual MySQL error message.

[dcbrit2003]

problem solved. THere was a large file taking up all the space in /tmp