Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.5
-
Fix Version/s: 4.5
-
Component/s: None
-
Labels:None
Description
this is a follow up on CRM-14755. We had some discussion around using INSERT IGNORE rather than INSERT when adding countries & states because organisations sometimes add these themselves (e.g some organisations added South Sudan to their database the day it was created).
So, given that we agreed it made sense that upgrades should not fail because organisations have edited their own states & countries - how do we get future commits to respect that - I see in alpha 2 upgrade
– CRM-14843 Added States for Chile and Modify Santiago Metropolitan for consistency
INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
(NULL, 1044, "LR", "Los Rios"),
(NULL, 1044, "AP", "Arica y Parinacota");
Would communicating to a list of people mean that multiple people are watching for it ? Planning list?
Attachments
Issue Links
- provides patch for
-
CRM-14755 upgrade fails on insert country
- Done/Fixed