Mass removing secondary groups

[m1ne]

Nearly every member has 'registered' as their secondary user group, I'd like to remove this for all of them.
However, a lot of users also have a different group as their secondary, and I don't want to remove those.
Is there an sql query for this?

 

[Paul B]

You can't use queries to change user groups as the permission sets won't be updated.

From what you've said, your permissions don't appear to be set up as designed: http://xenforo.com/community/resources/implementing-permissions-across-multiple-user-groups.358/

Note that if you delete one of the non-default user groups, any members will fall back to the Registered user group.

 

[m1ne]

Thing is, I'm using an addon which disallows signature editing until 5 posts and restricts images and lines, this is defined in options though, not permissions. So if I set it to affect registered users, it affects everyone.

 

[m1ne]

Alright, I'll do it your way. Which SQL query will place all users in registered group as primary?

 

[Paul B]

You can't use queries to change user groups as the permission sets won't be updated.

Note that if you delete one of the non-default user groups, any members will fall back to the Registered user group.