From 9bae51666478a7f224611f46c4708d3b7d8c6e9b Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Tue, 27 Oct 2015 12:07:27 -0300 Subject: [PATCH] Bug 10120: (QA followup) avoid raising warnings on upgrade Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/updatedatabase.pl | 12 +++++------- 1 file changed, 5 insertions(+), 7 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 03ae397..273611e 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -7019,13 +7019,11 @@ if(CheckVersion($DBversion)) { $DBversion = "3.13.00.006"; if ( CheckVersion($DBversion) ) { - $dbh->do( - q{ -INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('CalculateFinesOnReturn','1','Switch to control if overdue fines are calculated on return or not', '', 'YesNo'); -} - ); - print -"Upgrade to $DBversion done (Bug 10120 - Fines on item return controlled by a systempreference)\n"; + $dbh->do(q{ + INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) + VALUES ('CalculateFinesOnReturn','1','Switch to control if overdue fines are calculated on return or not', '', 'YesNo') + }); + print "Upgrade to $DBversion done (Bug 10120: Fines on item return controlled by a systempreference)\n"; SetVersion($DBversion); } -- 2.6.2