From d6411a5ee90b161a507d3adbcc008d15e8f0a7c3 Mon Sep 17 00:00:00 2001
From: jnew-gh <github@hazelden.ca>
Date: Wed, 5 May 2021 10:01:38 -0400
Subject: Update SQL statement to fix SQL Error 1055

Remove (unneeded) columns from joined SELECT statement
Remove 2nd (unneeded) GROUP BY clause
---
 dmarcts-report-viewer-report-list.php | 6 ------
 1 file changed, 6 deletions(-)

diff --git a/dmarcts-report-viewer-report-list.php b/dmarcts-report-viewer-report-list.php
index 583e39d..1136af7 100644
--- a/dmarcts-report-viewer-report-list.php
+++ b/dmarcts-report-viewer-report-list.php
@@ -272,10 +272,6 @@ FROM
 			SELECT
 				SUM(rcount) AS rcount,
 				serial,
-				dkim_align,
-				spf_align,
-				dkimresult,
-				spfresult,
 				MIN(
 					(CASE
 						WHEN dkim_align = 'fail' THEN 0
@@ -345,8 +341,6 @@ FROM
 	ON
 		report.serial = rptrecord.serial
 $where
-GROUP BY
-	serial
 ORDER BY
     " . $cookie_options['sort_column'] . ( $cookie_options['sort'] ? " ASC" : " DESC" )
 ;
-- 
cgit v1.2.3