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

[Juri Haberland]

On 24.06.2016 15:08, Robert at QuantumRadio wrote:
> I see that. I will add the switch to the my.cnf as the docs say that’s
> possible. or failing that, to the startup.

> However, having set the database default structure to that stated below.
> 
> Name         Type      Collation          Attributes         Null  Default
> lastsent       datetime                                               Yes  
> 1970-01-01 00.00.00
> 
> I would have thought it would be enough for it to now not to have
> 0000-00-00 00:00:00 in the table, but instead 1970-01-01 00.00.00
> 
> or I’m still missing something fundamental here.

That might help for new entries, but old ones should be fixed with a proper
SQL statement. And I currently have no idea whether we depend on that value
somewhere in the scripts. Needs to be checked...

> also, I’ve got an idea I’ve seen this reported as an issue sometime previously?

That might have been bug #143 which is a different thing but happening in
opendmarc-expire, too.


  Juri