[wpmu-trac] [WordPress MU Trac] #751: Duplicate option_name and other wp_XX_options weirdness

[WordPress MU Trac]

#751: Duplicate option_name and other wp_XX_options weirdness
------------------------+---------------------------------------------------
 Reporter:  webmaestro  |       Owner:  somebody
     Type:  defect      |      Status:  new     
 Priority:  normal      |   Milestone:          
Component:  component1  |     Version:          
 Severity:  normal      |    Keywords:          
------------------------+---------------------------------------------------
 I'm noticing a few duplicate {{{option_name}}} items in wp_XX_options:

   - blacklist_keys(3) (one w highest {{{option_id}}} has {{{autoload =
 'yes'}}})
   - moderation_keys(3) (one w highest {{{option_id}}} has {{{autoload =
 'yes'}}})
   - recently_edited(2) (both have {{{autoload='no'}}})
   - update_core(2) (both have {{{autoload='yes'}}})

 I checked my pre-WPMU-2.6.1 database on DEV, & while some of the fields
 existed none were duplicates. Along with WPMU-2.6.1, the following plugins
 were also installed:

   - akismet - http://akismet.com/
   - !TanTanNoodles Simple Spam Filter - http://tantannoodles.com/toolkit
 /spam-filter/
   - wphone - http://wphoneplugin.org/

 The following plugins were upgraded:

   - Sociable - http://yoast.com/wordpress/sociable/
   - WP !AdminBar - http://www.viper007bond.com/wordpress-plugins
 /wordpress-admin-bar/

 In addition, we have some strange values where
 {{{option_name='active_plugins'}}}:

 {{{
 a:20:{i:0;s:23:"democracy/democracy.php";i:1;s:21:"sociable/sociable.php";
 i:2;s:21:"sociable/sociable.php";i:3;s:21:"sociable/sociable.php";
 i:4;s:13:"tag-cloud.php";i:5;s:13:"tag-cloud.php";i:6;s:13:"tag-
 cloud.php";
 i:7;s:13:"tag-cloud.php";i:8;s:43:"wordpress-admin-bar/wordpress-admin-
 bar.php";
 i:9;s:43:"wordpress-admin-bar/wordpress-admin-bar.php";
 i:10;s:43:"wordpress-admin-bar/wordpress-admin-bar.php";
 i:11;s:27:"wp-spamfree/wp-spamfree.php";i:12;s:27:"wp-spamfree/wp-
 spamfree.php";
 i:13;s:27:"wp-spamfree/wp-spamfree.php";i:14;s:27:"wp-spamfree/wp-
 spamfree.php";
 i:15;s:27:"wp-spamfree/wp-spamfree.php";i:16;s:27:"wp-spamfree/wp-
 spamfree.php";
 i:17;s:27:"wp-spamfree/wp-spamfree.php";i:18;s:27:"wp-spamfree/wp-
 spamfree.php";
 i:19;s:17:"wphone/wphone.php";}
 }}}

 BTW, I did notice some issues when I was attempting to remove WP-!SpamFree
 (we're testing a switch to !TanTan+Akismet+reCAPTCHA). I clicked
 'deactivate', but WP-!SpamFree still showed up in the 'Active Plugins'
 list. I clicked a number of times in Firefox and it always showed
 WP-!SpamFree was active. Then I switched to a Mac OS X 'Chrome' clone
 called Stainless, and when the plugins page loaded, WP-!SpamFree was
 deactivated. Not only that, but I was already logged in to the Admin
 (and that was the first time I'd launched Stainless after downloading).
 Strange... If there are too many issues in this ticket, I can split
 them...

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