With successful update from 4.7.25 to 4.7.29 there is a Performance warning: Missing Indices in CiviCRM System Status. When I click the Update Indices button, the error appears

Operation failed: Update Indices DB Error: unknown error

Enabling debug mode does not provide any additional info.

Operation failed: Update Indices

  • Just wondering why you are only upgrading to 4.7.29 ? There are lots of fixes since then in later versions.
    – Aidan
    Jun 27, 2018 at 8:31
  • @Aidan, I was trying to do step by step upgrade, because upgrading to 4.7.30 (or later) got me into these problems: civicrm.stackexchange.com/questions/25098/…
    – Aivars
    Jun 28, 2018 at 15:44
  • Ok, that makes sense if 4.7.29 is an intermediate step. However, you can leave the Update Indices thing - that changed several times in releases around that time. It was a warning that indices were less than optimal but is not an error. When you eventually get to current versions you can fix it then if the warning still shows.
    – Aidan
    Jun 28, 2018 at 16:28

1 Answer 1


We had similar problem this before and had to manually run mysql commands to fix the indices. This link might be useful to solve the problem.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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