Ben Thompson Ben Thompson - 9 days ago 5
MySQL Question

MySql Error: 1364 Field 'display_name' doesnt have default value

I have just switched from a MAMP installation to a native Apache, MySql and PHP installation. I have got everything working, but I hve started using my web app in the new environment and suddenly any INSERT commands are resulting in the following error:


SQLSTATE[HY000]: General error: 1364 Field 'display_name' doesn't have a default value


It seems the I am unable to leave a field blank now where I was able to before. I am using MySql version 5.6.13

Is there a way to change this setting in MySql?

Answer

MySQL is most likely in STRICT mode. Try running SET GLOBAL sql_mode='' or edit your my.cnf to make sure you aren't setting STRICT_ALL_TABLES or the like.