From 34f9604704fa76a9577a83d1f2d2b601d0010167 Mon Sep 17 00:00:00 2001
From: Nick Clemens <nick@bywatersolutions.com>
Date: Mon, 12 Aug 2024 12:10:12 +0000
Subject: [PATCH] Bug 37508: [23.11] Don't return Internal server error when
 running report

To test:
1 - Create a report like:
SELECT "a"
FROM borrowers
WHERE <<Test>> != ''
2 - Run report
3 - Enter "password"
4 - Internal server error / stacktrace
5 - Apply patch
6 - Repeat
7 - Get a yellow warning box

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
---
 reports/guided_reports.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/reports/guided_reports.pl b/reports/guided_reports.pl
index 85b42c4efbb..b8a99c0c8bd 100755
--- a/reports/guided_reports.pl
+++ b/reports/guided_reports.pl
@@ -852,7 +852,7 @@ elsif ($phase eq 'Run this report'){
             );
             my $total;
             if (!$sth) {
-                die "execute_query failed to return sth for report $report_id: $sql";
+                push @errors, "Report could not be run " . $errors;
             } elsif ( !$errors ) {
                 $total = nb_rows($sql) || 0;
                 my $headers = header_cell_loop($sth);
-- 
2.39.2