From 449cc8b07217563644fc0f05928279727be2c5c9 Mon Sep 17 00:00:00 2001 From: Eileen McNaughton Date: Tue, 27 May 2014 20:22:19 +1200 Subject: [PATCH] CRM-14755 - upgrade fails on insert country --- CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl index dd8510d6f8..d12b119bb0 100644 --- a/CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.3.alpha1.mysql.tpl @@ -125,7 +125,7 @@ ALTER TABLE civicrm_uf_field -- CRM-1115 -- note that country names are not translated in the DB SELECT @region_id := max(id) from civicrm_worldregion where name = "Europe and Central Asia"; -INSERT INTO civicrm_country (name,iso_code,region_id,is_province_abbreviated) VALUES("Kosovo", "XK", @region_id, 0); +INSERT IGNORE INTO civicrm_country (name,iso_code,region_id,is_province_abbreviated) VALUES("Kosovo", "XK", @region_id, 0); UPDATE civicrm_country SET name = 'Libya' WHERE name LIKE 'Libyan%'; UPDATE civicrm_country SET name = 'Congo, Republic of the' WHERE name = 'Congo'; -- 2.25.1