Skip to content

Fix: invalid value for 'gateway_timestamp' on install

MySQL server running a 5.7 or greater version with the NO_ZERO_DATE option and with explicit_defaults_for_timestamp disabled causes an error on install:

invalid value for 'gateway_timestamp'

Screenshot_2020-12-08_phpmyadmin-mysql_localhost_mysql_stc_civicrm_phpMyAdmin_5_0_1

The reason:

If the explicit_defaults_for_timestamp system variable is disabled, the first TIMESTAMP column has both DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP if neither is specified explicitly.

For the 2nd (and for the rest of) timestamp fields, MySQL assigns 0000-00-00 as default value, which turns out to be invalid if the server works with the NO_ZERO_DATE option.