[opendmarc-users] DELETE failed error. What is causing this?

Robert@QuantumRadio robert at quantum-radio.net
Fri Jun 24 06:18:03 PDT 2016


Following up,
I opted to change this line in opendmarc-expire to

$dbi_s = $dbi_h->prepare("DELETE FROM requests WHERE lastsent <= DATE_SUB(CURRENT_TIMESTAMP(), INTERVAL ? DAY) AND NOT lastsent = '1970-01-01 00:00:00'”);


I note too that the last six 0’s (zeros) have : between them, and not my previous 00.00.00

This should allow me to run MySql without the switches - which may break something else.?

Robert


> On 24 Jun 2016, at 14:08, Robert at QuantumRadio <robert at quantum-radio.net> wrote:
> 
> 1970-01-01 00.00.00

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.trusteddomain.org/pipermail/opendmarc-users/attachments/20160624/05e83442/attachment-0001.htm>


More information about the opendmarc-users mailing list