BuddyPress.org

If you’re like me, and did not do a DB backup because you thought the upgrade would be smooth sailing (d’oh! thankfully this was only on a test install!), do the following:

1. Revert the $blog_ids variable in the bp_blogs_record_existing_blogs() function in bp-blogs.php back to this:
$blog_ids = $wpdb->get_col( $wpdb->prepare( "SELECT blog_id FROM {$wpdb->base_prefix}blogs WHERE mature = 0 AND spam = 0 AND deleted = 0" ) );

2. Then put this line in your theme’s functions.php:
bp_blogs_record_existing_blogs();

3. Go to your BP’s blogs directory and see your blogs repopulate.

4. Once you’ve verified that your blogs are back, remove the bp_blogs_record_existing_blogs() function line from your theme’s functions.php