i searched a little for this and could not find anything that answered my question...so I am posting here.
I was doing a batch upload from my FTP to the gallery and ended up getting this critical error:
"While executing query "SELECT * FROM cpg14x_pictures WHERE approved = 'YES' ORDER BY RAND() LIMIT 8" on 0
mySQL error: Incorrect key file for table '/tmp/#sql_53a6_1.MYI'; try to repair it"
what do I need to do to fix this and not lose any info from the gallery?
Try to repare the table usgin phpMyAdmin as the error suggested.
umm....I honestly don't know how to do that, is there someone that could assist me, please....
Ask the hosting company where your site is hosted.
sorry to ask this....but why would I ask my hosting company if this is a Coppermine program issue?
Do as suggested please. It's due to a DB problem, so it's not a CPG issue but a Hosting one.
As Fabri already explains this concerns a mysql error.. not a coppermine error.
Quote"mySQL error: Incorrect key file for table '/tmp/#sql_53a6_1.MYI'; try to repair it"
Hence you have to either repair it yourself using phpmyadmin or have your host do it.
Cheers
Hein
ok...thank you.
You can't repair it yourself since it's a temporary table. Best you can do is disable the random files block in config.