I have the same problem – in my case the blog is not missing from the `wp_bp_user_blogs_blogmeta` table, but it IS missing from the wp_bp_user_blogs table.
I’m having trouble figuring out how to put it in. I can find the user_id and the blog_id but what’s the id itself? Can I just create an id?
