[mythtv] MySQL 5.7 / DATETIME: '000-00-00' problem (1)

Angela angela.schmid at wolke7.net
Sun Mar 10 17:46:20 UTC 2019


Installed a new Ubuntu 18.04 server, using unchanged Mythtv 29.0-fixes.
mysql-server, 5.7.25-0ubuntu0.18.04.2

I make frequently a dump of videometadata in a table with the same layout
and encountered the following error:

Incorrect date value: '0000-00-00' for column 'releasedate'

Since mysql 5.7 Datetime does not allow '000-00-00' to be set.

This could be fixed with removing
STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE from sql_mode in mysqld
settings.

Instead of removing/ignoring warnings/errors, will Mythtv correctly set NULL
values instead of '000-00-00' in the future? Is this addressed?

Cheers
Angela



More information about the mythtv-dev mailing list