[wp-trac] [WordPress Trac] #42422: 'unique' index not removed from the 'slug' column of the 'wp_terms' table

[WordPress Trac]

#42422: 'unique' index not removed from the 'slug' column of the 'wp_terms' table
--------------------------+------------------------------
 Reporter:  joellisenby   |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Taxonomy      |     Version:  4.8.3
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by boonebgorges):

 Hi @joellisenby - Thanks for the ticket, and welcome to WordPress Trac.

 A couple questions about this installation:

 - Is it single-site or Multisite?
 - What's the db_version string in wp_options?
 - Have other, more recent database schema changes successfully taken
 place? For example: what's the size of your `wp_posts.post_password`
 column? [38590]? Or, do you have a `wp_termmeta` table?
 - How large is the `wp_terms` table?

 I'm wondering if perhaps the `ALTER TABLE` command issued by `dbDelta()`
 was somehow interrupted - maybe due to slowness in rebuilding a large
 index - and never corrected itself. What happens if you manually run the
 `ALTER TABLE` query to remove the `UNIQUE` constraint?

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