[wp-hackers] dbDelta and duplicated indices

Mark Jaquith mark.wordpress at txfx.net
Wed Apr 26 05:11:47 GMT 2006

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

More information about the wp-hackers mailing list