Jump to content

Featured Replies

Posted

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 by xper

Solved by xper

Go to solution
  • Community Expert

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

  • Author

I'm on dedicated server.

  • Community Expert
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. 

  • Author
  • Solution
sql_mode=NO_ENGINE_SUBSTITUTION

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

Thank you

Recently Browsing 0

  • No registered users viewing this page.