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

[Juri Haberland]

On 2016-06-24 08:48, Robert at QuantumRadio wrote:
> Since I updated MySql to 5.7, I’m getting this every night. What’s
> causing it. I can’t find it.
> 
> opendmarc-expire: started at Fri Jun 24 00:00:15 2016
> opendmarc-expire: connected to database
> opendmarc-expire: expiring messages older than 180 day(s)
> opendmarc-expire: expiring signatures on expired messages (id < 27)
> opendmarc-expire: expiring request data older than 180 days
> opendmarc-expire: DELETE failed: Incorrect datetime value: '0000-00-00
> 00:00:00' for column 'lastsent' at row 1
> opendmarc-expire: 26 row(s) deleted
> opendmarc-expire: no rows deleted

That might come from a change in your MySQL version. Have a look at
NO_ZERO_DATE
(http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_zero_date).


   Juri