[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:  Upgrade/Install  |     Version:  trunk
 Severity:  normal           |  Resolution:
 Keywords:                   |     Focuses:
-----------------------------+--------------------
Changes (by pento):

 * component:  Taxonomy => Upgrade/Install
 * severity:  blocker => normal


Comment:

 The index is dropped and re-added at the same time, in
 `pre_schema_upgrade()`, because `dbDelta()` doesn't have the ability to
 drop indexes, and I'd much prefer the drop/re-create to be a single query.

 This error was caused because the `slug` index didn't exist before the
 upgrade started. Historically, we haven't checked for the existence of an
 index before dropping it.

 I'm inclined to leave this ticket open for a bit during 4.2 beta to see if
 we receive any more reports of this error. If there's no-one else, it'll
 be closed as `wontfix`.

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