Kodi Community Forum

Full Version: MySQL - Watch status table
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi All,

I have a show that gives some errors on his watch status.
For that reason I wanted to manually update the watch status on that show. The only problem, I can't find the field that holds the watched status data.

I searched with this reference http://wiki.xbmc.org/index.php?title=XBM...tvshowview (3.2.14) but the field C8 is not in use (null values).

Can someone direct me to the correct table?

Thanks in advance
I think (guess) it is http://wiki.xbmc.org/index.php?title=XBM...ases#files

playcount and lastplayed.
anvarit, i used to do this all the time. not because i have errors though. Thats peculiar and maybe indicative of other issues?
I have a script that bulk updates via NFOs and there is an advancedsetttings setting that will import it on library scanning.
NFOs have playcount as 1 for watched, and NULL (NOT 0) for unwatched. This Null vs 0 tripped me up in the past.