coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: gene-photo on February 01, 2007, 04:30:47 PM

Title: pic_count in albums is 0 but there are images?
Post by: gene-photo 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
Title: Re: pic_count in albums is 0 but there are images?
Post by: Nibbler on February 01, 2007, 04:51:59 PM
Those fields are not used.
Title: Re: pic_count in albums is 0 but there are images?
Post by: gene-photo 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
Title: Re: pic_count in albums is 0 but there are images?
Post by: Nibbler on February 01, 2007, 05:29:43 PM
No, it is calculated every time it is needed.