Fred, Heads up for future:
https://mariadb.com/kb/en/mariadb/sql-mode/#strict-mode This is where the errors were coming from. Removal of strict mode fixed the problem. You may need to check out anywhere in the code an SQL statement assumes it will automatically convert to an acceptable value. More info in the link. That’s what I get for jumping to the bleeding edge MariaDB. Hope this saves someone else from this oddity in the future. Thanks, Thomas Golding Engineering Manager Edgewater Broadcasting > -----Original Message----- > From: Thomas Golding [mailto:thom...@worldradiolink.com] > Sent: Monday, June 12, 2017 1:45 PM > To: 'Fred Gleason'; 'USER DISCUSSION ABOUT THE RIVENDELL RADIO > AUTOMATION SYSTEM' > Subject: RE: [RDD] Incorrect date value: '' for column 'PURGE_DATE' > > From: rivendell-dev-boun...@lists.rivendellaudio.org [mailto:rivendell-dev- > boun...@lists.rivendellaudio.org] On Behalf Of Fred Gleason > Sent: Monday, June 12, 2017 12:46 PM > To: USER DISCUSSION ABOUT THE RIVENDELL RADIO AUTOMATION SYSTEM > Subject: Re: [RDD] Incorrect date value: '' for column 'PURGE_DATE' > > On Jun 12, 2017, at 14:20, Thomas Golding <thom...@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? > > > > RDLogManager spits this out on the command line during the “Create New > Log” task. It does appear to recreate the log’s contents successfully, but the > name and description of the log don’t get updated (obviously since that the > SQL statement that’s failing.) This started immediately after the MariaDB > upgrade. I’m not familiar with ‘Purge_Date’ since it’s not a feature we use. > Could this have been a side effect of converting MyISAM to InnoDB? > > Running RD Version 2.16.0 from Paravel repo on CentOS 6. > > Thanks, > > Thomas Golding > Engineering Manager > Edgewater Broadcasting _______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
