1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'XenForo Questions and Support' started by Biarritz64, Nov 8, 2013.

  1. Biarritz64

    Biarritz64 Active Member

    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
  2. Liam W

    Liam W Well-Known Member

    Can't you use the batch user update system?


    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.
  3. Brogan

    Brogan XenForo Moderator Staff Member

    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.
    HWS likes this.
  4. Biarritz64

    Biarritz64 Active Member

    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
  5. Liam W

    Liam W Well-Known Member

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

    Registered User

    I believe that's it.
  6. Brogan

    Brogan XenForo Moderator Staff Member

  7. Biarritz64

    Biarritz64 Active Member

    You are very kind,

    thank you for your answer

Share This Page