Hello.
1) Create discussion in group
2) User1 post reply1 to discussion (7 month ago)
3) User2 post reply2 to discussion (6 month ago)
4) User3 post reply3 to discussion (5 month ago)
5) User4 post photo (or text-post) to stream (3 week ago)
6) User5 post photo (or text-post) to stream (2 week ago)
7) User6 post reply4 to discussion (1 week ago)

Result: Stream display items in this wrong order:
7) User6 post reply4 to discussion (1 week ago)
4) User3 post reply3 to discussion (5 month ago) - it should not be there
3) User2 post reply2 to discussion (6 month ago) - it should not be there
2) User1 post reply1 to discussion (7 month ago) - it should not be there
6) User5 post photo (or text-post) to stream (2 week ago) - it should be upper
5) User4 post photo (or text-post) to stream (3 week ago) - it should be upper

I mean, when user posted new reply to Discussion, all other activity about this discussion was moved to top.

P.S: I'm not sure is it matter: "Bump option" is turned on in backend.
P.P.S: Link to problem group example is below.
Thanks.

Hi,

Wait, I dont really understand, please give me more information with the screenshoots.

thank you!

Hi. Please scroll down this page: crimson-land.ru/groups/viewgroup/4-pomoshch-po-sajtu

1 week ago / everything is OK:

Hi,

i tried replicate this on my local and works fine, i dont see anything weird on latest clear installation..

Seems this issue caused by your database issue.. please you also try on latest installation.

thank you!

Hi. Did you turned on "Order by last comment" option in backend?

Is far is I understand it cause problem: if user just reply to discussion, it will bump all old activity about old replys in this discussion.

If I temporary turn off "Order by last comment" option, everything become normal.

Yes, I turn it on..weird because each discussion stream has different streamId and has different time

Hello. I just deleted this discussion (which had lsat reply 1 week ago) because we don't need it and for test.

As result in this group: crimson-land.ru/groups/viewgroup/4-pomoshch-po-sajtu
Was bumped another discussion crimson-land.ru/groups/viewdiscussion/55...dlya-sajta?groupid=4
whitch has latest reply on 2 years ago :O

And more fresh activity (1 week ago) is below it.
Thaks.

Hi,

while I am debugging this issue, in another hand can you try this issue on new group on your site, please?

thank you!

Hi,

Please try open this file components/com_community/models/activities.php, find this code

? ('a.' . $db->quoteName('updated_at') . ' DESC, a.' . $db->quoteName('id') . ' DESC')

? ('a.' . $db->quoteName('updated_at') . ' DESC')

Hi. This edition changed something but didn't fixed it.
If scroll down this page: crimson-land.ru/groups/viewgroup/4-pomoshch-po-sajtu
I can see that:
1) 2 weeks ago:

Hi,

I see your site is very active there, I need to debug there and it will show some query, is that fine if I do debug?

thank you!

Hi. Yes, you can feel free to do anything you want :) I suppose it temporary? Thanks.

Hi,

This issue is related with old database record, to fix it you need update the database record manually.. I am still waiting our lead dev to provide you the mysql code.

thank you!

Hi,

Here is the query to fix the issue

UPDATE `#__community_activities` SET `updated_at` = '2013-11-08 00:00:00' WHERE `#__community_activities`.`updated_at` = '0000-00-00 00:00:00'