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