I need to move 200 members from the pending group to another group.
Is this possible to do easily without going into each individual profile
Peter
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
May 10, 2011 8:26am
Subscribe [3]#1 / May 10, 2011 8:26am
I need to move 200 members from the pending group to another group.
Is this possible to do easily without going into each individual profile
Peter
#2 / May 10, 2011 3:26pm
Hi Peter,
You could run a bit of SQL, for example:
UPDATE `exp_members` SET `group_id` = 2 WHERE `group_id` = 1Always backup your database before manually modifying it. Does that help?
#3 / May 10, 2011 3:28pm
sort of. would I run this in phpmyadmin?
in phpmyadmin do I add that query:
Run SQL query/queries on database ee_databasename:
OR
SQL query on database ee_databasename:
Which tab? SQL or QUERY?
#4 / May 10, 2011 4:43pm
UPDATE: Run SQL query/queries did the trick in phpmyadmin!
What a time saver! thanks
#5 / May 10, 2011 6:30pm
Glad Brandon was able to help. Don’t hesitate to post again as needed.