Mailing List Archive

MySQL 5.7 / DATETIME: '000-00-00' problem (1)
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

_______________________________________________
mythtv-dev mailing list
mythtv-dev@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-dev
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org