[wp-trac] [WordPress Trac] #2699: Make option_name index unique

[WordPress Trac]

#2699: Make option_name index unique
-----------------------------------------+----------------------------------
 Reporter:  johnjosephbachir             |        Owner:  ryan    
     Type:  task (blessed)               |       Status:  reopened
 Priority:  high                         |    Milestone:  2.9     
Component:  Optimization                 |      Version:  2.8     
 Severity:  normal                       |   Resolution:          
 Keywords:  early has-patch 2nd-opinion  |  
-----------------------------------------+----------------------------------
Changes (by Viper007Bond):

  * status:  closed => reopened
  * resolution:  fixed =>


Comment:

 Upgrade on my live blog went fine (no dupes I guess). Attempted to upgrade
 my localhost blog and it errored out:

 {{{
 WordPress database error: [You have an error in your SQL syntax; check the
 manual that corresponds to your MySQL server version for the right syntax
 to use near '', '2480', '2482', '2482', '2491', '2492)' at line 1]
 DELETE FROM wp_trunk_options WHERE option_id IN (2480', '2480', '2482',
 '2482', '2491', '2492)

 WordPress database error: [Duplicate entry 'yarpp_use_template' for key
 'PRIMARY']
 ALTER TABLE wp_trunk_options ADD PRIMARY KEY (option_name)
 Upgrade Complete

 Your WordPress database has been successfully upgraded!
 }}}

 Note the missing single quotes on the first query. I assume the second
 query's error is due to the first query failying.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/2699#comment:17>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software