Comment Count Update

[Simon]

I think there is a bug with the way the link_comments field is updated in the links table. I have several stories where the comment count has been reset when a comment has been added (example - 2 comments already there, 3rd added, count now at 1).

This is will pligg b9.5, shared host running on linux.

The update seems to happen in libs/comment.php, at the line $link->adjust_comment(1). For now (after a couple of attempts) I've let it re-calculate the comment count everytime a new comment is posted:

$comment_count = $db->get_var("SELECT count(*) FROM " . table_comments . " WHERE comment_link_id='$comment_link'");
$sql = "UPDATE " . table_links . " SET link_comments='$comment_count' WHERE link_id='$comment_link'";
$db->query($sql);

[dollars5]

I think you refer to this and is alredy mentioned at http://forums.pligg.com/showpost.php...01&postcount=4

[Simon]

It's something more than that. I made that change, along with a re-calculation of the comment number when posting a new comment to minimise errors. However, I just posted a new comment in a pligg installation, and when I returned to the front page, several other stories (random seemingly) had their comment count reset to zero. Very strange...

The other bug is that when a story gets published, its comment count is also reset to zero. Does anyone know where resets like this could be occuring?

[dollars5]

This is very strange - I will comment on it after I could confirm on this issue. Is that this happens only on 9.5 or older ones too?

[DarrenS]

This seems to be happening to me, as well. I've just installed the latest Pligg and have my first thread to reach three comments. I posted the third comment and revisited the home page, only to notice that the comment count is at 1.

I'll continue watching to see if all stories with comments behave this way ... And is it only triggered by comment #3?