[wp-hackers] dbDelta and duplicated indices

[Mark Jaquith]

On Apr 25, 2006, at 1:12 PM, Ryan Scheuermann wrote:

> And actually, I just tested it again - with a single column UNIQUE  
> KEY when the key already exists but you change the key column,  
> dbDelta attempts to ADD the unique key index but it doesn't drop  
> the old index first.  That's probably the problem.

I encountered a problem like this while testing a patch that bumped  
the database version... upgrade.php was throwing that error while  
dealing with one of WordPress' new multi-column keys.
--
Mark Jaquith
http://txfx.net/