WordPress MU

I have a backup but this was rather disastrous -

In trying to figure out why I can't create a blog named "blog", I decided to deactivate the main blog in the root directory. After hitting "deactivate" I can no longer access any of the blogs, all of which used the same user, for the following reason:

This user has elected to delete their account and the content is no longer available.

I looked at the wp_signups table and the user for the blog is deleted although all the posts remain as does the user entry in the wp_registration_log. I'm trying to figure out why deactivating blog #1 did this and what to do to reactivate the blog.

Solution to recovering your blog:

wp_blogsSETdeleted= '0' WHEREwp_blogs.blog_id` =1 LIMIT 1 ;

or just use phpmyadmin to set the deactivated blog to "0" in the "deleted" column.

While the error message says "deleted" it actually means "deactivated" and unfortunately deactivating the first blog (not set as primary) deactivated every blog.

I highly suggest that this message be changed or modified. Could give someone a heart attack. I'm still not sure why it happened. Hope this helps someone.

I highly suggest that it be made impossible or extremely difficult to deactivate blog #1.

I highly suggest that too!!!
Deactivate should not mean delete and there should be a "make active again" option....

Um, actually I could have sworn that there was a step that prevented you from deleting the main blog if subblogs still existed:

http://trac.mu.wordpress.org/ticket/637

Thank you for this post. I just had a heart attack when I deactivated the original blog.

Oh my gosh, you just saved my skin. Never messed with phpmyadmin, but figured it out in a hurry. Thanks!

Jesus, I almost had a heart attack on this one. What the... Thought I had lost my entire blog. Thanks thelaw, you saved me :)