opendmarc-report issue using GROUP BY

[tuxtuxdm]

Hi,

it seems for mysql backend there is a problem with this query:

$dbi_s = $dbi_h->prepare("SELECT repuri, adkim, aspf, requests.policy, spolicy, pct, UNIX_TIMESTAMP(lastsent), domains.name FROM requests JOIN messages ON messages.from_domain=requests.domain LEFT JOIN domains ON messages.policy_
domain = domains.id WHERE domain = ? GROUP BY policy_domain");

See:

https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html

I've fixed it with:

445c445
<       $dbi_s = $dbi_h->prepare("SELECT repuri, adkim, aspf, requests.policy, spolicy, pct, UNIX_TIMESTAMP(lastsent), domains.name FROM requests JOIN messages ON messages.from_domain=requests.domain LEFT JOIN domains ON messages.policy_domain = domains.id WHERE domain = ? GROUP BY policy_domain,repuri,adkim,aspf,requests.policy,spolicy,pct,domains.name,lastsent");
---
>       $dbi_s = $dbi_h->prepare("SELECT repuri, adkim, aspf, requests.policy, spolicy, pct, UNIX_TIMESTAMP(lastsent), domains.name FROM requests JOIN messages ON messages.from_domain=requests.domain LEFT JOIN domains ON messages.policy_domain = domains.id WHERE domain = ? GROUP BY policy_domain");

Best regards,

Dani.