Attachment 113311 Details for Bug 23019 – Bug 23019: (follow-up 2) set table name to import_batch_profiles

[patch] Bug 23019: (follow-up 2) set table name to import_batch_profiles

Bug-23019-follow-up-2-set-table-name-to-importbatc.patch (text/plain), 1.51 KB, created by Jonathan Druart on 2020-11-09 13:47:22 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2020-11-09 13:47:22 UTC

Size: 1.51 KB

patch

obsolete

>From b93e57124331ffd9bfee0fd17c6dcdb9341cfab8 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Mon, 9 Nov 2020 14:46:49 +0100
>Subject: [PATCH] Bug 23019: (follow-up 2) set table name to
> import_batch_profiles
>
>---
> C4/ImportBatch.pm | 4 ++--
> 1 file changed, 2 insertions(+), 2 deletions(-)
>
>diff --git a/C4/ImportBatch.pm b/C4/ImportBatch.pm
>index d9e617d2a7..6b15dbe69b 100644
>--- a/C4/ImportBatch.pm
>+++ b/C4/ImportBatch.pm
>@@ -265,7 +265,7 @@ sub GetImportBatch {
>     my ($batch_id) = @_;
> 
>     my $dbh = C4::Context->dbh;
>-    my $sth = $dbh->prepare_cached("SELECT b.*, p.name as profile FROM import_batches b LEFT JOIN import_batches_profile p ON p.id = b.profile_id WHERE import_batch_id = ?");
>+    my $sth = $dbh->prepare_cached("SELECT b.*, p.name as profile FROM import_batches b LEFT JOIN import_batch_profiles p ON p.id = b.profile_id WHERE import_batch_id = ?");
>     $sth->bind_param(1, $batch_id);
>     $sth->execute();
>     my $result = $sth->fetchrow_hashref;
>@@ -1024,7 +1024,7 @@ sub GetImportBatchRangeDesc {
> 
>     my $dbh = C4::Context->dbh;
>     my $query = "SELECT b.*, p.name as profile FROM import_batches b
>-                                    LEFT JOIN import_batches_profile p
>+                                    LEFT JOIN import_batch_profiles p
>                                     ON b.profile_id = p.id
>                                     WHERE b.batch_type IN ('batch', 'webservice')
>                                     ORDER BY b.import_batch_id DESC";
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 23019: 104972 | 104973 | 104974 | 104975 | 104976 | 105536 | 105537 | 105538 | 105539 | 105540 | 105541 | 105555 | 105600 | 105601 | 105602 | 105603 | 105604 | 106555 | 109265 | 109266 | 109637 | 112531 | 112532 | 112533 | 112534 | 112535 | 112536 | 112537 | 112715 | 112716 | 112717 | 112718 | 112719 | 112720 | 112721 | 112722 | 113276 | 113277 | 113311 | 113416 | 113421