After upgrading, i could no longer view dmarc reports. I traced commits and found out it's probally caused by commit 4c10b11, after which the bug occurs. Looking over the code, I can't for the life of me figure out what is causing this. Below you'll find debug info and the sql error. It would be great if you clould take a look at this!
D=
O=
DMARC=all
sql where =
(I prettified this to increase legibility)
Data List sql:
SELECT
report.*,
rcount,
dkim_align_min,
spf_align_min,
dkim_result_min,
spf_result_min,
dmarc_result_min,
dmarc_result_max
FROM
report
LEFT JOIN (
SELECT
SUM(rcount) AS rcount,
serial,
dkim_align,
spf_align,
dkimresult,
spfresult,
MIN(
(
CASE
WHEN dkim_align = 'fail' THEN 0
WHEN dkim_align = 'pass' THEN 2
ELSE 1
END
)
) AS dkim_align_min,
MIN(
(
CASE
WHEN spf_align = 'fail' THEN 0
WHEN spf_align = 'pass' THEN 2
ELSE 1
END
)
) AS spf_align_min,
MIN(
(
CASE
WHEN dkimresult = 'fail' THEN 0
WHEN dkimresult = 'pass' THEN 2
ELSE 1
END
)
) AS dkim_result_min,
MIN(
(
CASE
WHEN spfresult = 'fail' THEN 0
WHEN spfresult = 'pass' THEN 2
ELSE 1
END
)
) AS spf_result_min,
MIN(
(
CASE
WHEN dkim_align = 'fail' THEN 0
WHEN dkim_align = 'pass' THEN 1
ELSE 3
END
) + (
CASE
WHEN spf_align = 'fail' THEN 0
WHEN spf_align = 'pass' THEN 1
ELSE 3
END
)
) AS dmarc_result_min,
MAX(
(
CASE
WHEN dkim_align = 'fail' THEN 0
WHEN dkim_align = 'pass' THEN 1
ELSE 3
END
) + (
CASE
WHEN spf_align = 'fail' THEN 0
WHEN spf_align = 'pass' THEN 1
ELSE 3
END
)
) AS dmarc_result_max
FROM
rptrecord
GROUP BY
serial
) AS rptrecord ON report.serial = rptrecord.serial
GROUP BY
serial
ORDER BY
maxdate DESC