[wp-trac] [WordPress Trac] #30795: Upgrade bug affecting indexing

[WordPress Trac]

#30795: Upgrade bug affecting indexing
--------------------------+-----------------------
 Reporter:  MattyRob      |       Owner:  (none)
     Type:  defect (bug)  |      Status:  reopened
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:  2.1
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+-----------------------
Changes (by hubertnguyen):

 * status:  closed => reopened
 * resolution:  duplicate =>


Comment:

 I just got this error on my development system after upgrading to WP 5.1
 (from 5.0). I googled, and found this page.

 WordPress database error: [Duplicate key name 'type_status_date']
 ALTER TABLE wp_posts ADD KEY `type_status_date`
 (`post_type`,`post_status`,`post_date`,`ID`)

 PHP Version 7.2.5-1+ubuntu16.04.1+deb.sury.org+1
 mysqlnd 5.0.12-dev - 20150407 - $Id:
 38fea24f2847fa7519001be390c98ae0acafe387 $

 Everything seems to work, but it's an odd message to see. I thought I'd
 share.

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