MyBB Community Forums › 1.8 Support › General Support v
How do i move all users from "awaiting activation" to "members"

Thread Closed 
Threaded Mode
Not Solved How do i move all users from "awaiting activation" to "members"
bumstead Offline
Posts: 8
Threads: 4
Joined: Sep 2020
Reputation: 0
#1
Not Solved 2020-09-22, 11:11 AM
I want to move all users in one usergroup to another usergroup. How can I do this? I cant find any option for this.
Find
Crazycat Offline
Posts: 2,557
Threads: 100
Joined: Feb 2007
Reputation: 304
#2
Not Solved 2020-09-22, 11:24 AM
In ACP, use the "find user" tool to find all users of the initial group, then click "Users (all users)" in the header of the results.
At the end of the page (Inline User Moderation), choose "Change user' usergroup" and you'll be redirected to a page where you can select the new usergroup.
Validate and all is done.
Tchat en français
Do not ask me help through PM or Discord

Website Find
nixer55 Offline
Posts: 699
Threads: 14
Joined: Oct 2019
Reputation: 39
#3
Not Solved 2020-09-22, 12:00 PM
(2020-09-22, 11:24 AM)Crazycat Wrote: In ACP, use the "find user" tool to find all users of the initial group, then click "Users (all users)" in the header of the results.
At the end of the page (Inline User Moderation), choose "Change user' usergroup" and you'll be redirected to a page where you can select the new usergroup.
Validate and all is done.

Great tip.  Thanks.

cheers...
Website Find
bumstead Offline
Posts: 8
Threads: 4
Joined: Sep 2020
Reputation: 0
#4
Not Solved 2020-09-22, 04:23 PM
i have over 50k users awaiting activation, this needs to be done page by page. Is there a way to move all at once???
Find
Crazycat Offline
Posts: 2,557
Threads: 100
Joined: Feb 2007
Reputation: 304
#5
Not Solved 2020-09-22, 04:30 PM
I think you can do it using MySQL:
update mybb_users set usergroup=<GID_DESTINATION> where usergroup=<GID_SOURCE>
Replace <GID_DESTINATION> with the destination group id and <GID_SOURCE> with the source group id.

Think to rebuild the caches after this operation
Tchat en français
Do not ask me help through PM or Discord

Website Find
bumstead Offline
Posts: 8
Threads: 4
Joined: Sep 2020
Reputation: 0
#6
Not Solved 2020-09-22, 05:13 PM
How do I do it in the mysql? I am not very used to this and worried to do something wrong.
Find
Crazycat Offline
Posts: 2,557
Threads: 100
Joined: Feb 2007
Reputation: 304
#7
Not Solved 2020-09-22, 05:45 PM
I don't really understand your question.
Use PHPMyAdmin and go in your MyBB database, choose the "SQL" tab and type the query I gave in previous post.
Just take care of "mybb_users" which is the default tablename, if you choosed another prefix it could be "bb_users" or "whateveryouput_users".

BTW, save your database (ACP > Tools & maintenance > Backup) before doing anything.
Tchat en français
Do not ask me help through PM or Discord

Website Find
nixer55 Offline
Posts: 699
Threads: 14
Joined: Oct 2019
Reputation: 39
#8
Not Solved 2020-09-22, 11:00 PM (This post was last modified: 2020-09-22, 11:09 PM by nixer55. Edited 1 time in total. Edit Reason: spelling - lol )
(2020-09-22, 05:13 PM)bumstead Wrote: How do I do it in the mysql? I am not very used to this and worried to do something wrong.

You asked this in another thread - and received the same answer for a bulk change:

https://community.mybb.com/thread-229394.html

Not sure what else can be explained?

cheers...
Website Find
Thread Closed 


Forum Jump:


Users browsing this thread: 1 Guest(s)