From ff6b7192349558d684a1df3188acc29ffc8c9df4 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Mon, 24 Jul 2017 23:26:04 +0200 Subject: [PATCH] Bug 18931 - Follow up - Typo fix in SQL statement Fixes the table alias in the SQL statement for items and adds items to the if clause for showing data problems. Signed-off-by: Tomas Cohen Arazi Signed-off-by: Mason James --- about.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/about.pl b/about.pl index f7f3ce32f4..7e54fd1e94 100755 --- a/about.pl +++ b/about.pl @@ -268,7 +268,7 @@ if ( C4::Context->preference('WebBasedSelfCheck') { Slice => {} } ); my $items = $dbh->selectall_arrayref( - q|select i.itemnumber from items b join deleteditems di on i.itemnumber=di.itemnumber|, + q|select i.itemnumber from items i join deleteditems di on i.itemnumber=di.itemnumber|, { Slice => {} } ); my $checkouts = $dbh->selectall_arrayref( @@ -279,7 +279,7 @@ if ( C4::Context->preference('WebBasedSelfCheck') q|select r.reserve_id from reserves r join old_reserves o on r.reserve_id=o.reserve_id|, { Slice => {} } ); - if ( @$patrons or @$biblios or @$checkouts or @$holds ) { + if ( @$patrons or @$biblios or @$items or @$checkouts or @$holds ) { $template->param( has_ai_issues => 1, ai_patrons => $patrons, -- 2.39.5