xper Posted January 15, 2023 Posted January 15, 2023 (edited) 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, 2023 by xper
Jim M Posted January 15, 2023 Posted January 15, 2023 Your database is in strict mode, please contact your hosting provider to assist in resolving this.
Jim M Posted January 15, 2023 Posted January 15, 2023 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.
Solution xper Posted January 15, 2023 Author Solution Posted January 15, 2023 sql_mode=NO_ENGINE_SUBSTITUTION Added this line to /etc/my.cnf and it worked. Thank you AlexJ 1
Recommended Posts