From 11bae489bc85a9463712c9caafd2caf7b63155d9 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 23 Nov 2016 14:47:10 +0000 Subject: [PATCH] Bug 17216: Fix SQL statement to setting marc_subfield_structure.authorised_value to NULL We want to update it if it's empty, not equal to ';' nopaste vim mode is to blame Signed-off-by: Kyle M Hall --- 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 336797270f..3a7c9b3638 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -13219,7 +13219,7 @@ if ( CheckVersion($DBversion) ) { }); $dbh->do(q{ - UPDATE marc_subfield_structure SET authorised_value = NULL WHERE authorised_value = ';'; + UPDATE marc_subfield_structure SET authorised_value = NULL WHERE authorised_value = ''; }); # If the DB has been created before 3.19.00.006, the default collate for marc_subfield_structure if not set to utf8_unicode_ci and the new FK will not be create (MariaDB or MySQL will raise err 150) -- 2.20.1