I've set up a WordPress site with 14 blogs.
The table prefix for the main blog is just "wp_" while for the other blogs it's "wp_" + the blog_id, starting at "2", so I have tables named "wp_posts", "wp_2_posts", "wp_3_posts" etc.
This causes a problem with a plugin whose task is to collect the latest post from every blog. The call to mysql is a foreach loop and looks like "wp_".$blogid."_posts" which obviously returns nothing for the main site.
Is there a way to set the table prefix for the main site to "wp_1_" in place of just "wp_"?