From 0f78be59e946b7cc18bbbe3b3aca548ecc190835 Mon Sep 17 00:00:00 2001 From: pratikshad Date: Wed, 28 Jan 2015 13:08:10 +1000 Subject: [PATCH] Fixed civicrm upgrade issue --- CRM/Upgrade/Incremental/sql/4.6.alpha4.mysql.tpl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Upgrade/Incremental/sql/4.6.alpha4.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.alpha4.mysql.tpl index a3178dda15..a4b3e7e3d2 100644 --- a/CRM/Upgrade/Incremental/sql/4.6.alpha4.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.6.alpha4.mysql.tpl @@ -10,11 +10,11 @@ ALTER TABLE `civicrm_pcp_block` ADD `owner_notify_id` INT NULL DEFAULT NULL COMM ALTER TABLE `civicrm_pcp` ADD `is_notify` INT NOT NULL DEFAULT '0'; --Add PCP owner notification option group -INSERT INTO `civicrm_option_group` ( `name`, `title`, `is_active` ) VALUES ('pcp_owner_notify', 'PCP owner notifications', 1); +INSERT INTO `civicrm_option_group` ( `name`, {localize field='title'}`title`{/localize}, `is_active` ) VALUES ('pcp_owner_notify', {localize}'{ts escape="sql"}PCP owner notifications{/ts}'{/localize}, 1); SELECT @ogid_pcp_owner := MAX(id) FROM `civicrm_option_group`; -INSERT INTO `civicrm_option_value` (`option_group_id`, `label`, `value`, `name`, `is_default`, `weight`) VALUES (@ogid_pcp_owner, 'Owner chooses whether to receive notifications', '1', 'owner_chooses', 1, 1), (@ogid_pcp_owner, 'Notifications are sent to ALL owners', '2', 'all_owners', 0, 2),(@ogid_pcp_owner, 'Notifications are NOT available', '3', 'no_notifications', 0, 3); +INSERT INTO `civicrm_option_value` (`option_group_id`, {localize field='label'}`label`{/localize}, `value`, `name`, `is_default`, `weight`) VALUES (@ogid_pcp_owner, {localize}'{ts escape="sql"}Owner chooses whether to receive notifications{/ts}'{/localize}, '1', 'owner_chooses', 1, 1), (@ogid_pcp_owner, {localize}'{ts escape="sql"}Notifications are sent to ALL owners{/ts}'{/localize}, '2', 'all_owners', 0, 2),(@ogid_pcp_owner, {localize}'{ts escape="sql"}Notifications are NOT available{/ts}'{/localize}, '3', 'no_notifications', 0, 3); UPDATE `civicrm_pcp_block` SET `owner_notify_id` = 3; UPDATE `civicrm_pcp` SET `is_notify` = 0; -- 2.25.1