Release WatchedList - service to automatically save/restore watched state
(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
Reply
 
Thread Rating:
  • 3 Vote(s) - 5 Average


Messages In This Thread
RE: WatchedList - service to automatically save/restore watched state - by raymondjpg - 2017-09-20, 14:22


Logout Mark Read Team Forum Stats Members Help
WatchedList - service to automatically save/restore watched state53