Hello there,

I cant access to your backend and frontend. Can you solve this issues first and give us some screenshot or attachments for better understanding of your issues and easier for us to solve those issue. Thanks for understanding.

Regards

Hi Abdul, I see no indication of a server issue, it is strange you could not see it. Can you try again please?

Hey there,

I am really sorry for the delay of this reply as it is a public holiday for us here.

I just tried to access in your site, it seems like loading your site until timeout, you can refer on my attached screenshot below.

[EDITED]
For some reason, I can access now, I've checked in your database, the reason why it show a few stream when you view group is because a lot of `joined` group stream data, I believe you already turn off this `Joined` group stream setting from backend, so these `JOined`group stream will not appear on your group page.

SELECT * FROM `iph86_social_stream` where `cluster_id` = 9;

Thanks, so the large amount of "user has joined this group" entries in the database is causing this to happen? Should those entries be ignored as they are not posts to the group.. This would seem to be a bug.

How can I safely remove those from the database, can I just delete those rows from the mysql without causing an issue ?

Hey Dennis,

I am sorry for the delay of this reply,

Actually that is not a bug, just that `joined` is actually is a stream in group.

You can run this following sql query to delete all the `joined` group stream from stream table in your database, and it shouldn't causing any issue on your site.

delete from `#__social_stream` WHERE `verb`='join' and `context_type`='groups' and `cluster_type`='group';

It would be best if you can backup your site before you execute this delete joined stream from your database.

Thank you for your assistance again. I would like to respectfully debate this being a bug. My reasons for this are:

If I disable: "Easysocial/applications/user:group/Show Join Group Stream"

The event is still recorded in the database AND has an effect of the display of stream items for the group. resulting in users thinking posts are missing, even if they have been commented on recently. By manually deleting these entries in the database, or by the backend stream activity the group operates normally.

Perhaps it could be an enhancement to the "Show Join Group Stream" disabled, by:

not writing the events into the database AND/OR
the SQL query ignoring those events.


example ( i don't know the exact query to select stream items)

select from `#__social_stream` WHERE NOT `verb`='join' and `context_type`='groups' and `cluster_type`='group';

Does that make sense how I am explaining ?

Thanks!

Thank for took your time to explain to us about this, we will see what we can do in the future version.

Do you mean the event page also still have the `joined` stream? And you would like to delete group and event joined stream as well?

Hey Arlex.

What I mean is: if "Show Join Group Stream" is disabled, easysocial should ignore those database entries instead of hiding them. currently, they are counted as stream items and cause other items not to display when there are many of them.

For example, when I opened registrations to my website i had 25 users testing.
300 users joined and register in one day. New users are automatically joined to a group.. when users viewed the group, all the test albums/streams were "missing" since they were posted before the users joined. the hidden "User joined" had a negative effect on how the group stream items.


I suggest if "show join group stream" is disabled:
1 - do not record the stream into the database OR
2 - ignore the stream item in the SQL query, not hide it from view. (better)

Is that more clear?


To replicate.

- Create a new test group as UserA or Administrator

- Settings -> Streams -> "Number of items to load" = 5 Items (to make it easier to see)

- applications / groups:groups:Stream / "Show Join Group Stream" = No

- Create a "share what's new" update as UserA or Administrator - verify it is visible

- Join group as UserB, UserC, UserD, UserE, UserF.
do not leave, items will be deleted (posts should not be removed from a group if a user leaves)

- refresh the Group view as UserA.

There are no activities here yet.

- backend - applications / groups:groups:stream / "Show Join Group Stream" = Yes
- Refresh the Group view as UserA
All the activities now display


Please let me know if you see the same results.


Thank you !

This patch has helped as a workaround, thank you

Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.