Not Solved How do i move all users from "awaiting activation" to "members"
#1
Not Solved
I want to move all users in one usergroup to another usergroup. How can I do this? I cant find any option for this.
#2
Not Solved
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

#3
Not Solved
(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...
#4
Not Solved
i have over 50k users awaiting activation, this needs to be done page by page. Is there a way to move all at once???
#5
Not Solved
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

#6
Not Solved
How do I do it in the mysql? I am not very used to this and worried to do something wrong.
#7
Not Solved
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

#8
Not Solved
(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...


Forum Jump:


Users browsing this thread: 1 Guest(s)