Error code 1292 incorrect date value 0000-00-00 for date column

[webbouk]

I have updated MYSQL to 8.0. from 5.7. and Xenforo works fine with no issues, however I have some older software on the server that doesn't like the change and hence threw up the error: Error code 1292 incorrect date value 0000-00-00 for date column when trying to access it.

Going onto the server and running SET GLOBAL sql_mode = '' in phpMyAdmin resolves the issue, but if I restart MySql the change is lost and I need to run it again.
Is there a way of making the change permanent?

Thanks,

 

[digitalpoint]

You can set the sql_mode in your my.cnf file…

[mysqld]
sql_mode=""

 

[webbouk]

Thanks @digitalpoint - done