Attachment 65257 Details for Bug 18931 – Bug 18931 - Follow up - Typo fix in SQL statement

[patch] Bug 18931 - Follow up - Typo fix in SQL statement

Bug-18931---Follow-up---Typo-fix-in-SQL-statement.patch (text/plain), 1.39 KB, created by Tomás Cohen Arazi (tcohen) on 2017-07-25 17:41:07 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2017-07-25 17:41:07 UTC

Size: 1.39 KB

patch

obsolete

>From ee19c4c60aaf890d184ae5578a77b1281ea7e00b 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.
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>---
> about.pl | 4 ++--
> 1 file changed, 2 insertions(+), 2 deletions(-)
>
>diff --git a/about.pl b/about.pl
>index f7f3ce3..7e54fd1 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.7.4

Actions: View | Diff | Splinter Review

Attachments on bug 18931: 65010 | 65157 | 65188 | 65189 | 65209 | 65210 | 65211 | 65212 | 65255 | 65256 | 65257 | 65258 | 65259 | 65260 | 65266 | 65267 | 65299