Attachment 110841 Details for Bug 26268 – Bug 26268: Remove invalid mappings from MARC frameworks when items.paidfor is removed

[patch] Bug 26268: Remove invalid mappings from MARC frameworks when items.paidfor is removed

Bug-26268-Remove-invalid-mappings-from-MARC-framew.patch (text/plain), 1.24 KB, created by Martin Renvoize (ashimema) on 2020-09-28 09:19:30 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2020-09-28 09:19:30 UTC

Size: 1.24 KB

patch

obsolete

>From 6e76178684b4f6bb4065d6dfadf1ad29abe813a1 Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <katrin.fischer.83@web.de>
>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 <katrin.fischer.83@web.de>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>---
> 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.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 26268: 108797 | 108799 | 108807 | 108808 | 108809 | 108810 | 108812 | 108813 | 108814 | 109674 | 109675 | 109676 | 109677 | 109930 | 109931 | 109932 | 109933 | 109934 | 110801 | 110802 | 110803 | 110804 | 110805 | 110806 | 110836 | 110837 | 110838 | 110839 | 110840 | 110841 | 110935