2016-06-28, 13:24
MySQL 5.7 Windows
Kodi 16.1 Jarvis
Windows 10 Pro
Trying to mark or unmark Watched does not work but watching the Movie all the way through automatically marks as watched
MySQL states error 1288:
Error: 1288 SQLSTATE: HY000 (ER_NON_UPDATABLE_TABLE)
Message: The target table %s of the %s is not updatable
https://dev.mysql.com/doc/refman/5.5/en/...erver.html
I have also checked the IS_UPDATABLE column in the INFORMATION_SCHEMA.VIEWS table and it is set properly by default.
http://dev.mysql.com/doc/refman/5.7/en/v...ility.html
If I run the query manually directly in SQL on the View Files it works
Just not from within Kodi
Kodi 16.1 Jarvis
Windows 10 Pro
Trying to mark or unmark Watched does not work but watching the Movie all the way through automatically marks as watched
MySQL states error 1288:
Error: 1288 SQLSTATE: HY000 (ER_NON_UPDATABLE_TABLE)
Message: The target table %s of the %s is not updatable
https://dev.mysql.com/doc/refman/5.5/en/...erver.html
I have also checked the IS_UPDATABLE column in the INFORMATION_SCHEMA.VIEWS table and it is set properly by default.
http://dev.mysql.com/doc/refman/5.7/en/v...ility.html
If I run the query manually directly in SQL on the View Files it works
Code:
update files set playCount=NULL,lastPlayed=NULL where idFile=2
Just not from within Kodi