Hello, we have more then 50 groups and we would like to approve groups members at once, i guess there is no admin panel option to do it, i thinked about sql queries, what column should we update to accept all groups join requests and invites ?
Hello Jan!,
You may want to take a look on this table #_social_clusters_nodes. Pending users are having a value of 2 in state column. You need to change it to 1.
Your query will be something like this:
UPDATE #_social_clusters_nodes SET state='1' WHERE cluster_id='15' AND type='user';
// cluster_id is the group id.