From 4df156b0ac3e9e219f7ddbcd44a696d72ff8cafb 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 Signed-off-by: Martin Renvoize --- 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.20.1