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

[WordPress Trac]

#31388: Database Error During Upgrade
-----------------------------+-----------------------
 Reporter:  miqrogroove      |       Owner:
     Type:  defect (bug)     |      Status:  reopened
 Priority:  normal           |   Milestone:  4.2.3
Component:  Upgrade/Install  |     Version:  4.2
 Severity:  blocker          |  Resolution:
 Keywords:                   |     Focuses:
-----------------------------+-----------------------

Comment (by jstensved):

 This is not a support forum but recreating the index will allow WordPress
 to remove it and then recreate it:

 TL;DR: Run "ALTER TABLE wp_terms ADD INDEX slug(slug(191))".

 Replying to [comment:11 joeldfairbank]:
 > My client's website is down due to this error:
 >
 > WordPress database error Can't DROP 'slug'; check that column/key exists
 for query ALTER TABLE wp_terms DROP INDEX slug, ADD INDEX slug(slug(191))
 made by wp_upgrade, pre_schema_upgrade
 >
 > http://www.btedj.com
 >
 > What do i do to fix?
 >
 > Thank you.

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