Photo Counts Way Off

[kevinrstruck]

RE: http://thephotostation.net/photopost/index.php

According to my Stats I have just about 12,000 pictures in my database, which is correct. (See stats on right side of page at my site)

My photo counts are as follows according to my PP homepage:

Member Galleries: 3817
Categories: 1561

So somewhere I am missing 6,000 pictures by count. Before I upgraded to 4.8.2 my member galleries count was more along the lines of 8,000.

Why would these counts change and how do I fix it?

[Chuck S]

Under Scan Database have you done a photos/post recount?

[kevinrstruck]

Yes, I have tried that several times with no luck.


1 Weird thing: About half way through the scan:

"Processing [albumn name]" actually turns into a clickable link.

I have sent you a PM with my Admin information so you can see what occurs when I run this scan. (Something I have not seen before). Maybe this will shed light on what is going on.

Thanks in advance.

[Chuck S]

Okay thats an easy one

Personal albums do not get counted in category totals

[kevinrstruck]

But there are more than 3800 pictures in the personal albums.

For instance on http://www.photoforums.com/photopost/, Member galleries says 2877 photos which matches the Statistics total on the page also. In fact, most if not all the sites I have gone to do the same. Mine did before I upgraded.

Now I have 3700 photos in member galleries and 12,000 in my stats total. I know the stats total is correct which leads me to believe the Members Gallery total is incorrect, which I know it is. Wouldn't all photos uploaded be considered member photos?

Maybe I am confused as to how this is supposed to work.

[Chuck S]

Count your members gallery and count your cats and thats your total count for cats.

personal gallery is different and not included. You have tons of em

If you think its off do an easy test go into phpmyadmin and do queries to grab total where cat types are a certain way

The overall statistics is a simple global query like this which counts everything

SELECT * FROM photos

Your cat counts are simple that cat counts where photos are in a category cattype c

[pleinlavue]

When a photo is in two or three categories, then the stats show a wrong total number of photos. (it count the same photo in multiple categories).

Shouldn't a photo be counted only once, even if it is in two or three categories ?


Maybe that has something to do with kevinrstuck the problem...

[Chuck S]

$query = "SELECT SUM(views), SUM(filesize), count(*) FROM {$Globals['pp_db_prefix']}photos";
$totalv = ppmysql_query($query,$link);
list( $totalviews, $diskuse, $totalphotos ) = mysql_fetch_row($totalv);
ppmysql_free_result($totalv);

The query that shows how many photos is simply a count of how many photo rows in the mysql table so yes a photo is counted once when uploaded to multiple cats