Solved: 6 Years, 6 Months, 2 Weeks ago Mass Activate Users
#1
Solved: 6 Years, 6 Months, 2 Weeks ago
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?
Reply
#2
Solved: 6 Years, 6 Months, 2 Weeks ago
You can run this sql query from phpmyadmin

UPDATE `mybb_users` SET `usergroup` = '2' WHERE `usergroup` = '5'
We can't help everyone, but everyone can help someone - Ronald Reagan
Did you know? Your question has already been answered. But you haven't searched it yet.
Don’t  Forget to “Mark as Solved” after the fix
Reply
#3
Solved: 6 Years, 6 Months, 2 Weeks ago
thanks for your response it said 358 rows affected but no change to the amount of users awaiting activation?
Reply
#4
Solved: 6 Years, 6 Months, 2 Weeks ago
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...
We can't help everyone, but everyone can help someone - Ronald Reagan
Did you know? Your question has already been answered. But you haven't searched it yet.
Don’t  Forget to “Mark as Solved” after the fix
Reply
#5
Solved: 6 Years, 6 Months, 2 Weeks ago
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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)