Answers.Body: <p>There are a couple of posts on this issue. The one that worked easiest for me is the artfulrobot answer in <a href="https://civicrm.stackexchange.com/questions/18487/how-to-find-and-or-fix-missing-indices/19424#comment22161_19424">How to find and/or fix missing indices?</a>. You can execute steps 3-5 runing SQL commands either at the command line or in phpMyAdmin. Although the post was for drupal, it worked for me on our wordpress instance.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-26T07:37:32.427Z
Answers.LastActivityDate: 2017-07-26T07:37:32.427Z
Answers.UserDisplayName: Karl Rudnick
Body: <p>I'm just update to civicrm 4.7.22 on Drupal 7.56.</p>
  
  <p>After the update, I received a system status warning "Performance warning: Missing indices".</p>
  
  <p>I click to Update Indices and have these error: "Operation failed: Update Indices DB Error: already exists" </p>
  
  <p>In the Drupal log, I have the message:</p>
  
  <p>"$Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler ) [code] => -5 [message] => DB Error: already exists [mode] => 16 [debug_info] => CREATE UNIQUE INDEX UI_case_contact_id ON civicrm_case_contact (case_id, contact_id) [nativecode=1061 ** Duplicate key name 'UI_case_contact_id'] [type] => DB_Error [user_info] => CREATE UNIQUE INDEX UI_case_contact_id ON civicrm_case_contact (case_id, contact_id) [nativecode=1061 ** Duplicate key name 'UI_case_contact_id'] [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="CREATE UNIQUE INDEX UI_case_contact_id ON civicrm_case_contact (case_id, contact_id) [nativecode=1061 ** Duplicate key name 'UI_case_contact_id']"] )"</p>
  
  <p>Do I need to solve this issue? And how can I?</p>
  
  <p>Thanks.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-25T11:10:59.150Z
Comments.Text: There's an answer posted for this issue at https://civicrm.stackexchange.com/questions/19384/how-can-i-fix-this-problem-with-duplicate-index-in-4-7-21/19385#19385
Comments.UserDisplayName: jitendra - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-25T16:22:03.647Z
Comments.Text: Possible duplicate of [How can I fix this problem with duplicate index in 4.7.21?](https://civicrm.stackexchange.com/questions/19384/how-can-i-fix-this-problem-with-duplicate-index-in-4-7-21)
Comments.UserDisplayName: Jon G - Megaphone Tech
Tags: <error><database><upgrade>
Title: Update 4.7.22 : Operation failed: Update Indices DB Error: already exists
ThreadText: # Update 4.7.22 : Operation failed: Update Indices DB Error: already exists
  
  (Asked by: username_0 on 2017-07-25)
  
  I'm just update to civicrm 4.7.22 on Drupal 7.56.
  
  After the update, I received a system status warning "Performance warning: Missing indices".
  
  I click to Update Indices and have these error: "Operation failed: Update Indices DB Error: already exists"
  
  In the Drupal log, I have the message:
  
  "$Fatal Error Details = Array ( [callback] => Array ( [0] => CRM\_Core\_Error [1] => exceptionHandler ) [code] => -5 [message] => DB Error: already exists [mode] => 16 [debug\_info] => CREATE UNIQUE INDEX UI\_case\_contact\_id ON civicrm\_case\_contact (case\_id, contact\_id) [nativecode=1061 \*\* Duplicate key name 'UI\_case\_contact\_id'] [type] => DB\_Error [user\_info] => CREATE UNIQUE INDEX UI\_case\_contact\_id ON civicrm\_case\_contact (case\_id, contact\_id) [nativecode=1061 \*\* Duplicate key name 'UI\_case\_contact\_id'] [to\_string] => [db\_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM\_Core\_Error::exceptionHandler prefix="" info="CREATE UNIQUE INDEX UI\_case\_contact\_id ON civicrm\_case\_contact (case\_id, contact\_id) [nativecode=1061 \*\* Duplicate key name 'UI\_case\_contact\_id']"] )"
  
  Do I need to solve this issue? And how can I?
  
  Thanks.
  
  **Tags:** error, database, upgrade
  
  > **Comments:**
  > **username_1**: There's an answer posted for this issue at https://civicrm.stackexchange.com/questions/19384/how-can-i-fix-this-problem-with-duplicate-index-in-4-7-21/19385#19385  
  > **username_2**: Possible duplicate of [How can I fix this problem with duplicate index in 4.7.21?](https://civicrm.stackexchange.com/questions/19384/how-can-i-fix-this-problem-with-duplicate-index-in-4-7-21)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2017-07-26. Score: 1
  
  There are a couple of posts on this issue. The one that worked easiest for me is the artfulrobot answer in [How to find and/or fix missing indices?](https://civicrm.stackexchange.com/questions/18487/how-to-find-and-or-fix-missing-indices/19424#comment22161_19424). You can execute steps 3-5 runing SQL commands either at the command line or in phpMyAdmin. Although the post was for drupal, it worked for me on our wordpress instance.
  
  
  ---
  
  