From 2474987e4fca6d7bb871d445c5d41f17f2d97113 Mon Sep 17 00:00:00 2001 From: Mason James Date: Wed, 8 Apr 2015 19:14:55 +1200 Subject: [PATCH] Bug 13966 - Backport HEA to Koha 3.16 and/or 3.14 This trivial patch stops any potential SQL errors/warnings for a HEA enabled 3.16 or 3.14 Koha, when upgrading to a newer Koha Signed-off-by: Jonathan Druart Add the missing prefs unless they exist and don't raise an error if already exist. --- installer/data/mysql/updatedatabase.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index ca27cde..eeff2d1 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8863,7 +8863,7 @@ $DBversion = "3.17.00.030"; if ( CheckVersion($DBversion) ) { $dbh->do( q{ - INSERT INTO systempreferences (variable, value, options, explanation, type ) + INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type ) VALUES ('UsageStatsCountry', '', NULL, 'The country where your library is located, to be shown on the Hea Koha community website', 'YesNo'), ('UsageStatsID', '', NULL, 'This preference is part of Koha but it should not be deleted or updated manually.', 'Free'), -- 2.1.0