XF 1.2 Mass usergroup re-assignment

[Tyrone Chicken]

So something went wrong with my IPB 3.4>xF 1.2 and vB 4.2>xF 1.2 conversion and now a few thousand users are administrators.

Anyone know of a way I could change everyone in that group to a regular member? Probably a way to do it easily with a SQL query but I'm not experienced enough to figure out how to go about it.

edit: fixed.

 

[Mike]

I know your edit says fixed, but assuming they're just in the admin group (rather than actually being admins), you can likely use the batch user update to sort that out.