Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Important
-
Resolution: Duplicate
-
Affects Version/s: 4.7.19
-
Fix Version/s: 4.7.20
-
Component/s: None
-
Labels:None
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Needs Funding
-
Verified?:No
Description
I get below error when trying to update all indexes in CiviCRM table.
May 08 07:55:00 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -5
[message] => DB Error: already exists
[mode] => 16
[debug_info] => CREATE INDEX index_all ON civicrm_prevnext_cache (cacheKey, entity_id1, entity_id2, entity_table, is_selected) [nativecode=1061 ** Duplicate key name 'index_all']
[type] => DB_Error
[user_info] => CREATE INDEX index_all ON civicrm_prevnext_cache (cacheKey, entity_id1, entity_id2, entity_table, is_selected) [nativecode=1061 ** Duplicate key name 'index_all']
[to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="CREATE INDEX index_all ON civicrm_prevnext_cache (cacheKey, entity_id1, entity_id2, entity_table, is_selected) [nativecode=1061 ** Duplicate key name 'index_all']"]
)
Attachments
Issue Links
- duplicates
-
CRM-20533 'Update Indices' System Status action can get tied up (index name already exists, localised dbs?)
- Reopened