[wp-trac] [WordPress Trac] #14445: dbdelta do not handel FULLTEXT KEY correctly and generate MySQL errors

[WordPress Trac]

#14445: dbdelta do not handel FULLTEXT KEY correctly and generate MySQL errors
--------------------------+-------------------------------------------------
 Reporter:  edirect24     |       Owner:                        
     Type:  defect (bug)  |      Status:  new                   
 Priority:  normal        |   Milestone:  Awaiting Review       
Component:  General       |     Version:  3.0                   
 Severity:  minor         |    Keywords:  has-patch dev-feedback
--------------------------+-------------------------------------------------
 When using dbdelta during the update of a plugin that a Fulltext index
 use, dbdelta generate a MYSQL error due to duplicate index.

 This is due to the array_search return always false.

 I attached a posible solution to address this issue. I added a key named
 'index_type' to the $index_ary. This way, when 'index_type' == fulltext, I
 add to $index_string "FULLTEXT".

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