The cpg_pictures table is corrupted beyond repair. All the other tables appear to be Ok. Has anyone any advice on how best to fix the situation? Obviously I'll have to delete the table, but what to do after that? Recreate just the cpg_pictures table or do an install? What happens to all the images in the images stored in the albums? Any assistance gratefully accepted.
did you try the repair functions of mySQL (e.g. using a tool like phpMyAdmin)? What exactly do you mean by
Quotecpg_pictures table is corrupted beyond repair
? Did you mess with it or did it "break" by itself?
Obviously, if you delete the pictures table, all pics in your db will be lost, so you'll have to add them again (using btach-add). It's recommended not to do a fresh install, but just drop the table and create it again, so you won't lose registered users etc.
Posting a link might help...
GauGau
It "broke" itself. One day the gallery was there, the next day it wasn't. If I try to access the table using ISP provided tools, I get
QuoteSelect failed: select * from cpg11d_pictures
Can't open file: 'cpg11d_pictures.MYD'. (errno: 145)
Minds greater than mine have subsequently tried to fix it using a range of tools including phpMyAdmin but have declared it unsalvageable.
A link? http://www.customart.co.nz/gallery/
Out of curiosity, do you do frequent batch adds?
No.
Only a few images get added each month, so they are added one at a time. In total there were about 90 images.
A nice article on database corruption in MySQL.
http://www.databasejournal.com/features/mysql/article.php/3300511
Quote from: "hyperion"A nice article on database corruption in MySQL.
http://www.databasejournal.com/features/mysql/article.php/3300511
Thanks, I'll keep that URL as a handy reference. unfortunately I think everything suggested and more had been done.
The experts have told me that I can't blame Coppermine for the problem. If the damage had been done by a script, it would be repairable, so they say. Apparently such catastophic failures are rare. I hope they are correct.