From aa36a4c22f81d2d20fb862baf09cd4121f82afb2 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 9 Nov 2020 14:46:49 +0100 Subject: [PATCH] Bug 23019: (follow-up 2) set table name to import_batch_profiles Signed-off-by: Jonathan Druart --- 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.39.5