Answers.Body: <p>I wasn't getting good hits on searching, but following re-links in comments on questions related to indices problems, I found this Question with an accepted answer that solved my problem:</p>
  <p><a href="https://civicrm.stackexchange.com/questions/18739/problem-fixing-missing-indexes-after-upgrade-to-4-7">Problem fixing missing indexes after upgrade to 4.7</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-04-20T16:08:03.283Z
Answers.LastActivityDate: 2023-04-20T16:08:03.283Z
Answers.UserDisplayName: kapn
Body: <p>A site that was running fine on 5.60.0 for a week or so with no notices. I see today that there is a notice about missing indices:</p>
  <p><a href="https://i.sstatic.net/7LtIR.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/7LtIR.png" alt="screenshot of tables missing indices" /></a></p>
  <p>Ok. I can follow instructions. However on pressing the &quot;Update indices&quot; button I get an error pop-up:</p>
  <p><code>Operation failed: Update Indices DB Error: unknown error Debug information: DROP INDEX UI_case_contact_id ON civicrm_case_contact [nativecode=1553 ** Cannot drop index 'UI_case_contact_id': needed in a foreign key constraint]</code></p>
  <p>In poking around here on Stack Exchange I see issues related to the update indices process popping up, but they seem adjacent to my problem rather than the same. I am also struggling to make sense of their solutions, which seem very specific and none of which seem to involve a <code>foreign key constraint</code>.</p>
  
Tags: <database><indices>
Title: "Update indices" fails because of `foreign key constraint`
ThreadText: # "Update indices" fails because of `foreign key constraint`
  
  (Asked by: username_0 on 2023-04-20)
  
  A site that was running fine on 5.60.0 for a week or so with no notices. I see today that there is a notice about missing indices:
  
  [![screenshot of tables missing indices](https://i.sstatic.net/7LtIR.png)](https://i.sstatic.net/7LtIR.png)
  
  Ok. I can follow instructions. However on pressing the "Update indices" button I get an error pop-up:
  
  `Operation failed: Update Indices DB Error: unknown error Debug information: DROP INDEX UI_case_contact_id ON civicrm_case_contact [nativecode=1553 ** Cannot drop index 'UI_case_contact_id': needed in a foreign key constraint]`
  
  In poking around here on Stack Exchange I see issues related to the update indices process popping up, but they seem adjacent to my problem rather than the same. I am also struggling to make sense of their solutions, which seem very specific and none of which seem to involve a `foreign key constraint`.
  
  **Tags:** database, indices
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2023-04-20. Score: 0 | Accepted answer
  
  I wasn't getting good hits on searching, but following re-links in comments on questions related to indices problems, I found this Question with an accepted answer that solved my problem:
  
  [Problem fixing missing indexes after upgrade to 4.7](https://civicrm.stackexchange.com/questions/18739/problem-fixing-missing-indexes-after-upgrade-to-4-7)
  
  
  ---
  
  