From 64570ecfb7b6fd02e089d9380bd508367f35b206 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 29 Apr 2016 15:52:36 +0100 Subject: [PATCH] Bug 12528: Add IGNORE to the INSERT statement Signed-off-by: Jonathan Druart --- installer/data/mysql/atomicupdate/sysprefs_Bug12528.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/sysprefs_Bug12528.sql b/installer/data/mysql/atomicupdate/sysprefs_Bug12528.sql index 793c119..2a9b675 100644 --- a/installer/data/mysql/atomicupdate/sysprefs_Bug12528.sql +++ b/installer/data/mysql/atomicupdate/sysprefs_Bug12528.sql @@ -1,2 +1,2 @@ -INSERT INTO systempreferences ( value, variable, options, explanation,type ) +INSERT IGNORE INTO systempreferences ( value, variable, options, explanation,type ) select value ,'EnhancedMessagingPreferencesOPAC', NULL, 'If ON, allows patrons to select to receive additional messages about items due or nearly due.', 'YesNo' from systempreferences where variable='EnhancedMessagingPreferences'; -- 2.7.0