[wpmu-trac] [WordPress MU Trac] #1065: Duplicate wp_x_options and wp_sitemeta records for update_core, update_plugins, update_themes and dismissed_update_core

[WordPress MU Trac]

#1065: Duplicate wp_x_options and wp_sitemeta records for update_core,
update_plugins, update_themes and dismissed_update_core
----------------------------+-----------------------------------------------
 Reporter:  jamescollins    |       Owner:  somebody
     Type:  defect          |      Status:  new     
 Priority:  normal          |   Milestone:  2.8.1a  
Component:  Administration  |     Version:  2.8.1   
 Severity:  normal          |    Keywords:          
----------------------------+-----------------------------------------------
 The actions/filters in wp-includes/wpmu-functions.php override the default
 WP behavior of storing the update_core, update_plugins, update_themes and
 dismissed_update_core as transients in the wp_options table.

 Instead for WPMU they are stored as site options (in the wp_sitemeta
 table) so the same values are used no matter which blog id is performing
 the update check.

 When the set_transient() function is called to store one of the above
 options, the pre_set_transient_update_core filter is run which adds the
 data to the wp_sitemeta table instead.

 The option is then deleted straight away, even though it doesn't exist yet
 (see the site_pre_set_transient_update_plugins() function for an example).

 If you inspect the set_transient() source code, after the
 pre_set_transient_update_core filter is applied, the update_core transient
 is then added to the wp_x_options table.

 Although this data in the wp_x_options table isn't actually used (as far
 as I can tell), it shouldn't be stored there at all.


 You can replicate this behaviour by looking in the wp_1_options table for
 the _transient_update_plugins option. Delete this, and also delete the
 update_core wp_sitemeta record.

 Then reload blog id 1's dashboard. You will notice that both the
 wp_1_options record and the wp_sitemeta record are both recreated.

-- 
Ticket URL: <http://trac.mu.wordpress.org/ticket/1065>
WordPress MU Trac <http://mu.wordpress.org/>
WordPress Multiuser