The sql-mode STRICT_TRANS_TABLES is enabled in your mysql server, please contact your host provider to disable it (How to fix this error)

To disable the STRICT_TRANS_TABLES SQL mode on your server, you can follow these steps:

1. Access your server via SSH using your preferred terminal or SSH client.
2. Open the MySQL configuration file with a text editor, such as nano or vim. The file is typically located at /etc/mysql/my.cnf or /etc/mysql/mysql.conf.d/mysqld.cnf. For example, if using nano:

bash

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

3. Locate the [mysqld] section and look for the sql_mode line. If it’s not present, add it below the [mysqld] line. Modify the sql_mode line to remove STRICT_TRANS_TABLES:

ini

[mysqld]
sql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Make sure that the STRICT_TRANS_TABLES option is removed from the list of modes. If you want to keep other modes, separate them with commas.

4. Save the file and exit the text editor. For nano, press Ctrl + X, then Y, and finally Enter to save and exit.
5. Restart the MySQL server for the changes to take effect:

bash

sudo systemctl restart mysql

6. Verify that the STRICT_TRANS_TABLES mode is disabled by running the following command:

bash

mysql -u root -p -e "SELECT @@GLOBAL.sql_mode;"

Enter your MySQL root password when prompted. Check the output and ensure STRICT_TRANS_TABLES is no longer listed.

Now the STRICT_TRANS_TABLES SQL mode should be disabled.