From: Kirill Miazine <km@krot.org>
Date: Fri, 25 Nov 2022 00:25:04 +0000 (+0000)
Subject: Fix multiple lines returned for animal on status page
X-Git-Url: https://git.exim.org/buildfarm-server.git/commitdiff_plain/eeed09128907bc26722a409f6fd4a14cf01bb046

Fix multiple lines returned for animal on status page
---

diff --git a/cgi-bin/show_status.pl b/cgi-bin/show_status.pl
index d14644c..d52394f 100755
--- a/cgi-bin/show_status.pl
+++ b/cgi-bin/show_status.pl
@@ -52,7 +52,9 @@ my $statement =<<EOS;
 	b.*,
 	s.log_text
   FROM dashboard_mat b LEFT JOIN build_status_log s
-  ON b.snapshot = s.snapshot AND s.log_stage = 'test-results.log'
+  ON    b.sysname = s.sysname
+    AND b.snapshot = s.snapshot
+    AND s.log_stage = 'test-results.log'
   ORDER BY b.branch = 'master' desc,
         b.branch desc, $sort_clause 
         b.snapshot desc