[wp-trac] [WordPress Trac] #13079: Database errors during 3.0b1 upgrade

[WordPress Trac]

#13079: Database errors during 3.0b1 upgrade
-----------------------------+----------------------------------------------
 Reporter:  solarissmoke     |       Owner:  dd32
     Type:  defect (bug)     |      Status:  new 
 Priority:  normal           |   Milestone:  3.0 
Component:  Upgrade/Install  |     Version:  3.0 
 Severity:  normal           |    Keywords:      
-----------------------------+----------------------------------------------
 Hi,

 I'm getting the following two database errors every time I upgrade my 3.0b
 install to the latest nightly:

 {{{
 WordPress database error Duplicate key name 'comment_approved' for query
 ALTER TABLE wp_comments ADD KEY comment_approved (comment_approved) made
 by wp_upgrade, make_db_current_silent, dbDelta
 WordPress database error Duplicate key name 'type_status_date' for query
 ALTER TABLE wp_posts ADD KEY type_status_date
 (post_type,post_status,post_date,ID) made by wp_upgrade,
 make_db_current_silent, dbDelta
 }}}

 It seems like dbDelta is not detecting that these keys already exist in
 the table before trying to insert them...

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