XF 1.2 How to set all members to registred group via Sql

Biarritz64

Active member
Hi,
is there a way, via sql to set all member to Registred group (exept the admin)?

Because, after import from phpbb i have so many members in so many differents user groups

Thank you
 
Hi,
is there a way, via sql to set all member to Registred group (exept the admin)?

Because, after import from phpbb i have so many members in so many differents user groups

Thank you

Can't you use the batch user update system?

admin.php?users/batch-update

Not in secondary groups: Administrator or whatever

Click search, confirm the found users are all fine with being moved

Set primary group: Registered users.

P.S All users, including admins, should have the registered users group as their primary really.
 
You can't do it via SQL due to the permission combinations - they won't be updated correctly.

Use the batch update users function in the ACP.
Or, delete the custom user groups and they will revert to the Registered group and then you can start again.
 
  • Like
Reactions: HWS
Thank you for fast answer,

it will be kind if you can you list me all user groups created by xenforo (not phpbb)

like this i will remove only old phpbb groups

xenForo won't allow you delete pre-created usergroups, but here they are anyway:

Administrator
Unconfirmed/Guest
Moderator
Registered User

I believe that's it.
 
Top Bottom