I got this error on database:

IPS\Db\Exception: Field 'cache_sm' doesn't have a default value (1364)

Apache version: Apache/2.4.54

PHP version: 8.0.0 

MySQL version: 10.10.2-MariaDB

 

Thank you

Edited January 15, 20232 yr by xper

Your database is in strict mode, please contact your hosting provider to assist in resolving this. 

I'm on dedicated server.

17 minutes ago, xper said:

I'm on dedicated server.

I’m afraid, you would need to contact your server administrator for assistance as you would need to alter your MySQL configuration to disable strict mode. Server administration is outside our scope of support. 

sql_mode=NO_ENGINE_SUBSTITUTION

Added this line to /etc/my.cnf and it worked.

Thank you