[RSS Feed/News] Error code 1292 incorrect date value 0000-00-00 for date column

Status
Not open for further replies.

XenForo

Administrative
  • Thread starter
  • Admin
  • #1
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...

Read more

ادامه مطلب...
 
Status
Not open for further replies.
Back
Top Bottom