Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Critical error There was an error while processing a database query  (Read 1679 times)

0 Members and 1 Guest are viewing this topic.

ayaba

  • Coppermine newbie
  • Offline Offline
  • Posts: 3

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
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me

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.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

ayaba

  • Coppermine newbie
  • Offline Offline
  • Posts: 3

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.
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 19 queries.