From 9bae51666478a7f224611f46c4708d3b7d8c6e9b Mon Sep 17 00:00:00 2001
From: Tomas Cohen Arazi <tomascohen@theke.io>
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 <tomascohen@theke.io>
---
 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