Ben Thompson Ben Thompson - 1 year ago 147
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 Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download