MySQL: (42000) Invalid default value
Created by: ikedas
MySQL: With MySQL 5.6, 5.7.6 and later versions, sql_mode
system variable contains STRICT_TRANS_TABLES
by which some obsoleted columns such as date_admin
causes "(42000) Invalid default value for 'column name'" error. Fixed by resetting sql_mode
to be empty, the default on 5.5.x or earlier.
This may fix #1028 (closed) .