From a50c2d355933ea1f8e7a5e2f96c8f185ebbc70df Mon Sep 17 00:00:00 2001
From: Katrin Fischer <katrin.fischer.83@web.de>
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.
---
about.pl | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/about.pl b/about.pl
index 1e7bd8f..5fcf94a 100755
--- a/about.pl
+++ b/about.pl
@@ -297,7 +297,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(
@@ -308,7 +308,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.7.4