Removing all members from a secondary group

[ItsJustMe]

Hi everyone,

I hope you can help me. I need to be able to empty all members from a secondary group at once (instead of access each member's profile and deselecting the group). I've looked everywhere, but can't figure out how to do this. Do you know how?

Thanks in advance for your help.

[Faqole]

32 minutes ago, ItsJustMe said:

Hi everyone,

I hope you can help me. I need to be able to empty all members from a secondary group at once (instead of access each member's profile and deselecting the group). I've looked everywhere, but can't figure out how to do this. Do you know how?

Thanks in advance for your help.

You can do it by running this sql query. However, it will be best to backup your database before you run it.

UPDATE core_members SET mgroup_others =  '';

 

[ItsJustMe]

Thank you for your reply. If it requires an SQL query, I'm assuming it's not a feature that's included in the current version. I wonder how difficult it would be to include a "remove all from this secondary group" option? There's a "prune members found" option, but I think that deletes them completely, and I don't want that. There's also a "move members found", but I'm not sure if that will remove them from all secondary groups, or just the specific one I need to empty, so I haven't tried it yet.

 

[ItsJustMe]

I just experimented with the "move members found" on a small secondary group. I moved them to "members" (even though they were already members of that group) and it removed them from the specific secondary group without removing them from other secondary groups. So it worked!