Remove MySql Strick Mode
I have installed MySql in my Mac OSx using home brew. However when I was going to execute query like below it iilll gives a error Query : `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', Error : #1067 - Invalid default value for 'comment_date' The reason is My Sql has been installed in Strict mode Where User could not do some database actions ,which are prmiited in old version. This article helps to remove strict mode permemtly as well as tempory : http://nickbartlett.com/how- to-turn-off-mysql-strict-mode/ Simply run the query with following in the begin SET @@global.sql_mode= ”;