Resolve Invalid Date Errors

The MySQL server sql-mode setting affects the syntax MySQL supports and the data validation checks it performs. When sql-mode is set to STRICT_TRANS_TABLES, a statement is aborted and rolled back if an assigned value cannot be inserted into a transactional table. For a nontransactional table, the statement is aborted and rolled back if the value occurs in a single-row statement or the first row of a multiple-row statement.

By default, MySQL 5.7 is configured to work in strict sql-mode (STRICT_TRANS_TABLES). This mode prohibits the explicit use of a zero date (‘0000-00-00’) in any SQL statements. With strict mode enabled, invalid dates generate an error and no create or alter table statements are processed.

Problem

The Mertech drivers use the zero date as the default  DF_LOW value for the date data type.

Resolution

To resolve this issue, modify the my.ini file to delete the STRICT_TRANS_TABLES setting (shown in red below):

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Note: The MySQL Configuration Wizard places the my.ini  file in the MySQL server installation directory.