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: pic_count in albums is 0 but there are images?  (Read 2365 times)

0 Members and 1 Guest are viewing this topic.

gene-photo

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
pic_count in albums is 0 but there are images?
« on: February 01, 2007, 04:30:47 pm »

I have created a process (I.e. PHP) to extract/generate Coppermine based Simpleviewer pages...which I plan to share when working well.  You can see results here... http://gene-photo.homeip.net/Website/flash-gallery-index.html
Click on a thumb nail and it will bring up another page with Simpleviewer displaying the images.
My Coppermine site is here:  http://gene-photo.homeip.net/photos_dir

Note the images in the Simpleviewer are not copied but links into the Coppermine albums...including the thumbs.

I am trying to improve the speed of the script and thus the question....this is a cpg133_albums query with phpmyadmin.

14;Jennifer and Bryan opening some gifts ;;5;NO;YES;YES;127;10001;  0   ;103;0000-00-00 00:00:00;NO;;;; 
6;Matthew and Andrew;;5;NO;YES;YES;1;10019;   0  ;0;0000-00-00 00:00:00;NO;;;; 
7;Creatures;;0;NO;YES;YES;0;10018;  0   ;0;0000-00-00 00:00:00;NO;;;;
-------------many other lines with same issue not shown------------------------------

Note the pic_count and last_addition date/time are zero.

But the Coppermine is showing the correct number of images and date...see for example the in user gallery
Gene-photog in Creatures album. 4 Files and last one added on May 16, 2005.

I started with version 133 and updated to 1.4.10...I've run the Version Comparison and all looks right.
I've run the Update database...all looked ok...I saved the screen info from that and can provide.


Gene
Logged

Nibbler

  • Guest
Re: pic_count in albums is 0 but there are images?
« Reply #1 on: February 01, 2007, 04:51:59 pm »

Those fields are not used.
Logged

gene-photo

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: pic_count in albums is 0 but there are images?
« Reply #2 on: February 01, 2007, 05:02:16 pm »

Thanks for the quick reply...so is the same data stored in the database in some other area?

Gene
Logged

Nibbler

  • Guest
Re: pic_count in albums is 0 but there are images?
« Reply #3 on: February 01, 2007, 05:29:43 pm »

No, it is calculated every time it is needed.
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.