Turn Off MySQL Strict Mode

14 Aug 2013 http://nickbartlett.com/wordpress/how-to-turn-off-mysql-strict-mode/

SET @@global.sql_mode= ”; will set it temporarily. (to see if it will fix your problem)

To turn it off permanently, add this setting to your my.cnf (probably in /etc/mysql/my.cnf if you're using ubuntu): 

[mysqld]

sql-mode =

If you're having issues getting this setting to work in your my.cnf, look for another my.cnf in /opt/mysql/server-5.6/my.cnf or elsewhere on your system using the "find / -name 'my.cnf'" command.