From 735d154cbb81d9b5ad8135a4d5a200af1602479e 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 Content-Type: text/plain; charset="utf-8" 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 --- 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 0592a94..4e5fc9c 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'), -- 1.7.10.4