[opendmarc-users] Bug in opendmarc-expire script

Murray S. Kucherawy msk at blackops.org
Thu Aug 9 22:46:44 PDT 2012


On Thu, 9 Aug 2012, Todd Lyons wrote:
> Since lastsent starts at zero, it always matches it.  Changing the
> query to exclude values of 0 fixes it:
>
> mysql> SELECT * FROM requests WHERE lastsent <=
> DATE_SUB(CURRENT_TIMESTAMP(), INTERVAL 180 DAY) AND lastsent > 0;
> Empty set (0.00 sec)

Also fixed for next release.  Thanks!

-MSK


More information about the opendmarc-users mailing list