2016-07-28, 11:28
(2016-06-28, 14:43)BigMong Wrote: @Sushi7
I spotted that error and I have tested the manually running the SQL
it's strange that it works when your watch an episode but that is calling a different SQL string
After a few mins looking at the source on GitHub https://github.com/xbmc/xbmc
In the /xbmc/video/VideoDatabase.cpp file, line 5155 I believe is the SQL that is Prepared
Code:if (!date.IsValid())
strSQL = PrepareSQL("update files set playCount=NULL,lastPlayed=NULL where idFile=%i", id);
else
strSQL = PrepareSQL("update files set playCount=NULL,lastPlayed='%s' where idFile=%i", date.GetAsDBDateTime().c_str(), id);
}
I will setup my 16.1 Kodi again and do some testing over the weekend
Have you made any progress??