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

[Robert@QuantumRadio]

hmm.
Ok,
mysql> SHOW VARIABLES LIKE 'sql_mode';
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                                                                     |
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| sql_mode      | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+-------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)


So I have NO_ZERO_DATE set, but something in import/report/expire must be setting the 0 date into the database in the first place I think.

I’ve set the database - datetime NULL DEFAULT '1970-01-01’

But it doesn’t seem to make a difference.

So perhaps I should restart mysql without the NO_ZERO_DATE option set ? but that will cause it to fail if the opendmarc-reporting system tries to input a non-valid date
 Or should I find where it’s being input in the code?

thanks

> On 24 Jun 2016, at 09:17, Juri Haberland <juri at sapienti-sat.org> wrote:
> 
> 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
> _______________________________________________
> opendmarc-users mailing list
> opendmarc-users at trusteddomain.org
> http://www.trusteddomain.org/mailman/listinfo/opendmarc-users

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