Skip to content

MySQL: (42000) Invalid default value

David Verdin requested to merge github/fork/ikedas/issue-1028 into sympa-6.2

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) .

Merge request reports