Blogs Directory SQL error on WP 3.0 w/ MS

[DJPaul]

This is because wp_1_posts doesn't exist on a new MS in 3.0, WordPress just refers it to wp_posts:

WordPress database error Table 'wordpress.wp_1_posts' doesn't exist for query SELECT post_title, guid FROM wp_1_posts WHERE post_status = 'publish' AND post_type = 'post' AND id != 1 ORDER BY id DESC LIMIT 1 made by require, require_once, do_action, call_user_func_array, bp_core_do_catch_uri, load_template, require_once, locate_template, load_template, require_once, bp_has_blogs, BP_Blogs_Template->bp_blogs_template, bp_blogs_get_blogs, BP_Blogs_Blog->get, BP_Blogs_Blog->get_blog_extras

[DJPaul]

Try this for size

[DJPaul]

this one works better

[johnjamesjacoby]

(In [3139]) Fixes #2543 props paulgibbs