[mcfang]

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

I was testing MySQL 5.7 with Kodi 16.1 and received this same error when attempting to mark an item as Watched/Unwatched and I was also able to confirm that running the SQL query manually does work on the database.

This led me to the conclusion that there was something at runtime that was determining if this query would work or fail - and the answer is in the view updatability information.

For the view to be updatable it must use the MERGE algorithm, but unless you have specified this when you created the view it will be using the UNDEFINED algorithm. When using UNDEFINED MySQL will choose the algorithm at runtime and (for reasons I haven't delved into) sometimes chooses an algorithm which is NOT updatable.

tl;dr: you need to specify the MERGE algorithm for your files view.

Notes: in the example below `MyVideos99` is your database and 'kodi' is your MySQL user.

Code:

CREATE OR REPLACE
   ALGORITHM = MERGE
   DEFINER = `kodi`@`%`
   SQL SECURITY DEFINER
VIEW `MyVideos99`.`files` AS    
SELECT  idFile, idPath, strFilename, playCount0 AS playCount, lastPlayed0 AS lastPlayed, dateAdded
FROM `MyVideos99`.`globalfiles`;