2

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.

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?. 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.