Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product

Ready to contribute?

Amazing! Sign our contributors' agreement and then join us on GitHub.

Vanilla 2.2.1 is now available.
Please upgrade to 2.2 here. The 2.0 and 2.1 branches are no longer being updated.

[Documentation] repair permissions feature request

I would like to request a "repair permissions" button. When setting up my forums from phpbb I did not have my default roles set so I had a lot of users created without a role. There doesn't seem to be any way to locate all users with a blank role or edit multiple users at once.

My idea is that you could click this button and then assign a role to any user that has no role defined or even change all users of one role to another.

Comments

  • ToddTodd Chief Product Officer Vanilla Staff

    Good idea. In the meantime try the following SQL:

    insert ignore GDN_UserRole (UserID, RoleID)
    select u.UserID, XXX
    from GDN_User u
    left join GDN_UserRole ur
      on u.UserID = ur.UserID
    where ur.UserID is null;
    

    Replace XXX with the RoleID of the role you want to use.

  • I tried this code but it doesn't work for me.

    Todd said:
    Good idea. In the meantime try the following SQL:

    insert ignore GDN_UserRole (UserID, RoleID)
    select u.UserID, XXX
    from GDN_User u
    left join GDN_UserRole ur
      on u.UserID = ur.UserID
    where ur.UserID is null;
    

    Replace XXX with the RoleID of the role you want to use.

  • peregrineperegrine MVP
    edited May 2012

    "Doesn't work" doesn't help somebody solve your problem - you need to give a wee bit more of an explanation.

    remove the ignore? and probably 8 is the roleid you want for members

    Do you see any nulls in your UserRole table?

    if yes, after you run the code

    do you still see nulls?

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

    UnderDog
Sign In or Register to comment.