From 5d2f51f9ad9ec5f46cc7a5ef2264ad9c5a188199 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Joonas=20Kylm=C3=A4l=C3=A4?= <joonas.kylmala@iki.fi>
Date: Sat, 6 Nov 2021 14:16:38 +0000
Subject: [PATCH] Bug 29204: (QA follow-up) Fix variable name
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

The patch "Bug 29204: Fix reports/issues_stats.pl for MySQL 8"
accidentally changed the variable name from $strsth2 to $strsth

Signed-off-by: Joonas Kylmälä <joonas.kylmala@iki.fi>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
---
 reports/issues_stats.pl | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/reports/issues_stats.pl b/reports/issues_stats.pl
index c7a6322449..3e59041743 100755
--- a/reports/issues_stats.pl
+++ b/reports/issues_stats.pl
@@ -409,8 +409,8 @@ sub calculate {
           ( $colsource eq 'items' )
           ? "LEFT JOIN items ON (statistics.itemnumber = items.itemnumber) "
           : "LEFT JOIN borrowers ON (statistics.borrowernumber = borrowers.borrowernumber) ";
-        $strsth .= " WHERE $column IS NOT NULL";
-        $strsth .= " AND $column != '' " if $column ne "datetime";
+        $strsth2 .= " WHERE $column IS NOT NULL";
+        $strsth2 .= " AND $column != '' " if $column ne "datetime";
     }
 
     if ( $column =~ /datetime/ ) {
-- 
2.39.5