Original my.cnf had sql_model set as follows: sql_mode=STRICT_TRANS_TABLES,ALLOW_INVALID_DATE,ERROR_FOR_DIVISION_BY_ZERO …etc Remove STRICT_TRANS_TABLES and restart service, it will allow to use empty values in date fields on use ” ALLOW_INVALID_DATE ” seems not enough to eliminate error message.