diff options
author | jnew-gh <github@hazelden.ca> | 2021-05-05 17:01:38 +0300 |
---|---|---|
committer | jnew-gh <github@hazelden.ca> | 2021-05-05 17:01:38 +0300 |
commit | d6411a5ee90b161a507d3adbcc008d15e8f0a7c3 (patch) | |
tree | fec28ea946cd4ab47124024afc0fc5d1c4efd7b4 | |
parent | f2cd6d117d65938f67e1557efb28f4830418d2eb (diff) |
Update SQL statement to fix SQL Error 1055
Remove (unneeded) columns from joined SELECT statement
Remove 2nd (unneeded) GROUP BY clause
-rw-r--r-- | dmarcts-report-viewer-report-list.php | 6 |
1 files changed, 0 insertions, 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" ) ; |