MyBB Community Forums

Full Version: Mass Activate Users
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Mybb Version: 1.8.3
Issue: Users Awaiting Activation

Hi after upgrading from 1.6 to 1.8.3 i have nearly 2000 users waiting to be activated somehow and would like to know if there is a way to activate the lot in one go instead of 20 at a time?
You can run this sql query from phpmyadmin

UPDATE `mybb_users` SET `usergroup` = '2' WHERE `usergroup` = '5'
thanks for your response it said 358 rows affected but no change to the amount of users awaiting activation?
did you check your Admin CP to see whether the members are activated... if you referring to the notice shown in the header of your forum, its a bug.. it will be fixed in the future release... for now you can remove {$awaitingusers} from your header template...
Yeah they are all still there in my admin panel, For now i will remove it from my header,

I ran the query again in phpadmin and it said 0 tables affected so i guess it must of done something just a bug now i suppose