From de3a52976601145a7ccbf7fa597731ca54710f6d Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 28 Sep 2016 13:18:12 +0100 Subject: [PATCH] Bug 8995: Add IGNORE to the INSERT statement Signed-off-by: Magnus Enger --- installer/data/mysql/atomicupdate/8995_OpenURL_sysprefs.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/8995_OpenURL_sysprefs.sql b/installer/data/mysql/atomicupdate/8995_OpenURL_sysprefs.sql index 262347256f..ff70900e3e 100644 --- a/installer/data/mysql/atomicupdate/8995_OpenURL_sysprefs.sql +++ b/installer/data/mysql/atomicupdate/8995_OpenURL_sysprefs.sql @@ -1,4 +1,4 @@ -INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES +INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('OpenURLResolverURL', '', 'URL of OpenURL Resolver', NULL, 'Free'), ('OpenURLText', '', 'Text of OpenURL links (or image title if OpenURLImageLocation is defined)', NULL, 'Free'), ('OpenURLImageLocation', '', 'Location of image for OpenURL links', NULL, 'Free'), -- 2.17.1