[wp-trac] [WordPress Trac] #37923: Introduce shared wp_blogmeta database table for multisite installation

[WordPress Trac]

#37923: Introduce shared wp_blogmeta database table for multisite installation
-------------------------------------------------+-------------------------
 Reporter:  johnjamesjacoby                      |       Owner:  flixos90
     Type:  feature request                      |      Status:  closed
 Priority:  normal                               |   Milestone:  5.0
Component:  Networks and Sites                   |     Version:
 Severity:  normal                               |  Resolution:  fixed
 Keywords:  has-patch has-unit-tests needs-      |     Focuses:  multisite
  testing ms-roadmap needs-dev-note              |
-------------------------------------------------+-------------------------

Comment (by DJPaul):

 It's just come to BuddyPress' attention that this change is going to break
 existing multisites using BuddyPress: #buddypress7834

 Especially given that JJJ opened this ticket originally, it won't surprise
 you to learn that BuddyPress adds its own blog meta tables. When we
 introduced meta tables for BuddyPress components, so that we could re-use
 WordPress' metadata API, we added our custom meta table references to the
 `$wpdb` global. For our "blogs" component, that ended being
 `$wpdb->blogs`, which now WordPress uses.

 So, that's the conflict. As a result, BuddyPress breaks WordPress SQL
 queries, and WordPress breaks BuddyPress SQL queries.

 I haven't had time yet to look into if BuddyPress can simply rename the
 property we add to `$wpdb`. That's probably ultimately going to have to be
 the fix one way or another on our end,  and hopefully it's
 straightforward. We have a release scheduled for tomorrow, but we may fix
 this in a subsequent release prior to WP 5.0.

 Just a heads-up: I felt it worth mentioning here as the resulting MySQL
 errors (there's one on the linked BuddyPress ticket) will probably look
 weird to people trying to debug.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/37923#comment:88>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform