xper Posted January 15 Share Posted January 15 (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 by xper Link to comment Share on other sites More sharing options...
Jim M Posted January 15 Share Posted January 15 Your database is in strict mode, please contact your hosting provider to assist in resolving this. Link to comment Share on other sites More sharing options...
xper Posted January 15 Author Share Posted January 15 I'm on dedicated server. Link to comment Share on other sites More sharing options...
Jim M Posted January 15 Share Posted January 15 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. Link to comment Share on other sites More sharing options...
Solution xper Posted January 15 Author Solution Share Posted January 15 sql_mode=NO_ENGINE_SUBSTITUTION Added this line to /etc/my.cnf and it worked. Thank you AlexJ 1 Link to comment Share on other sites More sharing options...
Recommended Posts