Fred, "NOT NULL DEFAULT NULL" is not a legal combination in strict mode. Looks like the schema upgrade routine in 2.16 misses some strict mode issues. I didn’t notice before but this is exactly what I was running in to last week.
Nick, See https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-strict for info on how to turn off mysql strict mode. Thanks, Thomas Golding Engineering Manager Edgewater Broadcasting p.208.944.9624 t.f.888.533.3551x14 From: [email protected] [mailto:[email protected]] On Behalf Of Nick Andre Sent: Monday, June 19, 2017 2:35 PM To: rivendellDev Subject: [RDD] Ubuntu 16.04 w/ 2.16.0 Log Generation Errors We're getting some MySQL errors when we create the log through the command line interface related to database schema. Rivendell 2.16.0 with Ubuntu 16.04 mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using EditLine wrapper Running: /usr/local/bin/rdlogmanager -g -m -s Automation -d 0 The result is: invalid SQL or failed DB connection[Field 'TIME_TYPE' doesn't have a default value QMYSQL3: Unable to execute query]: insert into `2017_06_20_LOG` set ID=816,COUNT=816,TYPE=5,SOURCE=3,TRANS_TYPE=1,LABEL="2017_06_21" rdlogmanager: invalid SQL or failed DB connection[Field 'TIME_TYPE' doesn't have a default value QMYSQL3: Unable to execute query]: insert into `2017_06_20_LOG` set ID=816,COUNT=816,TYPE=5,SOURCE=3,TRANS_TYPE=1,LABEL="2017_06_21" Database connection failed: insert into `2017_06_20_LOG` set ID=816,COUNT=816,TYPE=5,SOURCE=3,TRANS_TYPE=1,LABEL="2017_06_21" Database connection restored. Rivendell Log Exception Report Generated at: 06/19/2017 - 15:00:46 Log: 2017_06_20 Effective Airdate: 06/20/2017 0 exceptions found. mysql> desc 2017_06_20_LOG; +-------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+-------+ | ID | int(11) | NO | PRI | NULL | | | COUNT | int(11) | NO | MUL | NULL | | | TYPE | int(11) | YES | | 0 | | | SOURCE | int(11) | NO | | NULL | | | START_TIME | int(11) | YES | | NULL | | | GRACE_TIME | int(11) | YES | | 0 | | | CART_NUMBER | int(10) unsigned | NO | MUL | 0 | | | TIME_TYPE | int(11) | NO | | NULL | | | POST_POINT | enum('N','Y') | YES | | N | | | TRANS_TYPE | int(11) | NO | | NULL | | | START_POINT | int(11) | NO | | -1 | | | END_POINT | int(11) | NO | | -1 | | | FADEUP_POINT | int(11) | YES | | -1 | | | FADEUP_GAIN | int(11) | YES | | -3000 | | | FADEDOWN_POINT | int(11) | YES | | -1 | | | FADEDOWN_GAIN | int(11) | YES | | -3000 | | | SEGUE_START_POINT | int(11) | NO | | -1 | | | SEGUE_END_POINT | int(11) | NO | | -1 | | | SEGUE_GAIN | int(11) | YES | | -3000 | | | DUCK_UP_GAIN | int(11) | YES | | 0 | | | DUCK_DOWN_GAIN | int(11) | YES | | 0 | | | COMMENT | char(255) | YES | | NULL | | | LABEL | char(64) | YES | MUL | NULL | | | ORIGIN_USER | char(255) | YES | | NULL | | | ORIGIN_DATETIME | datetime | YES | | NULL | | | EVENT_LENGTH | int(11) | YES | | -1 | | | LINK_EVENT_NAME | char(64) | YES | | NULL | | | LINK_START_TIME | int(11) | YES | | NULL | | | LINK_LENGTH | int(11) | YES | | 0 | | | LINK_START_SLOP | int(11) | YES | | 0 | | | LINK_END_SLOP | int(11) | YES | | 0 | | | LINK_ID | int(11) | YES | | -1 | | | LINK_EMBEDDED | enum('N','Y') | YES | | N | | | EXT_START_TIME | time | YES | | NULL | | | EXT_LENGTH | int(11) | YES | | NULL | | | EXT_CART_NAME | char(32) | YES | | NULL | | | EXT_DATA | char(32) | YES | | NULL | | | EXT_EVENT_ID | char(32) | YES | | NULL | | | EXT_ANNC_TYPE | char(8) | YES | | NULL | | +-------------------+------------------+------+-----+---------+-------+ 39 rows in set (0.00 sec) _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
