From 21d6252b1f8680dee66e49d9083e96e70c0554b1 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. 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 f2ce6ce3cd..a6316d7545 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8821,7 +8821,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.39.5