Details
-
Type: Bug
-
Status: Open
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: 4.7.28
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Needs Funding
-
Verified?:No
Description
After upgrading from 4.7.16 to 4.7.28, I got an error on the System Status page when clicking on "Update Indices" (/civicrm/a/#/status), see file(s) attached:
"Operation failed: Update IndicesDB Error: unknown error*Debug information:*
DROP INDEX UI_case_contact_id ON civicrm_case_contact [nativecode=1553 ** Cannot drop index 'UI_case_contact_id': needed in a foreign key constraint]"
When I update the indices via mysql it works:
USE db_civicrm;
SHOW CREATE TABLE civicrm_contact;
SET foreign_key_checks = 0;
SHOW INDEX FROM civicrm_contact;
DROP INDEX `index_is_deceased` on civicrm_contact;
CREATE INDEX `index_is_deceased` on civicrm_contact (is_deceased);
SET foreign_key_checks = 1;