[RDD] Incorrect date value: '' for column 'PURGE_DATE'

Fred Gleason fredg at paravelsystems.com
Mon Jun 12 14:46:22 EDT 2017


On Jun 12, 2017, at 14:20, Thomas Golding <thomasg at worldradiolink.com> wrote:

> After upgrading mysql to mariadb 10.2 with Galera clustering enabled, I'm
> getting this from RDLogManager:
> 
> invalid SQL or failed DB connection[Incorrect date value: '' for column
> 'PURGE_DATE' at row 1 QMYSQL3: Unable to execute query]: update LOGS set
> SERVICE="RadioTraff",                           DESCRIPTION="RadioTraff\
> log\ for\ 06/13/2017",ORIGIN_USER="RDLogManager",
> ORIGIN_DATETIME=now(),LINK_DATETIME=now(),
> MODIFIED_DATETIME=now(),START_DATE=null,
> END_DATE=null,NEXT_ID=0,PURGE_DATE="" where NAME="tue"

Looks like it’s balking at the empty date field.  What exactly are you doing that provokes this?

Cheers!


|----------------------------------------------------------------------|
| Frederick F. Gleason, Jr. |              Chief Developer             |
|                           |              Paravel Systems             |
|----------------------------------------------------------------------|
|          A room without books is like a body without a soul.         |
|                                         -- Cicero                    |
|----------------------------------------------------------------------|
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20170612/57c26bfa/attachment.html>


More information about the Rivendell-dev mailing list