From 0b342c5bafbec3ad778b861dfbee7c123c171f27 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 --- 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.11.0