There’s a new BuddyPress plugin available that will allow you to manually activate users through your dashboard who have not activated themselves. Sometimes this happens because the activation link goes to the user’s spam folder or an email address that they don’t normally use. Add this to your site by installing the WP Activate Users plugin. You’ll have a new menu in your admin area that will allow you to activate the users directly through the dashboard without having to touch the database. This is a great option if you don’t want to disable the activation email but are worried about some of the emails not arriving to the user’s inbox.