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

WordPress Trac noreply at wordpress.org
Thu Nov 2 19:07:17 UTC 2017

#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        |   Keywords:
  Focuses:                |
 This is a follow-up to #22023.

 It appears that on one of my older installations of wordpress the unique
 index was never removed from the 'slug' column of the 'wp_terms' table.
 The latest update 4.8.3 must have stirred something up with wp cron,
 conflicting with the unique status of the column. This has caused
 thousands of the following errors to be logged which in turn caused our
 server to 503 due to hitting the PHP FcgidMaxProcessesPerClass limit.

 Note: this installation has had regular updates since being installed
 years ago.

 WordPress database error Duplicate entry 'category-slug' for key 'slug'
 query INSERT INTO `wp_terms` (`name`, `slug`, `term_group`) VALUES
 ('Category Name', 'category-slug', 0) made by do_action_ref_array,
 WP_Hook->apply_filters, _wp_batch_split_terms, _split_shared_term

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

More information about the wp-trac mailing list