Menu
I have just switched from a MAMP installation to a native Apache, MySql and PHP installation. I have got everything working, but I have 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?
500
Error 1364 indicates that the value of the particular field should be something other than NULL. One way to resolve the error forever is to make the column as DEFAULT NULL in table definition but if that does not meet your requirement, let us see some ways to fix this error in the below sections.
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.
95
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
