[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 joeldfairbank):

 Actually I figured out how to do an ALTER TABLE in SQL but it didn't fix
 things. Thanks anyway!


 Replying to [comment:12 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:14>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform