From 602be8f106ef2e70ae27d62ab4f6f22b86fb1d1c Mon Sep 17 00:00:00 2001 From: Mason James Date: Wed, 8 Apr 2015 19:14:55 +1200 Subject: [PATCH] [PASSED QA] 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. Signed-off-by: Katrin Fischer --- 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 34c2d74..4196e07 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8868,7 +8868,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.9.1