Fred and fellow RDDev'ers, 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" Database connection failed: 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" Database connection restored. invalid SQL or failed DB connection[Field 'TIME_TYPE' doesn't have a default value QMYSQL3: Unable to execute query]: insert into `tue_LOG` set ID=552,COUNT=552,TYPE=5,SOURCE=3,TRANS_TYPE=1,LABEL="wed" Database connection failed: insert into `tue_LOG` set ID=552,COUNT=552,TYPE=5,SOURCE=3,TRANS_TYPE=1,LABEL="wed" Database connection restored. Rddbcheck says everything is ok. Also, all the other Rivendell components seem to be working fine. Do I have a corrupted database or is something just misconfigured? Is there an easy was to confirm the integrity of the database schema? Thanks for your thoughts, Thomas Golding Engineering Manager Edgewater Broadcasting _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
