Release WatchedList - service to automatically save/restore watched state
#54
Hi schapplm,

I think I've found a bug in service.py at line 1112. At the moment it tries to stick a unix timestamp in to the DATETIME/TIMESTAMP field which causes the script to fail.

Changing:

Code:
sql = 'UPDATE movie_watched SET playCount = %s, lastplayed = %s, lastChange = FROM_UNIXTIME(%s) WHERE idMovieImdb LIKE %s'

To:

Code:
sql = 'UPDATE movie_watched SET playCount = %s, lastplayed = FROM_UNIXTIME(%s), lastChange = FROM_UNIXTIME(%s) WHERE idMovieImdb LIKE %s'

Stops the error and the row is updated correctly.

Thanks
TTTG
Reply
 
Thread Rating:
  • 3 Vote(s) - 5 Average


Messages In This Thread
RE: WatchedList - service to automatically save/restore watched state - by TTTG - 2015-05-07, 21:51


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