Showing posts with label SQLSTATE[HY000]: General error: 1364 Field doesn't have a default value. Show all posts
Showing posts with label SQLSTATE[HY000]: General error: 1364 Field doesn't have a default value. Show all posts

Monday, November 14, 2016

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

Solution :

Go on mysql prompt and run following command.


mysql> SET GLOBAL sql_mode=''

Make sure no value has been set for attribute sql_mode in the file my.cnf.