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
Do a check table on the pictures table to get an actual MySQL error message.
problem solved. THere was a large file taking up all the space in /tmp