Ben Thompson Ben Thompson - 4 months ago 30
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?


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.