@livsy
From what i see, the latest user you registered “Leon123” is an author. Have you changed his role manually ? else the signup process is ok.
174 users seems to be problematic
I wonder who is adding ‘signup_ip’ in the usermeta, have you reactivated the plugins ? Or it maybe the theme you are using ? In options i see that “buddycorp” is adding a lot of options and some are related to signups, is it your theme ?
Otherwise, i think i would test this :
0/ make a back up of the database.
1/ It looks like you deactivated BuddyPress and rollback to a previous version of the database several time because in the signups table, there were signups in “8plicate”
So before batch activate or activate, you’ll surely need to run this query :
DELETE FROM wp_signups WHERE signup_id > 173
2/ try with one user (for example “sert” ID = 2006) to edit his user_status to 2 and then go into the BuddyPress signups management screen and try to activate him. Once done check his role.
3/ If everything went fine, i think, i’ll update the user status of the 174 users to 2, then form the signups management screen batch activate the 174 users, i think it’s best to do it step by step, you can increase the number of signups displayed from the screen options, but i advise you not to set it to 174, maybe 40.
to update the 174 user status, you can run this query in PhpMyAdmin for example :
UPDATE wp_users SET user_status = 2 WHERE ID NOT IN ( SELECT user_id FROM wp_usermeta WHERE meta_key = "wp_capabilities" );
For your info activating the signup for the “admin” user won’t work as the activation key is empty, so you can just delete it for this user.
I wonder if it’s not simpler for you to batch edit the user roles.
