How to fix mysql error – Field doesn’t have a default values

Remove STRICT_TRANS_TABLES from sql_mode variable and run SQL Query

set GLOBAL sql_mode='
ONLY_FULL_GROUP_BY,
NO_ZERO_IN_DATE,
NO_ZERO_DATE,
ERROR_FOR_DIVISION_BY_ZERO,
NO_AUTO_CREATE_USER,
NO_ENGINE_SUBSTITUTION,
STRICT_TRANS_TABLES'