How to fix the «Invalid default value for 'updated_at'» MySQL 5.7 failire?

database
mysql

(Dmitry Fedyuk) #1

I have encountered this issue while installing demo data for the Magetique design theme:

01


(Dmitry Fedyuk) #2

Remove the NO_ZERO_DATE flag from the sql-mode option, and then restart the MySQL server.