How to Disable Strict SQL Mode in MySQL 5.7

What is this error? “Database query failed: Data truncated for column ‘column_name’ at row 1

Your mysql might be running in strict mode. you need to disable it.
To disable strict SQL mode, SSH in to your server as root and create this file:

Open the file and enter these two lines:


Restart MySQL with this command: