[wp-trac] [WordPress Trac] #12025: blog_id is set to 0 in wp_x_options?

[WordPress Trac]

#12025: blog_id is set to 0 in wp_x_options?
--------------------------+-------------------------------------------------
 Reporter:  wpmuguru      |       Owner:  ryan      
     Type:  defect (bug)  |      Status:  new       
 Priority:  normal        |   Milestone:  Unassigned
Component:  Database      |     Version:            
 Severity:  normal        |    Keywords:            
--------------------------+-------------------------------------------------
 MU Trac Ticket: http://trac.mu.wordpress.org/ticket/1182



 Hello there,

 I'm trying to extract the blogname and blog URL from the database for
 several blogs at the same time, but I'm having a problem setting up the
 join, because the blog_id field in the options tables for each individual
 blog is set to 0.

 For example:

 mysql> select * from wp_2_options where option_name="blogname";

 +-----------+---------+-------------+-----------------+----------+

 | option_id | blog_id | option_name | option_value | autoload |

 +-----------+---------+-------------+-----------------+----------+

 | 3 | 0 | blogname | Human Resources | yes |

 +-----------+---------+-------------+-----------------+----------+

 Shouldn't the blog_id be "2"?

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/12025>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software