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

webbouk

Well-known member
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,
 
Back
Top Bottom