MyBB Community Forums
Mass Activate Users - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: Mass Activate Users (/thread-165336.html)



Mass Activate Users - MRxBIGxSTUFF - 2015-01-08

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?


RE: Mass Activate Users - mmadhankumar - 2015-01-08

You can run this sql query from phpmyadmin

UPDATE `mybb_users` SET `usergroup` = '2' WHERE `usergroup` = '5'



RE: Mass Activate Users - MRxBIGxSTUFF - 2015-01-08

thanks for your response it said 358 rows affected but no change to the amount of users awaiting activation?


RE: Mass Activate Users - mmadhankumar - 2015-01-08

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...


RE: Mass Activate Users - MRxBIGxSTUFF - 2015-01-08

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