Please follow the instructions that are given below in order to turn off the MySQL Strict Mode.
NOTE: Make the following changes in the my.ini (for Windows Operating System) or my.cnf (for Linux Operating System):
Article ID: 163
Created: Tue, Mar 14, 2017
Last Updated: Tue, Mar 14, 2017
Author: Palwinder Singh
Online URL: https://www.knowledgebase-script.com/kb/article/how-do-i-disable-strict-mode-in-mysql-163.html