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 - select count  (Read 2937 times)

0 Members and 1 Guest are viewing this topic.

teggan

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Critical error - select count
« on: March 09, 2011, 09:12:43 am »

While editing comments and deleting photos on my photo gallery i got a Critical error message.
It's updated to latest version.

Gallery page: http://krigsbilder.net/coppermine/index.php

While executing query 'SELECT COUNT(*) FROM cpg14x_comments WHERE pid = ' in include/functions.inc.php on line 2445

I'm not sure what happend, but after looking through the album I was editing it looks like some of the photos that I tried to delete
still are visible as thumbs  but not in the database. All done withing cpg.

Will this be fixed if I delete the whole album, or would the best thing be to install the backup and then try to remove the files that seams to be corrupting the database?


Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error - select count
« Reply #1 on: March 09, 2011, 12:42:09 pm »

Please try if it works when you disable the plugin engine: http://krigsbilder.net/coppermine/pluginmgr.php
Logged

teggan

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: Critical error - select count
« Reply #2 on: March 09, 2011, 01:24:56 pm »

Unfortunatly that didn't help.

When I'm trying to interpret the info I'm getting back, it looks like the db related to one of the albums is corrupt.

It that's the case, will it help deleting the whole album? Or will it continue untill I resolve the probleme manually.
Logged

Nibbler

  • Guest
Re: Critical error - select count
« Reply #3 on: March 09, 2011, 01:31:26 pm »

That's caused by deleting the picture you are using for an album thumbnail. See http://forum.coppermine-gallery.net/index.php/topic,67596.0.html for a solution.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error - select count
« Reply #4 on: March 09, 2011, 01:35:09 pm »

Have you updated your gallery from cpg1.4.x?
Logged

teggan

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: Critical error - select count
« Reply #5 on: March 09, 2011, 01:50:59 pm »

Thank you Nibbler for refering me to the solution. That fixed it.

Thank you André for you effort. I'm running the latest version, updated it every time a new release have been out.

Sorry for wasting your time, but I must have missed this post. The pages have been up and running for several years, updated at new releases. And this is the only probleme I ever have had.
(Except when I have tried to fix things manually myself.)

This is a solved case.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error - select count
« Reply #6 on: March 09, 2011, 01:54:09 pm »

I just want to know if you started with cpg1.5.x or if your gallery was an cpg1.4.x (or earlier) gallery, as that problems seems to occur just for galleries that have been updated from cpg1.4.x (or earlier).
Logged

teggan

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: Critical error - select count
« Reply #7 on: March 09, 2011, 02:01:55 pm »

Originally this album was started in 2004, and I belive it was cpg1.3 or earlier. I modified it and made a clean install in 2009 with cpg1.4.24
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 19 queries.