Number of comments doesn't update!

[vAx]

After deleting some of the comments from a story "Admin>>Comment Management" number of comments show the same as before deleting them. Update DB is not working properly...

[savant]

thanks for reporting that

[GDFH]

Same problem. Yesterday i had 7 comments, and after that, comments doesn't update.

[betagirl]

Ditto. Comments not updating - they seem to be randomly changing for stories in fact - sometimes showing a number (usually wrong) sometimes it appears there are no comments, when in fact, there are. Any progress on this? Site going live - beta testers are *all* complaining about it.

[dollars5]

I think savant is working at it and you should expect a fix shortly.

[abcdefgary]

wasn't this fixed already?

SourceForge.net Repository - [pligg] Revision 1179

[dollars5]

hmm, I just missed the time mentioned - thanks gary for noting it fixed - usually when a issue is fixed the moderators will mark fixed - but this thread has gone unnoticed. Thanks again for noting it. updating the status of the thread too.

[betagirl]

This fix seemed to work for a couple of hours - then it was back to the old random incorrect/not updating. Any clue as to why it would revert? I updated the files. ? It's a pretty significant problem for us right now.

[AshDigg]

Try putting the attached file into your root pligg folder (the one with index.php) and run it. It should recalculate all the comment counts and they should then stay accurate.

[betagirl]

Originally Posted by AshDigg

Try putting the attached file into your root pligg folder (the one with index.php) and run it. It should recalculate all the comment counts and they should then stay accurate.

Hi Ash - I'm afraid that didn't do it. I can't figure out what's going on, but I *really* need to get it sorted out. We've only been up for 2 days and we've already got 512 users, 207 links, and 498 comments. And this is a crowd that pays attention. I'm trying to stomp out several bugs at the moment, but this one is the priority.

I checked the database tables, and only 33 stories (in pligg_links) show any comments at all. Why is the relationship between the tables not being maintained? Is there a query somewhere that resets the values when a certain action is performend? I assume the problem is the pligg_comments in the pligg_links table, as it is the one showing mostly 0s where there should be nums.

Thanks for continuing to help me get this working -