Hello, I hope this is the right place to ask this, But I when on my site's gallery today (http://kat-mcnamara.net/gallery) and got "Critical error There was an error while processing a database query." on it. I just did a update to the latest version to see if that would help and it did nothing. I put on Debug and got this
"While executing query 'SELECT COUNT(*)
FROM cpg16x_pictures AS r
INNER JOIN cpg16x_albums AS a ON a.aid = r.aid
WHERE (1)
AND approved = 'YES'
AND hits > 0' in include/functions.inc.php on line 1810
database error: 1712 : Index cpg16x_pictures is corrupted
File: /home2/katmcnamara/public_html/gallery/include/functions.inc.php - Line: 250
and that line says
cpg_die(CRITICAL_ERROR, $out, __FILE__, __LINE__);"
If any one can help me out with what is wrong and how to fix it i would be so grateful
If you have phpmyadmin access then use the repair option on that database table. If you struggle then often the host can help. Or restore that table from a backup.
Quote from: Phill Luckhurst on July 21, 2021, 09:35:46 PM
If you have phpmyadmin access then use the repair option on that database table. If you struggle then often the host can help. Or restore that table from a backup.
Thank you, I when into my phpmyadmin and the gallery in there and did a repair on both the full gallery and still has the same message, time to send a message to my host.