From 55e590cfa34a3048c221382f523ad5b8e3785b4c Mon Sep 17 00:00:00 2001 From: atif-shaikh Date: Fri, 3 Apr 2015 18:45:40 +0530 Subject: [PATCH] Improvement --- CRM/Upgrade/Incremental/sql/4.6.0.mysql.tpl | 12 +++++------- 1 file changed, 5 insertions(+), 7 deletions(-) diff --git a/CRM/Upgrade/Incremental/sql/4.6.0.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.0.mysql.tpl index a6d59255ae..7102073cc4 100644 --- a/CRM/Upgrade/Incremental/sql/4.6.0.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.6.0.mysql.tpl @@ -29,15 +29,13 @@ WHERE option_group_id = @option_group_id_notePrivacy AND value = 1; --These labels were never translated so just copy them over as names {if $multilingual} - {foreach from=$locales item=locale} - UPDATE civicrm_option_value v, civicrm_option_group g - SET v.name = v.label_{$locale} - WHERE g.id = v.option_group_id AND g.name IN - ('group_type', 'safe_file_extension', 'wysiwyg_editor'); - {/foreach} + UPDATE civicrm_option_value v, civicrm_option_group g + SET v.name = v.label_{$locales.0} + WHERE g.id = v.option_group_id AND g.name IN + ('group_type', 'safe_file_extension', 'wysiwyg_editor'); {else} UPDATE civicrm_option_value v, civicrm_option_group g - SET v.name = v.label + SET v.name = v.label WHERE g.id = v.option_group_id AND g.name IN ('group_type', 'safe_file_extension', 'wysiwyg_editor'); {/if} -- 2.25.1