From b74c4e7c76b1458355c3bc819ae7e9db25602530 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 --- 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 9b77f8d..e54bb8e 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -13169,7 +13169,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 = ''; }); $dbh->do(q{ -- 2.1.4