Attachment 124867 Details for Bug 24387 – Bug 24387: Entries with parent are missing a code

[patch] Bug 24387: Entries with parent are missing a code

Bug-24387-Entries-with-parent-are-missing-a-code.patch (text/plain), 1.38 KB, created by Jonathan Druart on 2021-09-14 17:27:21 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2021-09-14 17:27:21 UTC

Size: 1.38 KB

patch

obsolete

>From 4272f8c0dd65e24374e5baa099ac9bd920c97758 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Tue, 14 Sep 2021 19:26:32 +0200
>Subject: [PATCH] Bug 24387: Entries with parent are missing a code
>
>We executed the same 2 queries, we want to adjust the code for the
>parent and the language specific row.
>---
> installer/data/mysql/db_revs/210600016.pl | 4 ++--
> 1 file changed, 2 insertions(+), 2 deletions(-)
>
>diff --git a/installer/data/mysql/db_revs/210600016.pl b/installer/data/mysql/db_revs/210600016.pl
>index 05b05442509..8d66de86cbf 100755
>--- a/installer/data/mysql/db_revs/210600016.pl
>+++ b/installer/data/mysql/db_revs/210600016.pl
>@@ -132,8 +132,8 @@ return {
> 
>             my $idnew = $parent_idnew || $c->{idnew};
>             my $code = ( grep {$_ eq $location} qw( staff_and_opac staff_only opac_only slip ) ) ? "${location}_$idnew" : "News_$idnew";
>-            $dbh->do(q|UPDATE additional_contents SET code=? WHERE idnew = ?|, undef, $code, $idnew) if $parent_idnew;
>-            $dbh->do(q|UPDATE additional_contents SET code=? WHERE idnew = ?|, undef, $code, $idnew);
>+            $dbh->do(q|UPDATE additional_contents SET code=? WHERE idnew = ?|, undef, $code, $parent_idnew) if $parent_idnew;
>+            $dbh->do(q|UPDATE additional_contents SET code=? WHERE idnew = ?|, undef, $code, $c->{idnew});
>         }
> 
>         $dbh->do(q|
>-- 
>2.25.1

Actions: View | Diff | Splinter Review

Attachments on bug 24387: 122737 | 122738 | 122746 | 122748 | 122872 | 122873 | 122874 | 122878 | 122879 | 122880 | 123730 | 123731 | 123732 | 123733 | 123734 | 123795 | 123796 | 123797 | 123798 | 123803 | 123811 | 123854 | 123855 | 123856 | 124867 | 125545 | 142653