[wp-trac] [WordPress Trac] #31388: Database Error During Upgrade

[WordPress Trac]

#31388: Database Error During Upgrade
--------------------------+--------------------
 Reporter:  miqrogroove   |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  4.2
Component:  Taxonomy      |     Version:  trunk
 Severity:  blocker       |  Resolution:
 Keywords:                |     Focuses:
--------------------------+--------------------
Changes (by boonebgorges):

 * milestone:  Awaiting Review => 4.2


Comment:

 Confirmed. This appears to be tied to [31349]. When upgrading a database
 with the unique index on the 'slug' column, the index is removed in
 `pre_schema_upgrade()`, with the intention of re-adding it during
 `make_db_current_silent()`. But something about the way `dbDelta()`
 interprets `KEY slug (slug(191))` is making it try to re-drop the index
 before recreating it. Thus the error message.

 The simplest solution would be to recreate the 'slug' index at the same
 time that it's dropped in `pre_schema_upgrade()` (it will then be dropped
 and readded again during `make_db_current()`). I'd like @pento to chime in
 first, though, to make sure that this ain't crazy talk.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/31388#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform