Fix: mysql error 1364 Field doesn’t have a default values

In phpmyadmin, perform the following:

select @@GLOBAL.sql_mode

Copy this result and remove STRICT_TRANS_TABLES. Then perform the following:

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'

Leave a Reply

Your email address will not be published. Required fields are marked *