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

 ''Is it single-site or Multisite?''

 Single-site

 ''What's the db_version string in wp_options?''

 38590

 ''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?''

 wp_posts.post_password size is 20. Now that you mention it, I had to
 manually create the wp_termmeta table as well.

 ''How large is the wp_terms table?''

 746 rows (after manually removing the unique constraint)

 ''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?''

 I was able to manually remove the UNIQUE constraint via phpmyadmin and I
 manually created the wp_termmeta table via phpmyadmin.

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