Thanks Thomas! On Mon, Jun 19, 2017 at 3:55 PM Thomas Golding <[email protected]> wrote:
> 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 <(208)%20944-9624> > t.f.888.533.3551x14 <(888)%20533-3551> > > 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
