You getting this error STRICT_TRANS_TABLES mode. You updated the MySQL version or using MySQL 5.7.5 version. The STRICT_TRANS_TABLES mode was added to the default SQL mode in MySQL 5.7.5.
You can either disable STRICT_TRANS_TABLES mode in your database. This is enabled by default, but you can disable it.
First, you need to Root access of your server. we need to connect to MySQL because we are going to update the MySQL server Files. If you have Root access than open the putty and login into your server using putty.
After connecting with server, connect to MySQL using following command:
$ mysql -u root -p
Replace root with your database user name, Press enter and server asked you to enter the password. Enter correct password and connect to MYSQL server.
First, verify which mode(s) MYSQL is running with:
SHOW VARIABLES LIKE 'sql_mode';
This will print out something like:
sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
How To Disable Strict Mode via SQL:
You can disable strict mode on your MySQL server by running the following command:
SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';