From 233448e03c8c6329e57dd169a73812b458ec7d36 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Thu, 8 Aug 2019 14:57:25 +0100 Subject: [PATCH] Bug 23228: (QA follow-up) Fix the DB update Signed-off-by: Martin Renvoize --- .../atomicupdate/FinePaymentAutoPopup.perl | 22 +++++++++++++------ 1 file changed, 15 insertions(+), 7 deletions(-) diff --git a/installer/data/mysql/atomicupdate/FinePaymentAutoPopup.perl b/installer/data/mysql/atomicupdate/FinePaymentAutoPopup.perl index 8e1128cd9d..7e19e5fd67 100644 --- a/installer/data/mysql/atomicupdate/FinePaymentAutoPopup.perl +++ b/installer/data/mysql/atomicupdate/FinePaymentAutoPopup.perl @@ -1,10 +1,18 @@ -$DBversion = 'XXX'; # will be replaced by the RM -if( CheckVersion( $DBversion ) ) { - $dbh->do({ - INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES - ('FinePaymentAutoPopup','0',NULL,'If enabled, automatically display a print dialog for a payment receipt when making a payment.','YesNo') +$DBversion = 'XXX'; # will be replaced by the RM +if ( CheckVersion($DBversion) ) { + $dbh->do(q{ + INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) + VALUES + ( + 'FinePaymentAutoPopup', + '0', + NULL, + 'If enabled, automatically display a print dialog for a payment receipt when making a payment.', + 'YesNo' + ) }); - SetVersion( $DBversion ); - print "Upgrade to $DBversion done (Bug 23228 - Add option to automatically display payment receipt for printing after making a payment)\n"; + SetVersion($DBversion); + print +"Upgrade to $DBversion done (Bug 23228 - Add option to automatically display payment receipt for printing after making a payment)\n"; } -- 2.20.1