Turn Off MySQL Strict Mode
Reference: MySQL: Server SQL Modes
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.