Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Group mixes (shuffle) Items in stream

1 year 10 months ago
Licenses:
JomSocial Active

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.


Sorry for my English
1 year 10 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

Hi,

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

thank you!

1 year 10 months ago
Licenses:
JomSocial Active

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

1 week ago / everything is OK:



2 weeks ago / everything is OK. But after this discussion reply problem begin (not sure is it matter:also this discussion was "closed").


2 months ago (the same discussion). Why does it there?


2 months ago (the same discussion). Why does it there?


3 months ago (the same discussion). Why does it there?


Scroll down. Than "7 days ago". Why this activity is under "3 months ago"?


Scroll down.: 7 days ago, 2 weeks ago...

All activity I marked "Why does it there?" (Discussion reply type) was moved up because "Order by last comment" option it ON. Seems ALL replyes was bumped up.
I believe only latest activity (Discussion reply) should appear on top (older reply should not bump up).

Thanks.


Sorry for my English
1 year 10 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

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!

1 year 10 months ago
Licenses:
JomSocial Active

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.


Sorry for my English
1 year 10 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

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

1 year 10 months ago
Licenses:
JomSocial Active

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.


Sorry for my English
Attachments:
1 year 10 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

Hi,

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

thank you!

1 year 10 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

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')
replace to
? ('a.' . $db->quoteName('updated_at') . ' DESC')

I hope it will fix the issue..

1 year 10 months ago
Licenses:
JomSocial Active

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:



2) after that I see FEW (4) activity about replys in discussion. Discussion was created 3 yers ago and last reply is 3 yers ago:


3) after it I see activity "2 weeks ago":


Thanks.


Sorry for my English
Attachments:
1 year 10 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

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!

1 year 10 months ago
Licenses:
JomSocial Active

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


Sorry for my English
1 year 10 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

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!

1 year 10 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

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'

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW