From 7a2816edb146a3586a9754f0e6f3ca6c161bffd4 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Fri, 18 Sep 2015 12:34:45 -0300 Subject: [PATCH] Bug 14472: (QA followup) fix updatedatabase.pl for multiple ISSN rules If (for some reason) the user has created more than one matching rule with the 'ISSN' code, the updatedabase.pl script fails, because it was written with the default data in mind, and didn't consider the scenario described above. Thanks Liz for pointing this out! Signed-off-by: Tomas Cohen Arazi --- 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 caf4b4fc2c..6d02ff174c 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -10862,7 +10862,7 @@ if ( CheckVersion($DBversion) ) { $dbh->do(q{ UPDATE matchpoints SET search_index='issn' - WHERE matcher_id=(SELECT matcher_id FROM marc_matchers WHERE code = 'ISSN') + WHERE matcher_id IN (SELECT matcher_id FROM marc_matchers WHERE code = 'ISSN') }); print "Upgrade to $DBversion done (Bug 14472: Wrong ISSN search index in record matching rules)\n"; SetVersion($DBversion); -- 2.39.5