Describe the bug
Sometime domains appear duplicated in the record overview.
The reason is that the policy (report_stats.policy_pct) column is sometimes NULL, while the same domain has another value in another report (e.g. NULL and 100%).
To Reproduce
No idea.
Probably multiple reports come in, and some report contains 100%, and another report contains no value for it.
- 4 Organizations in my database have
policy_pct = NULL values in their reports: GMX, mail.com, mx-cix.de, web.de
- 135 others have non-null values
Expected behavior
No duplicate domain rows in the UI.
Screenshots

Software Version
Open-DMARC-Analyzer version-1
Desktop:
- OS: Debian 13
- Browser: Firefox
- Version: 148
Server (please complete the following information):
- Server OS: Debian 13
- Web Server: Apache 2.4.66-1~deb13u1
- PHP Version: 8.5
- SQL Variant and Version: MariaDB 11.8.3-0+deb13u1
Describe the bug
Sometime domains appear duplicated in the record overview.
The reason is that the policy (
report_stats.policy_pct) column is sometimes NULL, while the same domain has another value in another report (e.g. NULL and 100%).To Reproduce
No idea.
Probably multiple reports come in, and some report contains 100%, and another report contains no value for it.
policy_pct = NULLvalues in their reports: GMX, mail.com, mx-cix.de, web.deExpected behavior
No duplicate domain rows in the UI.
Screenshots

Software Version
Open-DMARC-Analyzer version-1
Desktop:
Server (please complete the following information):