Database errors

Adrien

Hi fellow members. Could you do me a favor and check if you too have your website DB throwing errors?

All my DB of all my sites are throwing Invalid default value, Incorrect datetime value and other errors.

To reproduce:

Connect to phpMyAdmin of any of your sites. Then select all tables and click "Optimize Tables".
The report will then show all the errors.

Thank you.

Darren

Are you running MySQL in strict mode (which it will be by default if you're not specifying it in the my.cnf)? Generally speaking for production shared hosting I'd recommend the following:-

sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

You can adjust this under Settings -> Service -> Database for your entire Enhance estate or on a per database server basis under Servers -> Database role -> Settings

Adrien

Darren Hello Darren. Thanks a lot for your help! This solved my issue and hid the errors.

Do you have any other good recommendations/commands you add to my.cnf?
I'm hosting WP site only on LSWE.