From 3d535eb34383c985b34f8f7272b6d71745e44871 Mon Sep 17 00:00:00 2001 From: monishdeb Date: Wed, 25 Jun 2014 19:04:10 +0530 Subject: [PATCH] 4.5alpha2 upgrade fixes --- .../Incremental/sql/4.5.alpha2.mysql.tpl | 20 +++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) diff --git a/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl index a876957045..ee42730410 100644 --- a/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.5.alpha2.mysql.tpl @@ -1,10 +1,10 @@ INSERT INTO `civicrm_dashboard` - (`id`, `domain_id`, `name`, `label`, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `fullscreen_url`, `is_fullscreen`, `is_active`, `is_reserved`, `weight`) + (`domain_id`, `name`, {localize field='label'}`label`{/localize}, `url`, `permission`, `permission_operator`, `column_no`, `is_minimized`, `fullscreen_url`, `is_fullscreen`, `is_active`, `is_reserved`, `weight`) VALUES - (6,1,'report/6','Donor Summary','civicrm/report/instance/6?reset=1§ion=1&snippet=5&charts=barChart','access CiviContribute','AND',0,0,'civicrm/report/instance/6?reset=1§ion=1&snippet=5&charts=barChart&context=dashletFullscreen',1,1,0,4), - (7,1,'report/13','Top Donors','civicrm/report/instance/13?reset=1§ion=2&snippet=5','access CiviContribute','AND',0,0,'civicrm/report/instance/13?reset=1§ion=2&snippet=5&context=dashletFullscreen',1,1,0,5), - (8,1,'report/25','Event Income Summary','civicrm/report/instance/25?reset=1§ion=1&snippet=5&charts=pieChart','access CiviEvent','AND',0,0,'civicrm/report/instance/25?reset=1§ion=1&snippet=5&charts=pieChart&context=dashletFullscreen',1,1,0,6), - (9,1,'report/20','Membership Summary','civicrm/report/instance/20?reset=1§ion=2&snippet=5','access CiviMember','AND',0,0,'civicrm/report/instance/20?reset=1§ion=2&snippet=5&context=dashletFullscreen',1,1,0,7); + ({$domainID},'report/6', {localize}'Donor Summary'{/localize},'civicrm/report/instance/6?reset=1§ion=1&snippet=5&charts=barChart','access CiviContribute','AND',0,0,'civicrm/report/instance/6?reset=1§ion=1&snippet=5&charts=barChart&context=dashletFullscreen',1,1,0,4), + ({$domainID},'report/13', {localize}'Top Donors'{/localize},'civicrm/report/instance/13?reset=1§ion=2&snippet=5','access CiviContribute','AND',0,0,'civicrm/report/instance/13?reset=1§ion=2&snippet=5&context=dashletFullscreen',1,1,0,5), + ({$domainID},'report/25', {localize}'Event Income Summary'{/localize}, 'civicrm/report/instance/25?reset=1§ion=1&snippet=5&charts=pieChart','access CiviEvent','AND',0,0,'civicrm/report/instance/25?reset=1§ion=1&snippet=5&charts=pieChart&context=dashletFullscreen',1,1,0,6), + ({$domainID},'report/20', {localize}'Membership Summary'{/localize},'civicrm/report/instance/20?reset=1§ion=2&snippet=5','access CiviMember','AND',0,0,'civicrm/report/instance/20?reset=1§ion=2&snippet=5&context=dashletFullscreen',1,1,0,7); UPDATE civicrm_dashboard SET civicrm_dashboard.url = CONCAT(SUBSTRING(url FROM 1 FOR LOCATE('&', url) - 1), '?', SUBSTRING(url FROM LOCATE('&', url) + 1)) @@ -30,14 +30,14 @@ INSERT INTO civicrm_action_mapping VALUES ( 'civicrm_contact', 'civicrm_contact', 'Date Field', 'contact_date_reminder_options', 'Annual Options', 'date_field', NULL, NULL); -INSERT INTO `civicrm_option_group` (`name`, `title`, `is_reserved`, `is_active`, `is_locked`) +INSERT INTO `civicrm_option_group` (`name`, {localize field='title'}`title`{/localize}, `is_reserved`, `is_active`, `is_locked`) VALUES - ('contact_date_reminder_options', '{ts escape="sql"}Contact Date Reminder Options{/ts}', 1, 1, 1); + ('contact_date_reminder_options', {localize}'{ts escape="sql"}Contact Date Reminder Options{/ts}'{/localize}, 1, 1, 1); SELECT @option_group_id_contactDateMode := max(id) from civicrm_option_group where name = 'contact_date_reminder_options'; INSERT INTO `civicrm_option_value` - (`option_group_id`, `label`, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`) + (`option_group_id`, {localize field='label'}`label`{/localize}, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`) VALUES - (@option_group_id_contactDateMode, '{ts escape="sql"}Actual date only{/ts}', '1', 'Actual date only', NULL, NULL, 0, 1, NULL, 0, 1, 1, NULL, NULL), - (@option_group_id_contactDateMode, '{ts escape="sql"}Each anniversary{/ts}', '2', 'Each anniversary', NULL, NULL, 0, 2, NULL, 0, 1, 1, NULL, NULL); + (@option_group_id_contactDateMode, {localize}'{ts escape="sql"}Actual date only{/ts}'{/localize}, '1', 'Actual date only', NULL, NULL, 0, 1, 0, 1, 1, NULL, NULL), + (@option_group_id_contactDateMode, {localize}'{ts escape="sql"}Each anniversary{/ts}'{/localize}, '2', 'Each anniversary', NULL, NULL, 0, 2, 0, 1, 1, NULL, NULL); -- 2.25.1