Comments and photos dont match

iloco · June 26th, 2006, 10:12 PM

I ran a purge all photos that were older than 365 days and now my photos and comments dont match what I got in all members categories.

Photos in All members show 658 pics and in all my categories I only show 645. This is 13 pics that are not showing in all members.

Same with comments. In all Members I have showing 5371 but in all categories I have 4883 a difference of 488 comments.

I ran the resync data comemnts in scan data base but still got the differences.
Any idea how to make them correspond as they once did.

Chuck S · June 27th, 2006, 09:51 AM

Are you using the cache? what happens if you turn off the cache?

Also do you have set in the Index Options that members gallery shows all a user's photos to yes or no?

iloco · June 27th, 2006, 10:19 AM

Chuck I have Cache set to NO and show all users photos to YES.

I can go into phpmyadmin and enter correct numbers to get the commrnents and photos to show correct in all members so its the same as my category totals but once I run scan data bast to resync phots/comments username/update comments count,
I also ran clcik here to recaluate photo/posts numbers and check children.

I have no idea why its messed up after using the purge option to delete photos that were older than 365 days.

Chuck S · June 27th, 2006, 10:31 AM

Please post some examples here

iloco · June 27th, 2006, 10:55 AM

In my All memberes I have showing photos 659
In all my categorys I have showing 646 total which is 13 less than in All members.

In my comments in All Members I have 5389 showing.
In all gategorys I have 4903 total showing which is 486 less than in All Members.

Attached is a pic of what I see.

You can visit my site Here
User: test
Pass: test

I can give access to phpmyadmin if needed.

Chuck S · June 27th, 2006, 11:35 AM

I see your thinking process

Okay your members gallery shows all a users photos meaning the difference in the counts is because you have 13 photos uploaded to the members gallery with 486 comments on them. See the difference now? If you set members gallery shows all a users photos to no you will see your members gallery give the count of 13 and 486

iloco · June 27th, 2006, 12:36 PM

Chuck I found all the photos that were in All Members category and not in other categorys.
I moved all of the ones that were in All Members into a category and now my All Members photos count is the same as all my cateegorys.

Now my comments are still not in sync.
I am showing 5,389 in All Members but have ony 4,922 in all the categorys. That is a difference of 467 comments.

I did as you said and set show all members photos to no and now I have o showing for all members after I moved all into a category.
I now show 459 comments in all members but have no photos in All members so I dont know how to clear these comment to 0.

I wish it were possible to hide the ALL Members dropdown when members uplaod a pic so they would have to choose a category. Is this possible.

You can use login to see what I have now.

Attached is pic of what it looks like when I have show all members to NO.
Why when no photos in all members is it showing comments if there are no photos in All Members. I am confused.

Chuck S · June 27th, 2006, 04:35 PM

Interesting maybe comments where the photos where deleted and comments did not get deleted? You could do a mass query if there are no photos in the members gallery like so

DELETE FROM pp_comments WHERE cat=500

You can remove upload permissions on the members gallery in Admin => Edit Cats so they can not upload to it.

iloco · June 27th, 2006, 05:14 PM

Thanks Chuck what if I were to go into edit category and in ALL members choose EMPTY would this remove the comments now that I have moved the pictures to other categorys.

Or would it be best to run your query to do this.
When I run a query I usualy ahve to remove the pp_ from the query you show to get it to work. Why is this........?

If I set in categories so registered users can not upload will the pictures still go into all members gallery even though they will be going into another.

Chuck S · June 27th, 2006, 07:23 PM

No they will need to pick a cat

You can use empty

iloco · June 27th, 2006, 07:36 PM

Got it close to what it should be now.
Photos match nembers but comments are off now by 7. Weird.

iloco · June 28th, 2006, 09:37 AM

How can I delete all comments in all categories so as to get my comments right with my photo count right again with out removing any of the pictures that are now in my photopost gallery.

For some odd reason after I used the Purge Old photos my comments are not adding up right with the photos I still have showing.

Is there a mysql query I can use to do this. I dont want to reinstall photopost to get it back as its suppose to be if at all possible.

Chuck thanks for your help on this one.

I didn't have the option to delete this thread but found what I need in a search to delte all the comments by using phpmyadmin and empty the table for comments. Pleas remove this post if not needed.

Chuck S · June 28th, 2006, 10:37 AM

so you got your answer in phpmyadmin

iloco · June 28th, 2006, 10:44 AM

Yes if I am correct I can use the empty to remove all comments in the gallery.
This should then let the comments be accurate once again when people comment on a pic.
I integrated two categorys into one and for some reason I think this is where I goofed and my comments are not the same in All Member as in all my categorys now.
I hate a small problem that I can't find why its not working as should be.

In my Bike gallery I count only 45 comments under each picture but on the home page it shows 66 comments. I have no idea when run a data base scan to resync all comments its not reading the 45 but keeps giving me the 66.

Chuck S · June 29th, 2006, 01:06 PM

Are you electing to not show empty comments (ratings) in the admin options?

iloco · June 29th, 2006, 01:31 PM

I have it set to yes to show comments in admin options.

I deleted all my comments in phpmyadmin in all categorys and All Members Category where all the pictures from all categorys are shown.

I now get the correct comments in all categorys showing but the count doesnt show in ALL Members even though you can look in all members and see the comments.
I can scan data base and run the Check here to recalculate photos/post numbers and all children and then it will show the amount of comments in the all members comments beside the photos count that are in all the categorys.

Why is the All Members comment not picking up the category comments is my question.

Would this be a cache thing. I have cache set to 0.

I have attached an image showing 8 new comments in my categorys but is only showing two in my all members category. Shouldnt that be 8 also instead of the two that is showing. I can go into all members category and see the 8 comments.

my photopost gallery is Here

User: test
Pass: test

Chuck S · June 29th, 2006, 01:36 PM

In Admin => Show Photo Options

Display ratings that have no comments attached?

this is what I am referring to. If a user just rates a photo you will not see the comment with that set to NO.

iloco · June 29th, 2006, 02:32 PM

I have ratings shut off so members can not rate photos.
Display ratings that have no comments is set to NO.
Display quuick ratings under photo is set to NO.

I shut off ratings because members didnt like how their imges were rated a lot the time so to cut down on the hazzle I dont want ratings to be shown.

Is this why my ALL members category is not showing the correct amount of comments. My photos in All Members is showing the correct number of photos in All members being 666 as of now.

At one time My all members category was showing the right amount of comments that were in all the other categorys. Something is not set right or the last update 5.31 may be why the all members comments are not refreshing and showing the correct number.
I can run scan data base and it will then show the correct number of 8.
Shouldnt this be picking the comments up as a member comments in a category other than ALl members but still the pic will go into all members with the comment.

I am a little confused now as it was working not long ago before I delted a few members and their images. By clearing all comments I should be back to a fresh begining with comments.

Maybe attached pic will show what I was wanting to know how to set something so the comemnts of 12 will = the 12 without having to scan database and use those options..... Now to get the 12 to equal 15 I have to go to scan database and go to Check here to recalculate photos/posts numbers and check children to get it to show 15 comments. Is this a bug or am I going crazy.....

iloco · June 30th, 2006, 01:25 PM

See my last attached pic in above comment. Maybe this will better explain what I dont understand. Something is not refreshing or picking up comments in all members as other categorys. Is it a bug or how its suppose to be. I can run scan data base and the comments in all members will be same as in statisic.

Chuck S · June 30th, 2006, 02:29 PM

Right but see if you had ratings originally set given the way you have things set this explains how your getting confused. If you had ratings on at one point and the setting I note is set to no. Then your not going to see the comments as they are simply ratings.