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
