BuddyPress.org

Hi @textrat

I’m really sorry to read about this issue. I’ve run some tests to try to reproduce. This is the results of it:

1/ “Confirm User Registration” doesn’t seem to interfere. The plugin is adding a user_meta “authentication” set to 1 for each users. When a user logs in it checks if this user meta is there and if so allow the log in, else display a message saying the account is not authenticated.
2/ The only way i’ve managed to have a user_status set to 0 and the activation_key still in usermeta for this user was to set the user_status to 0 myself directly in the database (testing config WP 3.8.3, BP 1.9.2 > 2.0 and Confirm User Registration)
3/ From the Manage Signups screen if i activate this kind of user (user_status 0 and activation_key not empty), i have the message that user is already activated, but the user is no more in the list of pending accounts and is now available in the users list with the default role
4/ About the 152 pre-existing, the only way i’ve managed to reproduce a similar problem was to restart all again and to delete the value of activation_key meta in the database. eg : activation_key > “” : The meta is there but empty. In this case, the user keeps on being in pending after trying to activate it.

I think clearing the “pending bit” can be achieve by updating the “active” field to 1 into the signups table for the 152 pre-existing users. But, before doing so, you should check the ‘activation_key’ meta values for some of the 152 users to see if the value is empty. This way it could confirm my point 4.
Then you should check for the corresponding user_status to be sure it is not set to 2.

Whatever you do, i advise you to backup your database before.

@notpoppy

In this reply https://buddypress.org/support/topic/lost-admin-access-after-2-o-update/page/2/#post-181524, @boonebgorges explained how to fix it :

i’m re-pasting the url to the gist here: https://gist.github.com/boonebgorges/4ee64723ba75caa3c7e1

I see from the database two values for my administrator account have been changed as follows. They were originally:

wp_user_level: 10
wp_capabilities: a:2:{s:13:”administrator”;b:1;s:13:”bbp_keymaster”;b:1;}

And are now:

wp_user_level: 0
wp_capabilities: a:1:{s:15:”bbp_participant”;b:1;}

I changed both these back to their original values but I’m still getting the “You do not have sufficient permissions to access this page” error when I try to access an admin page.

@imath Ah the script from @boonebgorges seems to have worked, thanks!

Hi! I have the same problem with admin rights. @boonebgorges ‘s fix helped me a lot. But I have another problem. This fix can’t help users which get a subscriber’s role after registration. I set an author role for all new members of my site in wordpress settings. But it had no effect.

@livsy

Just tested in WP 3.9/ BuddyPress 2.0, the role set for a new user is the one that is defined in the WordPress setting (wp-admin/options-general) > New User Default Role dropdown field.

@livsy if you try to register a new account, this account should have the role you defined in WordPress settings.

I’m very curious about what happened during upgrade. If it were possible i’d really like to view the users, usermeta and signups tables!

Can you see the users with no role in your users list ?
If so, you can batch create roles for these users using the “change role to” select box on top of the users list.

i’m going to test BP Disable Activation Reloaded to see if the problem was linked to this plugin.

@livsy

I registered a new user by myself a minute ago. And I saw in his profile – he has no role for my site

This shouldn’t happen.

What is your config ? The upgrade problem concerns a non multisite WordPress. Is it your config ?

“Viewing the sql tables” means that you’ll need to export it using PhpMyAdmin for instance and send it to me.

By the way, i’ve tested BP Disable Activation Reloaded and it’s not the cause of the problem. It’s “someone” else.

I am using a non multisite WordPress.