2017-09-20, 14:22
(2017-09-20, 12:29)schapplm Wrote: Can you enable debug logging and provide the log messages in kodi.log?
These are the error messages that I have extracted from kodi.log:
22:12:25.903 T:9612 NOTICE: service.watchedlist: write_wl_wdata: MySQL Database error (1292 (22007): Incorrect datetime value: '1970-01-01 11:00:00' for column 'lastPlayed' at row 160) while updating episode Professor T. S01E07
22:12:25.903 T:9612 NOTICE: service.watchedlist: Notification. Watchedlist: Error: Writing the WL-database file (1292 (22007): Incorrect datetime value: '1970-01-01 11:00:00' for column 'lastPlayed' at row 160)
I can provide a more comprehensive log file if needed.
EDIT: I was able to resolve the issue, at least with a workaround, by disabling strict mode in MySQL. Apparently strict mode is now implemented by default in MySQL Server 5.7. Disabling strict mode involved removing STRICT_TRANS_TABLES from the line
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" in my.ini
