Hi Meagan,

There is definitely something wrong with the way osmembership integrates with EasySocial, as there are many duplicate members which you mentioned. I suspect when osmembership is inserting users as group members in EasySocial, they forgot to check whether the user already exist as a member.

I would suggest checking with the developers over at osmembership first to see what can be done here. Once that is done, you can provide us your database access so we can try to remove those duplicate members in the group.

Hello Raymond,

I'm working with Membership Pro to correct the issue.

For removing the duplicates, I looked at the database itself and I didn't see a field for groups. I’m not sure where you are storing the list of groups and the associated members.

What is the process for removing the members via database edits? (I'd rather not give out access to the database if possible.)

Hey Meagan,

I’m not sure where you are storing the list of groups and the associated members.

Member-cluster relationship is stored in this table: #__social_clusters_nodes

What is the process for removing the members via database edits?

You would have to carefully look through the #__social_clusters_nodes table.

uid represents the user id. So if you see 2 entries or more entries contain the same cluster_id AND uid, then you can remove the duplicate ones.

Remember to backup your site/database before modifying any tables as a precaution.