Repository navigation
[Bug]: Duplicate domains in report #112
Description
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 = NULLvalues 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
Activity
cweiske commentedon Mar 13, 2026
My DMARC DNS enty does not contain a
pctvalue, so the default of 100% applies:The reports are stored with a value of NULL in the database, so we have the problem here.
One solution would be to cast NULL sampling rate values (
pct) to 100 during import via https://github.com/userjack6880/Open-Report-Parser.Another one would be modifying the
report_statsview to see NULL values as 100.cweiske commentedon May 13, 2026
Maybe
report-parser.pl: