View Full Version : Comments and photos dont match
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. :)
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?
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.
June 27th, 2006, 10:31 AM
Please post some examples here
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 (http://www.iloco.org/photopost/index.php)
I can give access to phpmyadmin if needed.
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 ;)
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.
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.
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.
June 27th, 2006, 07:23 PM
No they will need to pick a cat
You can use empty
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.
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.
June 28th, 2006, 10:37 AM
so you got your answer in phpmyadmin
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.
June 29th, 2006, 01:06 PM
Are you electing to not show empty comments (ratings) in the admin options? ;)
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 (http://www.iloco.org/photopost/index.php)
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.
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.....:)
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.
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.
June 30th, 2006, 02:59 PM
Ok I am very confused. When is a comment a rating or a rating a comment when I have ratings turned off.
So to see comments as comments what do I set and to what for this to show as in statisics so I see the correct amount of comments..
I deleted all comments from users to get this to set so In all members comments I see the same as in statisics.
Guess I need to know what and where to set to see the correct comments in All members as in statisics.
Sorry for being such a pain Chuck but it just dont add up how I seee in all my categorys the total like at the time the pic was grabbed as being 15 and the statisics being 15 when how I see it the same should be showing in all members as 15 and not 12.
I can run a scan data base option and then All members shows correct as 15 but my questions is why do I have to run a scan data base option for this to correct the number from 12 to 15.
How do I set my settings to show in All members the same number of comments as in statisics or the total from all categorys when viewing home page.
I am wondering now if I deleted all of the comments for all users when I may have not needed to to get this to sync right. Very confused.
June 30th, 2006, 03:02 PM
This is what I see.
You say you have say 66 comments in a category yet you can only physically count 45. Now say with the setting that I noted set to no that means 21 comments are hidden cause they are simply empty. A rating is a comment. At one time it was evident you allowed ratings and this is why you are having trouble adding things up. If you set the setting I noted to yes then you would see an empty comment with just a rating and you should be able to count 66 ;)
Does that make sense to you yet?
June 30th, 2006, 03:17 PM
Chuck I am not really sure I understand but think I parcely do. You are saing a rating is same as a comment if I understand you correctly.
Now I dont want members to see ratings and be able to use them so I have
3 ratings I can set in Show Photo Options.
1: Display ratings that have no comments attached.
2: Allow members to rate photos.
3: Display quickratings under photos.
To be able to see all the comments as your 66 Which of these do I set to yes. All are set to No now.
Allow members to rate photos I am sure needs to be No since I dont want members to rate photos.
At one time when I first installed photopost I did allow ratings untill we had problems with members not liking the ratings they would get. I turned it off because of that.
Yesterday I cleaned all comments out of my data base for photopost to see if I could get the comments to sync as I am trying to do but my all members dont sync as in statisics. If its a ratings setting that needs to be turned on Id like to know which one. I dont have any ratings unless they are in myd ata base from the few short weeks I had it on. I will check in phpmyadmin and see if I see ratings anywhere and if so will empty them. I purged all old photos that were 365 days or older so that should took care of when I had used ratings.
June 30th, 2006, 04:09 PM
If you cleared all comments things should match fine. Your confusing me here but from what you have posted what I said should have been where your confusion was at.
June 30th, 2006, 04:20 PM
I looked in phpmyadmin and can see no ratings at all with any pictures. All are 0.
I deleted all comments to get this to work as I thought it should and now I am very confused.
With me having only 30 commets in my gallery I can delete those again if necessary to get this to work as I would like it to be.
Can this be done if I remove all commetns and make the correct settings in admin cpanel.
With no ratings showing in phpmyadmin I am very confused how photopost is now seeing them after I removed all the old images that had the ratings when I first installed photopost. Isnt there a way to clear the data base so it will show as I want it to show.
Sorry for being such a dumb skull but it seems so simple but is so confusing to me.
I can send you admin and access to my photopost cpanel or to My phpmyadmin and data base if this would help.
June 30th, 2006, 04:30 PM
I am not talking about now as I was referring to before when you where getting confused on counts. The reason was you had ratings and had the setting I noted set to no which means it hide comments that are empty. This discussion was essentially rendered mute the minute you deleted all comments.
June 30th, 2006, 05:38 PM
This discussion was essentially rendered mute the minute you deleted all comments.
Yes that was my impression that when I deleted all comments that the comments in all members would automaticly show as those in statisics but they will not.
Only option I have to make them view the same is run Scan Data Base the option "Check here to recalculate photos/posts numbers and check children" and then the comments show as in statistics. When I refresh windows I would assume the comments would be same as in statistics if someone posted a new comment. This is not happening........?
Seems we not connecting with our thoughts so will just use the scan data base object to make comments correct in all members as it is in statistics.
I thought this would been simple to set but I was wrong on this one. :)
Thanks Chuck for taking the time to help me. :)
Could this be a thing related to cache not refresing as it should. I still think its a bug with the software or maybe something changed in the 5.31 files that no one else has noticed yet or will not look at this as I have. :)
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.