From e9a1888f1b88baf523e576c45d67be519bfe4b7d Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Tue, 25 Aug 2020 14:18:32 +0000 Subject: [PATCH] Bug 23682: INSERT IGORE systen preference in database update Signed-off-by: Katrin Fischer --- installer/data/mysql/atomicupdate/bug_23682.perl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_23682.perl b/installer/data/mysql/atomicupdate/bug_23682.perl index 8aa64325fc..05aebbcc92 100644 --- a/installer/data/mysql/atomicupdate/bug_23682.perl +++ b/installer/data/mysql/atomicupdate/bug_23682.perl @@ -1,7 +1,7 @@ $DBversion = 'XXX'; # will be replaced by the RM if ( CheckVersion( $DBversion ) ) { $dbh->do(q{ - INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES + INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES ('EdifactInvoiceImport', 'automatic', 'automatic|manual', "If on, don't auto-import EDI invoices, just keep them in the database with the status 'new'", 'Choice') }); -- 2.11.0