Please follow the under mentioned instructions to turn off the MySQL strict mode. Make the following changes in the "my.ini/my.cnf":
1. Look for the following line:
sql_mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
2. Change it to:
sql_mode=""
OR
sql_mode="NO_ENGINE_SUBSTITUTION"
3. Restart the MySQL service.
