From a130a9c9e03a1acf5922f36fb6fa878316afb17d Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Fri, 25 Sep 2020 20:09:33 +0000 Subject: [PATCH] Bug 26268: Remove invalid mappings from MARC frameworks when items.paidfor is removed Signed-off-by: Katrin Fischer --- installer/data/mysql/atomicupdate/bug_26268.perl | 7 +------ 1 file changed, 1 insertion(+), 6 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_26268.perl b/installer/data/mysql/atomicupdate/bug_26268.perl index c45dc65ddf..152f10998d 100644 --- a/installer/data/mysql/atomicupdate/bug_26268.perl +++ b/installer/data/mysql/atomicupdate/bug_26268.perl @@ -14,12 +14,7 @@ if ( CheckVersion($DBversion) ) { } else { $dbh->do(q|ALTER TABLE items DROP COLUMN paidfor|); - $dbh->do(q| - DELETE FROM marc_subfield_structure - WHERE tagfield = '952' - AND tagsubfield = 'x' - AND kohafield = 'items.paidfor' - |); + $dbh->do(q|UPDATE marc_subfield_structure SET kohafield = '' WHERE kohafield = 'items.paidfor'|); } } -- 2.11.0