Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Critical error There was an error while processing a database query  (Read 186 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

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4808
    • 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.