[Documentation] repair permissions feature request

OrganicBytes

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.

Todd

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.

fabportal

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.

peregrine

"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?