From 2f4aa1a0d4d1ee2744ed15b0de372695869406c6 Mon Sep 17 00:00:00 2001 From: Bouzid Fergani Date: Mon, 28 Dec 2015 08:59:21 -0500 Subject: [PATCH] Bug 12528 - fix problem when insert OPACEnhancedMessagingPreferences Signed-off-by: Aleisha --- installer/data/mysql/atomicupdate/sysprefs_Bug12528.sql | 6 ++---- .../intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref | 2 +- 2 files changed, 3 insertions(+), 5 deletions(-) diff --git a/installer/data/mysql/atomicupdate/sysprefs_Bug12528.sql b/installer/data/mysql/atomicupdate/sysprefs_Bug12528.sql index b711e47..db5275d 100644 --- a/installer/data/mysql/atomicupdate/sysprefs_Bug12528.sql +++ b/installer/data/mysql/atomicupdate/sysprefs_Bug12528.sql @@ -1,4 +1,2 @@ -INSERT INTO systempreferences ( variable, value, options, explanation,type ) VALUES -('OPACEnhancedMessagingPreferences', '1', NULL, 'If ON, show patrons messaging setting on the OPAC.', 'YesNo') ON DUPLICATE KEY UPDATE value ='1'; -INSERT INTO systempreferences ( variable, value, options, explanation,type ) VALUES -('EnhancedMessagingPreferences', '1', NULL, 'If ON, allows patrons to select to receive additional messages about items due or nearly due.', 'YesNo') ON DUPLICATE KEY UPDATE value ='1'; +INSERT INTO systempreferences ( value, variable, options, explanation,type ) +select value ,'OPACEnhancedMessagingPreferences', NULL, 'If ON, allows patrons to select to receive additional messages about items due or nearly due.', 'YesNo' from systempreferences where variable='EnhancedMessagingPreferences'; diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref index c067ba7..150a9c3 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref @@ -164,7 +164,7 @@ Patrons: choices: yes: Show no: "Don't show" - - "patron messaging setting on the OPAC (NOTE: EnhancedMessagingPreferences must be enabled)." + - "patron messaging setting on the OPAC (note: EnhancedMessagingPreferences must be enabled)." "Norwegian patron database": - -- 2.7.0