0

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

|improve this question
  • Just wondering why you are only upgrading to 4.7.29 ? There are lots of fixes since then in later versions. – Aidan♦ Jun 27 '18 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 '18 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 '18 at 16:28
2

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.

HTH

Pradeep

|improve this answer

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.