Change user role en masse

tyskkvinna

I have successfully ported over my entire user base but now nobody can fully sign in. If I give them a role -- they have none -- they can sign in. I've been trying to do this via the database for a little bit now and I'm not having much luck. Is there a way I can do this-- on the front end or the back end -- without having to do each user singly? I have thousands of users so that would just not work..

thanks!

peregrine

look in the user role table and add userid and roleid in sqladmin.

Be careful: if the users have null roles or the wrong roles and all the users are in the userrole table you could just do something like this, that changes users roles who are not 2 to 8 with. to make it work remove the limit at the end. backup the userrole table first. Take note of the userid 1 and its role - (you need that to remain the same this is your root admin).

UPDATE `vanilla`.`GDN_UserRole` SET `RoleID` = '8' WHERE `GDN_UserRole`.`RoleID` <> '2'  Limit 1

tyskkvinna

Great! Thanks.

UnderDog

tyskkvinna said: I have successfully ported over my entire user base but now nobody can fully sign in.

You ported them over manually, correct? The reason I ask is, if you did do it with the Porter Plugin, then not inserting the User Roles is a bug :-S. With Manual conversion, it's logic that the user roles didn't come over and you can apply peregrine's solution if the userrole table is filled with (lots of) users :-)

tyskkvinna

No.. I am porting from BBPress 2.0 and the best I can tell I have to do the whole shebang by hand. I am transitioning the users and the entire forum manually (!) but so far so good. This solution worked great. I gave everybody a "member" role and then went back in an edited the appropriate people to admin/system/mod roles. Took about 5 minutes once I was on the right track.

UnderDog

tyskkvinna said: No.. I am porting from BBPress 2.0 and the best I can tell I have to do the whole shebang by hand.

Figured that, since the porter plugin can only convert from BBPress 1.x

tyskkvinna

I can see why there is no converter for BBPress 2.0 yet, as well... it's a pain :D