How to Disable Strict SQL Mode in MySQL 5.7zalam
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:
sudo service mysql restart