Skip to main content

Questions tagged [indices]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer

"Update indices" fails because of `foreign key constraint`

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: Ok. I can follow instructions. However on pressing the "Update ...
kapn's user avatar
  • 919
0 votes
1 answer

Update Indices fails on 4.7.29

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: ...
Aivars's user avatar
  • 1,034
0 votes
1 answer

CiviCRM 4.7.29 Update Indices fails

I've messed around unsuccessfully to update indices by following various posts in StackExchange for similar errors. I have the impression that the Update Indices button simply does not work correctly. ...
David Christie's user avatar
2 votes
0 answers

CiviCRM Update 4.7.27 Operation failed: Update Indices Errno: 150 [duplicate]

I updated my CiviCRM version to 4.7.27 yesterday and got a Performance warning on my system status page that there are some Missing indices. Clicking the 'Update Indices' button doesn't fix the ...
RaffyM's user avatar
  • 141
1 vote
0 answers

Update Indices fails with errno 150 on DROP INDEX UI_case_contact_id after upgrade from 4.6 to 4.7.27

Upgraded from 4.6.19 to 4.7.27 (on wordpress 4.8.3) and attempted to update indices. The table that fails is civicrm_case_contact, with the old index UI_case_contact_id. The error is identical to ...
PhilF's user avatar
  • 45
3 votes
1 answer

What to do about "Operation failed: Update Indices DB Error: unknown error Debug" after upgrading to 4.7.25

This is related to a question I posted yesterday (How does one delete "key indices"?), which was considered a duplicate of another question (Performance Warning: Missing Indices. Mismatched ...
The Amateur's user avatar
5 votes
3 answers

Performance Warning: Missing Indices. Mismatched Index Key

Just upgraded to 4.7.23 and am receiving a Performance Warning: Missing Indices. The warning states: The following tables have an index key with a mismatch in value. Please delete the key ...
TML100's user avatar
  • 51
0 votes
2 answers

Missing indices status after upgrading to CiviCRM 4.7.21 on WordPress 4.8

I successfully upgraded to CiviCRM 4.7.21 (from 4.7.17), and everything seems to be working properly. However, I got a critical status error, "Performance warning: Missing indices". After reading How ...
user1147171's user avatar