From 9397d32429489b84d9f7c19def769796477bfb37 Mon Sep 17 00:00:00 2001 From: David Bourgault Date: Fri, 22 Sep 2017 11:39:51 -0400 Subject: [PATCH] Bug 12747 - Fix : INSERT IGNORE INTO in atomicupdate --- .../atomicupdate/bug_12747-additional_fields_in_Z3950_search_result.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_12747-additional_fields_in_Z3950_search_result.sql b/installer/data/mysql/atomicupdate/bug_12747-additional_fields_in_Z3950_search_result.sql index 2a6013f..d60bed3 100644 --- a/installer/data/mysql/atomicupdate/bug_12747-additional_fields_in_Z3950_search_result.sql +++ b/installer/data/mysql/atomicupdate/bug_12747-additional_fields_in_Z3950_search_result.sql @@ -1 +1 @@ -INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('AdditionalFieldsInZ3950ResultSearch', '', 'NULL', 'Determines which MARC field/subfields are displayed in -Additional field- column in the result of a search Z3950', 'Free'); +INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('AdditionalFieldsInZ3950ResultSearch', '', 'NULL', 'Determines which MARC field/subfields are displayed in -Additional field- column in the result of a search Z3950', 'Free'); -- 2.7.4