From 7d1e508c2cb31a376c1e36fb6447482a3ac394e0 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 2623472..ff70900 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.1.4