How to disable strict_trans_tables

Community Support
1

Hello. Please, friends and experienced people, help me solve this problem. How can I disable strict_trans_tables.

Important!

The sql-mode strict_trans_tables is enabled in your mysql server, please contact your host provider to disable it.

1 Like
2

If you are running HestiaCP, you are the host provider!

Here is a link to the relevant MariaDB documentation.

1 Like
3

Add this line into /etc/mysql/my.cf in section [mysqld]

sql-mode="ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

And restart mysql:

systemctl restart mysqld

2 Likes
4

Yes, it now works successfully. Thank you for your reply and help.

2 Likes