forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 PHPnuke/Postnuke Support => Topic started by: yonasb on November 14, 2003, 06:48:42 pm

Title: [EXPLAINED] alb_count, pic_count are always zero?
Post by: yonasb on November 14, 2003, 06:48:42 pm

in the cpg_catagories tables, the pic_count  and alb_count are always zero. arn't they supposed to hold the total number of pictures and albums in each catagory respectively?  It is also the same for the  user_lastvisit_cp filed on the nuke_users table. It seems to me that they are not getting updated correctlly.

the stange thing is that, the number of albums and pics that shows on my coppermine main page is correct. did they culculate on the fly?

--yonasb

Title: [EXPLAINED] alb_count, pic_count are always zero?
Post by: DJMaze on November 14, 2003, 09:54:39 pm

I also noticed it while fixing a count bug for the Users gallery.

Since MySQL counts in less then 0.01 second the total count of albums and catagories, i think the original developer removed the fields from the scripts.