[wp-trac] [WordPress Trac] #56259: Database Repair doesn't check for missing primary keys / A.I.

[WordPress Trac]

#56259: Database Repair doesn't check for missing primary keys / A.I.
-------------------------+------------------------------
 Reporter:  harryfear    |       Owner:  (none)
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Database     |     Version:
 Severity:  minor        |  Resolution:
 Keywords:               |     Focuses:
-------------------------+------------------------------

Comment (by ramon fincken):

 I am the owner of the site you referred to @harryfear , we have a full
 working free script that will use the latest schema.php at
 https://wpindexfixer.tools.managedwphosting.nl/

 See this explanation about repair.php versus actually re-adding keys:
 https://wpindexfixer.tools.managedwphosting.nl/#comment-11

 The source of disappearing indexes in most of the times is database
 migrations gone wrong where the indexes are added in the very last lines
 of the SQL commands. When the migration encounters even one error , the
 whole execution stops. leaving you with perfectly valid data, but no
 indexes.


 Does this help in answering your question ?

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