Bug 8995: Add IGNORE to the INSERT statement

Signed-off-by: Magnus Enger <magnus@libriotech.no>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>

diff --git a/installer/data/mysql/atomicupdate/8995_OpenURL_sysprefs.sql b/installer/data/mysql/atomicupdate/8995_OpenURL_sysprefs.sql
index 2623472..ff70900 100644 (file)
--- 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'),