Generic selectors
Exact matches only
Search in title
Search in content
Search in project

Database Issue

If You are experiencing error “1067 Invalid default value for…” then most likely You are using MySQL 5.7 or newer with Atavism 2018.1.3 or older. It’s related to default timestamp fields value, which is set to “0000-00-00 00:00:00” but newer version MySQL allows to use minimal date since 1970y. In that case, try to execute this statement which should allow using invalid dates.

SET SQL_MODE=’ALLOW_INVALID_DATES’;

or put or replace that line into /etc/my.cnf config file under [mysqld] section

sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION