Imported user application?

computercurtis

Hey,

Just imported a load of users from phpBB into Vanilla. I gave them all my "User" permissions. Now I have them all appearing in my "Applicants" administration section!

Any ideas? I even tried manually fiddling with it through phpMyAdmin but nothing worked.

peregrine

first check the role table and see what user roles correspond to what roleid's.

check you userrole table - the roleid column signifies the role assigned to each user (userid).

then you can set the userrole table to match the roles you want the user to correspond to.

e.g. if the Member role is 8 (general user) and the applicant role is "4"

you can set all applicant to members via a SQL statement in PhpMyAdmin

UPDATE GDN_UserRoleSETRoleID` = '8' WHERE RoleID =4;

at least this a way to do it in Vanilla 2.1.

you didn't mention your version of vanilla. It will probably be the same in all versions of vanilla.

Generally when asking a question you should mention your version of vanilla, so you don't get a flood of answers referring to a fix in a version you don't have.

computercurtis

Thanks, I have Vanilla 2.1 and this worked!