• 1
  • 13
  • 14
  • 15(current)
  • 16
  • 17
  • 35
Release WatchedList - service to automatically save/restore watched state
Thanks, will look into that!
* MikroTik RB5009UG+S+IN :: ZyXEL GS1900-8HP v1 :: EAP615-Wall v1 :: Netgear GS108T v3 running OpenWrt 23.05
* LibreELEC 11:  HTPC Gigabyte Brix GB-BXA8-5545 with CEC adapter, Sony XR-64A84K :: Desktop AMD Ryzen 7 5800X / Sapphire Nitro+ Radeon 6700XT  / 27" Dell U2717D QHD
* Debian Bookworm x86_64: Celeron G1610, NFS/MariaDB/ZFS server
* Blog
Reply
My exported database is empty. Just shows the structure of the db, no data. When I manually run the script it says "could not read the kodi database". How to fix this?
Reply
Dear All
After upgrade to Kodi krypton I have these messages:
TV Show “xxxxx” (ID xxx) has no imdb-number...
I checked the dB and the numbers are there and correct
Is this corrigible ? Thank you.
Reply
So tell me if I'm wrong:

If I autorun this on every kodi startup on different devices with Dropbox sync function, this will automatically change the status of watched movies/tv NO MATTER of what library I have on, right?
Reply
That's the plan

Heads up though, Dropbox is broken but we're fixing it.

Sent from my ONE A2005
Reply
thanks a lot
Reply
Been using watchedlist for a while now and i'm setup using mysql.
This is the first time i've actually had to try and restore....basically had to do a fresh reinstall of kodi.

I have watchlisted installed.  Once set it back to mysql, I run it.
It shows updating but none of the tvshows or movies are getting the watch status checkboxes updated.

I checked the sql tables and they show all the data is there.
Checking the kodi logs for anything relating to watchedlist...but nothing listed in there.

Any help would be appreciated!

Thanks
Urlryn
Reply
(2017-12-01, 04:29)Urlryn Wrote: Been using watchedlist for a while now and i'm setup using mysql.
...
 Can you provide your addon settings (e.g. of .kodi/userdata/addon_data/service.watchedlist/settings.xml)? Then set Kodi to debug logging, set the debug options in the watchedlist addon as well and please provide the log lines related to watchedlist after starting the addon manually.
Reply
Ok here is the snippit of the kodi debug log.
I enabled debug ... then ran watchedlist manually.

Though I do see requests like "Get all movies from xbmc database"...but nothing about mysql.

I couldn't find a settings.xml in the folder .kodi/userdata/addon_data/service.watchedlist.
There was one under .kodi/userdata/addon_data/service.watchedlist/resources...so i'm using that.
Edited the ip/password...

Code:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<settings>
    <category label="30001">
        <setting id="w_movies" type="bool" label="30011" default="true" />
        <setting id="w_episodes" type="bool" label="30012" default="true" />
        <setting id="autostart" type="bool" label="30021" default="false" />
        <setting id="delay" type="slider" label="30015" default="5" range="0,5,60" option="int" enable="eq(-1,true)" />
        <!-- starttype: no, one, periodic update -->
        <setting id="starttype" type="enum" label="30013" lvalues="30030|30031|30032" default="0" enable="eq(-2,true)" />
        <setting id="interval" type="slider" label="30014" default="24" range="3,3,96" option="int" enable="eq(-1,2)+eq(-3,true)" />
        <setting id="watch_user" type="bool" label="30022" default="true" enable="eq(-4,true)" />
        <setting id="progressdialog" type="bool" label="30016" default="true" />
        <setting id="verbosity" type="enum" label="30024" lvalues="30025|30026|30027|30028|30029" default="1" />
    </category>

    <category label="30002">
        <setting id="db_format" type="enum" label="30040" lvalues="30041|30042" default="0" />
        <!-- File Database Options (first option in db_format) -->
        <!--<setting label="30043" type="lsep"/>-->
        <setting id="extdb" type="bool" label="30017" default="false" enable="eq(-1,0)" />
        <setting id="dbpath" type="folder" label="30018" default="" enable="eq(-1,true)+eq(-2,0)" />
        <setting id="dbfilename" type="text" label="30019" default="watchedlist.db" enable="eq(-2,true)+eq(-3,0)" />
        <setting id="dbbackupcount" type="slider" label="30020" default="-1" range="-1,1,5" option="int"  enable="eq(-4,0)" />
        <!-- Call the Dropbox Authorization script: Give the Dropbox app kex and the "secret" key. The script will write the authorization code to this field with the provided addon information -->
        <setting id="dropbox_enabled" type="bool" label="30045" default="false" />
    <setting id="dropbox_apikey" type="action" label="30023" action="RunScript(script.module.dropbox, service.watchedlist, dropbox_apikey, bhd2v8hgsmqwcgt, t2cepoevjqyubnd)" enable="eq(-1,true)" />

        <!-- MySQL Database Options (second option in db_format)-->
        <!--<setting label="30044" type="lsep"/>-->
        <setting id="mysql_server" type="text" label="30051" default="xxx.xxx.xxx.xxx" enable="eq(-7,1)" />
        <setting id="mysql_port" type="number" label="30055" default="3306" enable="eq(-8,1)" />
        <setting id="mysql_db" type="text" label="30052" default="WatchedList" enable="eq(-9,1)" />
        <setting id="mysql_user" type="text" label="30053" default="xxxxxxx" enable="eq(-10,1)" />
        <setting id="mysql_pass" type="text" label="30054" default="xxxxxxx" enable="eq(-11,1)" />
    </category>
</settings>

Code:

06:25:54.609 T:139774576801536  NOTICE: service.watchedlist: WatchedList Database Service starting...
06:25:54.610 T:139774576801536  NOTICE: service.watchedlist: Notification. WatchedList: begin update in 5 minutes
06:27:26.287 T:139775056635584  NOTICE: Samba is idle. Closing the remaining connections
06:30:55.943 T:139774576801536  NOTICE: service.watchedlist: Notification. WatchedList: running observation of changes of watched states
06:41:50.643 T:139775037691648   ERROR: GetDirectory - Error getting videodb://tvshows/extrafanart/
06:42:25.951 T:139775056635584   ERROR: Previous line repeats 2 times.
06:42:25.951 T:139775056635584  NOTICE: Log level changed to "LOG_LEVEL_DEBUG_FREEMEM"
06:42:25.951 T:139775056635584  NOTICE: Enabled debug logging due to GUI setting. Level 2.
06:42:25.951 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x0000, modifier: 0x0
06:42:25.952 T:139775056635584   DEBUG: ------ Window Init () ------
06:42:26.232 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 23)
06:42:26.232 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:26.237 T:139774576801536   DEBUG: RunQuery took 2 ms for 46 items query: SELECT * FROM tvshow_view
06:42:26.242 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:26.245 T:139774576801536   DEBUG: RunQuery took 1 ms for 225 items query: select * from movie_view
06:42:26.275 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:42:26.291 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:42:30.785 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:30.785 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:42:30.985 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:31.561 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 24)
06:42:31.561 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:31.565 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:42:31.570 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:31.573 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:42:31.585 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:31.585 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:42:31.619 T:139774576801536   DEBUG: RunQuery took 15 ms for 2286 items query: select * from episode_view
06:42:31.751 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:33.435 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:42:33.435 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:42:33.635 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:33.884 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 25)
06:42:33.884 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:33.889 T:139774576801536   DEBUG: RunQuery took 2 ms for 46 items query: SELECT * FROM tvshow_view
06:42:33.894 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:33.897 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:42:33.942 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:42:34.918 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:34.918 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:42:35.101 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:35.210 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 26)
06:42:35.210 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:35.214 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:42:35.219 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:35.222 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:42:35.251 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:42:35.267 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:42:37.084 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x000d, modifier: 0x0
06:42:37.285 T:139775056635584   DEBUG: OnKey: return (0xf00d) pressed, action is Select
06:42:37.285 T:139775056635584   DEBUG: ------ Window Init (DialogSelect.xml) ------
06:42:37.285 T:139775056635584    INFO: Loading skin file: DialogSelect.xml, load type: KEEP_IN_MEMORY
06:42:37.531 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 27)
06:42:37.531 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:37.535 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:42:37.540 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:37.543 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:42:37.573 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:42:37.589 T:139774576801536   DEBUG: RunQuery took 15 ms for 2286 items query: select * from episode_view
06:42:41.411 T:139773662455552   DEBUG: Thread JobWorker 139773662455552 terminating (autodelete)
06:42:41.411 T:139773385627392   DEBUG: Thread JobWorker 139773385627392 terminating (autodelete)
06:42:41.411 T:139774566573824   DEBUG: Thread JobWorker 139774566573824 terminating (autodelete)
06:42:41.431 T:139775037691648   DEBUG: Thread JobWorker 139775037691648 terminating (autodelete)
06:42:42.118 T:139775056635584   DEBUG: Keyboard: scancode: 0x16, sym: 0x0008, unicode: 0x0008, modifier: 0x0
06:42:42.118 T:139775056635584   DEBUG: OnKey: backspace (0xf008) pressed, action is Back
06:42:42.202 T:139775056635584   DEBUG: Keyboard: scancode: 0x16, sym: 0x0008, unicode: 0x0000, modifier: 0x0
06:42:42.435 T:139775056635584   DEBUG: ------ Window Deinit (DialogSelect.xml) ------
06:42:42.435 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x0000, modifier: 0x0
06:42:42.861 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 28)
06:42:42.861 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:42.865 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:42:42.870 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:42.873 T:139774576801536   DEBUG: RunQuery took 1 ms for 225 items query: select * from movie_view
06:42:42.884 T:139775056635584   DEBUG: Keyboard: scancode: 0x16, sym: 0x0008, unicode: 0x0008, modifier: 0x0
06:42:42.884 T:139775056635584   DEBUG: OnKey: backspace (0xf008) pressed, action is Back
06:42:42.886 T:139775056635584   DEBUG: CGUIWindowManager:TonguereviousWindow: Deactivate
06:42:42.904 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:42:42.920 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:42:43.551 T:139775056635584   DEBUG: ------ Window Deinit (SettingsCategory.xml) ------
06:42:43.551 T:139775056635584   DEBUG: CGUIWindowManager:TonguereviousWindow: Activate new
06:42:43.551 T:139775056635584   DEBUG: ------ Window Init (Settings.xml) ------
06:42:43.552 T:139775056635584   DEBUG: Keyboard: scancode: 0x16, sym: 0x0008, unicode: 0x0000, modifier: 0x0
06:42:45.218 T:139775056635584   DEBUG: Keyboard: scancode: 0x72, sym: 0x0113, unicode: 0x0000, modifier: 0x0
06:42:45.218 T:139775056635584   DEBUG: OnKey: right (0xf083) pressed, action is Right
06:42:45.401 T:139775056635584   DEBUG: Keyboard: scancode: 0x72, sym: 0x0113, unicode: 0x0000, modifier: 0x0
06:42:46.118 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:46.118 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:42:46.183 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 29)
06:42:46.183 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:46.187 T:139774576801536   DEBUG: RunQuery took 2 ms for 46 items query: SELECT * FROM tvshow_view
06:42:46.193 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:46.196 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:42:46.226 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:42:46.241 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:42:46.268 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:46.601 T:139775056635584   DEBUG: Keyboard: scancode: 0x72, sym: 0x0113, unicode: 0x0000, modifier: 0x0
06:42:46.601 T:139775056635584   DEBUG: OnKey: right (0xf083) pressed, action is Right
06:42:46.684 T:139775056635584   DEBUG: Keyboard: scancode: 0x72, sym: 0x0113, unicode: 0x0000, modifier: 0x0
06:42:46.851 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:42:46.851 T:139775056635584   DEBUG: OnKey: right (0xf083) pressed, action is Right
06:42:46.951 T:139775056635584   DEBUG: Keyboard: scancode: 0x72, sym: 0x0113, unicode: 0x0000, modifier: 0x0
06:42:47.511 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 30)
06:42:47.511 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:47.515 T:139774576801536   DEBUG: RunQuery took 2 ms for 46 items query: SELECT * FROM tvshow_view
06:42:47.521 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:47.524 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:42:47.554 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:42:47.569 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:42:48.551 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x000d, modifier: 0x0
06:42:48.635 T:139775056635584   DEBUG: OnKey: return (0xf00d) pressed, action is Select
06:42:48.635 T:139775056635584   DEBUG: Activating window ID: 10040
06:42:48.837 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 31)
06:42:48.837 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:48.842 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:42:48.847 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:48.850 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:42:48.879 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:42:48.895 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:42:49.051 T:139775056635584   DEBUG: ------ Window Deinit (Settings.xml) ------
06:42:49.052 T:139775056635584   DEBUG: ------ Window Init (AddonBrowser.xml) ------
06:42:49.052 T:139775056635584    INFO: Loading skin file: AddonBrowser.xml, load type: KEEP_IN_MEMORY
06:42:49.065 T:139775056635584   DEBUG: CGUIMediaWindow::GetDirectory (addons://)
06:42:49.065 T:139775056635584   DEBUG:   ParentPath =
06:42:49.074 T:139775056635584   DEBUG: CAddonMgr::GetAvailableUpdates took 9 ms
06:42:49.079 T:139775037691648   DEBUG: Thread BackgroundLoader start, auto delete: false
06:42:49.079 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x0000, modifier: 0x0
06:42:49.080 T:139775037691648   DEBUG: Thread BackgroundLoader 139775037691648 terminating
06:42:50.367 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x000d, modifier: 0x0
06:42:50.467 T:139775056635584   DEBUG: OnKey: return (0xf00d) pressed, action is Select
06:42:50.468 T:139775056635584   DEBUG: CGUIMediaWindow::GetDirectory (addons://user/)
06:42:50.468 T:139775056635584   DEBUG:   ParentPath = [addons://]
06:42:50.468 T:139775037691648   DEBUG: Thread JobWorker start, auto delete: true
06:42:50.472 T:139774566573824   DEBUG: Thread BackgroundLoader start, auto delete: false
06:42:50.472 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x0000, modifier: 0x0
06:42:50.473 T:139774566573824   DEBUG: Thread BackgroundLoader 139774566573824 terminating
06:42:51.067 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:51.067 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:42:51.164 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 32)
06:42:51.164 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:51.168 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:42:51.174 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:51.177 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:42:51.207 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:42:51.222 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:42:51.234 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:51.418 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:42:51.418 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:42:51.584 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:52.384 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:52.384 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:42:52.484 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:52.489 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 33)
06:42:52.489 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:52.493 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:42:52.498 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:52.501 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:42:52.531 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:42:52.547 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:42:52.601 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:52.601 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:42:52.801 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:53.284 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:42:53.284 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:42:53.434 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:53.701 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x000d, modifier: 0x0
06:42:53.826 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 34)
06:42:53.826 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:53.830 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:42:53.835 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:53.838 T:139774576801536   DEBUG: RunQuery took 1 ms for 225 items query: select * from movie_view
06:42:53.867 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:42:53.883 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:42:53.884 T:139775056635584   DEBUG: OnKey: return (0xf00d) pressed, action is Select
06:42:53.884 T:139775056635584   DEBUG: CGUIMediaWindow::GetDirectory (addons://user/all)
06:42:53.884 T:139775056635584   DEBUG:   ParentPath = [addons://user/]
06:42:53.896 T:139775037691648   DEBUG: CAddonMgr::GetAvailableUpdates took 8 ms
06:42:53.901 T:139774566573824   DEBUG: Thread BackgroundLoader start, auto delete: false
06:42:53.901 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x0000, modifier: 0x0
06:42:53.905 T:139773385627392   DEBUG: Thread JobWorker start, auto delete: true
06:42:54.071 T:139775037691648   DEBUG: GetImageHash - unable to stat url /storage/.kodi/addons/script.module.nakamori/icon.png
06:42:54.090 T:139774566573824   DEBUG: Thread BackgroundLoader 139774566573824 terminating
06:42:54.097 T:139775037691648   DEBUG: Recaching image '/storage/.kodi/addons/metadata.themoviedb.org/icon.png' to '9/96c2c48a.jpg':
06:42:54.097 T:139775037691648   DEBUG: cached image 'special://masterprofile/Thumbnails/9/96c2c48a.jpg' size 256x256
06:42:54.121 T:139775037691648   DEBUG: Recaching image '/storage/.kodi/addons/metadata.universal/icon.png' to '7/7e82f905.jpg':
06:42:54.121 T:139775037691648   DEBUG: cached image 'special://masterprofile/Thumbnails/7/7e82f905.jpg' size 256x256
06:42:54.501 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:54.501 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:42:54.651 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:54.918 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:42:54.918 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:42:55.001 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:55.268 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:42:55.268 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:42:55.349 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 35)
06:42:55.349 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:55.353 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:42:55.359 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:55.362 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:42:55.407 T:139774576801536   DEBUG: RunQuery took 15 ms for 2286 items query: select * from episode_view
06:42:55.584 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:55.751 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:42:55.751 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:42:55.834 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:55.968 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:42:55.968 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:42:56.068 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:56.218 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:42:56.218 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:42:56.318 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:56.451 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:42:56.451 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:42:56.551 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:56.676 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 36)
06:42:56.676 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:56.680 T:139774576801536   DEBUG: RunQuery took 2 ms for 46 items query: SELECT * FROM tvshow_view
06:42:56.685 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:56.688 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:42:56.718 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:42:56.733 T:139774576801536   DEBUG: RunQuery took 15 ms for 2286 items query: select * from episode_view
06:42:57.184 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:57.184 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:42:57.351 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:42:57.768 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x000d, modifier: 0x0
06:42:57.851 T:139775056635584   DEBUG: OnKey: return (0xf00d) pressed, action is Select
06:42:57.851 T:139775056635584   DEBUG: ------ Window Init (DialogAddonInfo.xml) ------
06:42:57.851 T:139775056635584    INFO: Loading skin file: DialogAddonInfo.xml, load type: KEEP_IN_MEMORY
06:42:57.999 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 37)
06:42:57.999 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:42:58.003 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:42:58.008 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:42:58.011 T:139774576801536   DEBUG: RunQuery took 1 ms for 225 items query: select * from movie_view
06:42:58.042 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:42:58.057 T:139774576801536   DEBUG: RunQuery took 15 ms for 2286 items query: select * from episode_view
06:42:59.618 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:59.618 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:42:59.718 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:42:59.901 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:42:59.901 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:43:00.001 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:43:00.168 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:43:00.168 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:43:00.251 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:43:00.328 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 38)
06:43:00.328 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:43:00.332 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:43:00.338 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:43:00.341 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:43:00.371 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:43:00.385 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:43:00.385 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:43:00.387 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:43:00.485 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:43:01.084 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x000d, modifier: 0x0
06:43:01.284 T:139775056635584   DEBUG: OnKey: return (0xf00d) pressed, action is Select
06:43:01.285 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x0000, modifier: 0x0
06:43:01.285 T:139774566573824   DEBUG: Thread LanguageInvoker start, auto delete: false
06:43:01.285 T:139774566573824    INFO: initializing python engine.
06:43:01.285 T:139774566573824   DEBUG: CPythonInvoker(7, /storage/.kodi/addons/service.watchedlist/manual.py): start processing
06:43:01.290 T:139774566573824   DEBUG: -->Python Interpreter Initialized<--
06:43:01.290 T:139774566573824   DEBUG: CPythonInvoker(7, /storage/.kodi/addons/service.watchedlist/manual.py): the source file to load is "/storage/.kodi/addons/service.watchedlist/manual.py"
06:43:01.290 T:139774566573824   DEBUG: CPythonInvoker(7, /storage/.kodi/addons/service.watchedlist/manual.py): setting the Python path to /storage/.kodi/addons/service.watchedlist:/storage/.kodi/addons/script.module.buggalo/lib:/storage/.kodi/addons/script.module.certifi/lib:/storage/.kodi/addons/script.module.chardet/lib:/storage/.kodi/addons/script.module.dropbox/lib:/storage/.kodi/addons/script.module.idna/lib:/storage/.kodi/addons/script.module.myconnpy/lib:/storage/.kodi/addons/script.module.qrcode/lib:/storage/.kodi/addons/script.module.requests/lib:/storage/.kodi/addons/script.module.simplejson/lib:/storage/.kodi/addons/script.module.six/lib:/storage/.kodi/addons/script.module.urllib3/lib:/usr/share/kodi/addons/script.module.pil/lib:/usr/lib/python27.zip:/usr/lib/python2.7:/usr/lib/python2.7/plat-linux2:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload:/usr/lib/python2.7/site-packages:/usr/lib/python2.7/site-packages/gtk-2.0
06:43:01.290 T:139774566573824   DEBUG: CPythonInvoker(7, /storage/.kodi/addons/service.watchedlist/manual.py): entering source directory /storage/.kodi/addons/service.watchedlist
06:43:01.290 T:139774566573824   DEBUG: CPythonInvoker(7, /storage/.kodi/addons/service.watchedlist/manual.py): instantiating addon using automatically obtained id of "service.watchedlist" dependent on version 2.20.0 of the xbmc.python api
06:43:01.502 T:139775056635584   DEBUG: ------ Window Init (DialogConfirm.xml) ------
06:43:01.502 T:139775056635584    INFO: Loading skin file: DialogConfirm.xml, load type: KEEP_IN_MEMORY
06:43:01.601 T:139775056635584   DEBUG: ------ Window Deinit (DialogAddonInfo.xml) ------
06:43:01.653 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 39)
06:43:01.653 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:43:01.658 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:43:01.663 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:43:01.666 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:43:01.696 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:43:01.712 T:139774576801536   DEBUG: RunQuery took 15 ms for 2286 items query: select * from episode_view
06:43:02.617 T:139775056635584   DEBUG: Keyboard: scancode: 0x71, sym: 0x0114, unicode: 0x0000, modifier: 0x0
06:43:02.618 T:139775056635584   DEBUG: OnKey: left (0xf082) pressed, action is Left
06:43:02.784 T:139775056635584   DEBUG: Keyboard: scancode: 0x71, sym: 0x0114, unicode: 0x0000, modifier: 0x0
06:43:02.979 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 40)
06:43:02.979 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:43:02.983 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:43:02.989 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:43:02.992 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:43:03.022 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:43:03.037 T:139774576801536   DEBUG: RunQuery took 15 ms for 2286 items query: select * from episode_view
06:43:03.101 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x000d, modifier: 0x0
06:43:03.201 T:139775056635584   DEBUG: OnKey: return (0xf00d) pressed, action is Select
06:43:03.201 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x0000, modifier: 0x0
06:43:03.517 T:139775056635584   DEBUG: ------ Window Deinit (DialogConfirm.xml) ------
06:43:03.517 T:139774566573824  NOTICE: service.watchedlist: Update Library Manual Run.
06:43:03.520 T:139774566573824   DEBUG: service.watchedlist: sync_tvshows: sync tvshows with wl database : None
06:43:03.523 T:139774566573824   DEBUG: service.watchedlist: get_watched_wl: Get watched movies from WL database
06:43:03.524 T:139774566573824   DEBUG: service.watchedlist: get_watched_wl: Get watched episodes from WL database
06:43:03.527 T:139774566573824  NOTICE: service.watchedlist: Notification. WatchedList: 31 movies and 187 episodes read from WL.
06:43:03.527 T:139774566573824   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:43:03.531 T:139774566573824   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:43:03.534 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x0000, modifier: 0x0
06:43:03.537 T:139774566573824   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:43:03.541 T:139774566573824   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:43:03.551 T:139775056635584   DEBUG: ------ Window Init (DialogNotification.xml) ------
06:43:03.572 T:139774566573824   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:43:03.588 T:139774566573824   DEBUG: RunQuery took 15 ms for 2286 items query: select * from episode_view
06:43:03.860 T:139774566573824  NOTICE: service.watchedlist: Notification. WatchedList: 220 movies and 2286 episodes read from Kodi-DB.
06:43:03.861 T:139774566573824   DEBUG: service.watchedlist: sync_tvshows: sync tvshows with wl database : None
06:43:03.874 T:139774566573824   DEBUG: service.watchedlist: write_wl_wdata: Write watched movies to WL database
06:43:03.874 T:139774566573824   DEBUG: DialogProgress::Open called
06:43:03.874 T:139774566573824   DEBUG: ------ Window Init (DialogConfirm.xml) ------
06:43:03.874 T:139774566573824    INFO: Loading skin file: DialogConfirm.xml, load type: KEEP_IN_MEMORY
06:43:03.884 T:139774566573824  NOTICE: service.watchedlist: Notification. Addon movie database: 0 watched new. 0 updated
06:43:03.884 T:139774566573824   DEBUG: service.watchedlist: write_wl_wdata: Write watched episodes to WL database
06:43:03.885 T:139774566573824   DEBUG: DialogProgress::Open called (already running)!
06:43:03.885 T:139774566573824   DEBUG: ------ Window Init (DialogConfirm.xml) ------
06:43:03.918 T:139774566573824  NOTICE: service.watchedlist: Notification. Addon episode database: 0 watched new. 0 updated
06:43:03.918 T:139774566573824   DEBUG: service.watchedlist: write_xbmc_wdata: Write watched movies to xbmc database (pd=1, noti=2)
06:43:03.918 T:139774566573824   DEBUG: DialogProgress::Open called (already running)!
06:43:03.918 T:139774566573824   DEBUG: ------ Window Init (DialogConfirm.xml) ------
06:43:03.934 T:139774566573824  NOTICE: service.watchedlist: Notification. Kodi-movie database: 0 movies marked as watched
06:43:03.934 T:139774566573824   DEBUG: service.watchedlist: write_xbmc_wdata: Write watched episodes to xbmc database (pd=1, noti=2)
06:43:03.935 T:139774566573824   DEBUG: DialogProgress::Open called (already running)!
06:43:03.935 T:139774566573824   DEBUG: ------ Window Init (DialogConfirm.xml) ------
06:43:03.968 T:139774566573824  NOTICE: service.watchedlist: Notification. Kodi-episode database: 0 episodes marked as watched
06:43:03.968 T:139774566573824  NOTICE: service.watchedlist: Notification. WatchedList: update complete.
06:43:03.968 T:139774566573824   DEBUG: service.watchedlist: runUpdate exited with success
06:43:03.968 T:139774566573824    INFO: CPythonInvoker(7, /storage/.kodi/addons/service.watchedlist/manual.py): script successfully run
06:43:03.984 T:139775056635584   DEBUG: ------ Window Deinit (DialogConfirm.xml) ------
06:43:04.015 T:139774566573824    INFO: Python script stopped
06:43:04.015 T:139774566573824   DEBUG: Thread LanguageInvoker 139774566573824 terminating
06:43:15.267 T:139775056635584   DEBUG: ------ Window Deinit (DialogNotification.xml) ------
06:43:16.034 T:139775056635584   DEBUG: Keyboard: scancode: 0x16, sym: 0x0008, unicode: 0x0008, modifier: 0x0
06:43:16.034 T:139775056635584   DEBUG: OnKey: backspace (0xf008) pressed, action is Back
06:43:16.034 T:139775056635584   DEBUG: CGUIMediaWindow::GetDirectory (addons://user/)
06:43:16.034 T:139775056635584   DEBUG:   ParentPath = [addons://]
06:43:16.039 T:139774566573824   DEBUG: Thread BackgroundLoader start, auto delete: false
06:43:16.040 T:139774566573824   DEBUG: Thread BackgroundLoader 139774566573824 terminating
06:43:16.284 T:139775056635584   DEBUG: Keyboard: scancode: 0x16, sym: 0x0008, unicode: 0x0000, modifier: 0x0
06:43:16.308 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 41)
06:43:16.308 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:43:16.312 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:43:16.317 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:43:16.320 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:43:16.350 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:43:16.366 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:43:17.734 T:139775056635584   DEBUG: Keyboard: scancode: 0x16, sym: 0x0008, unicode: 0x0008, modifier: 0x0
06:43:17.734 T:139775056635584   DEBUG: OnKey: backspace (0xf008) pressed, action is Back
06:43:17.734 T:139775056635584   DEBUG: CGUIMediaWindow::GetDirectory (addons://)
06:43:17.734 T:139775056635584   DEBUG:   ParentPath =
06:43:17.743 T:139773385627392   DEBUG: CAddonMgr::GetAvailableUpdates took 8 ms
06:43:17.747 T:139774566573824   DEBUG: Thread BackgroundLoader start, auto delete: false
06:43:17.748 T:139774566573824   DEBUG: Thread BackgroundLoader 139774566573824 terminating
06:43:17.983 T:139775056635584   DEBUG: Keyboard: scancode: 0x16, sym: 0x0008, unicode: 0x0000, modifier: 0x0
06:43:18.630 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 42)
06:43:18.630 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:43:18.639 T:139774576801536   DEBUG: RunQuery took 6 ms for 46 items query: SELECT * FROM tvshow_view
06:43:18.647 T:139774576801536   DEBUG: RunQuery took 1 ms for 225 items query: select * from movie_view
06:43:18.677 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:43:18.693 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:43:18.817 T:139775056635584   DEBUG: Keyboard: scancode: 0x16, sym: 0x0008, unicode: 0x0008, modifier: 0x0
06:43:18.817 T:139775056635584   DEBUG: OnKey: backspace (0xf008) pressed, action is Back
06:43:18.817 T:139775056635584   DEBUG: CGUIWindowManager:TonguereviousWindow: Deactivate
06:43:19.500 T:139775056635584   DEBUG: ------ Window Deinit (AddonBrowser.xml) ------
06:43:19.500 T:139775056635584   DEBUG: CGUIWindowManager:TonguereviousWindow: Activate new
06:43:19.500 T:139775056635584   DEBUG: ------ Window Init (Settings.xml) ------
06:43:19.501 T:139775056635584   DEBUG: Keyboard: scancode: 0x16, sym: 0x0008, unicode: 0x0000, modifier: 0x0
06:43:20.867 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:43:20.867 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:43:20.960 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 43)
06:43:20.960 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:43:20.964 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:43:20.969 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:43:20.972 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:43:21.002 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:43:21.017 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:43:21.018 T:139774576801536   DEBUG: RunQuery took 15 ms for 2286 items query: select * from episode_view
06:43:21.533 T:139775056635584   DEBUG: Keyboard: scancode: 0x72, sym: 0x0113, unicode: 0x0000, modifier: 0x0
06:43:21.534 T:139775056635584   DEBUG: OnKey: right (0xf083) pressed, action is Right
06:43:21.634 T:139775056635584   DEBUG: Keyboard: scancode: 0x72, sym: 0x0113, unicode: 0x0000, modifier: 0x0
06:43:22.017 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x000d, modifier: 0x0
06:43:22.200 T:139775056635584   DEBUG: OnKey: return (0xf00d) pressed, action is Select
06:43:22.200 T:139775056635584   DEBUG: Activating window ID: 10016
06:43:22.286 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 44)
06:43:22.286 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:43:22.291 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:43:22.296 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:43:22.299 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:43:22.329 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:43:22.345 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:43:22.617 T:139775056635584   DEBUG: ------ Window Deinit (Settings.xml) ------
06:43:22.617 T:139775056635584   DEBUG: ------ Window Init (SettingsCategory.xml) ------
06:43:22.732 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x0000, modifier: 0x0
06:43:23.934 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:43:23.934 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:43:24.034 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:43:24.167 T:139775056635584   DEBUG: Previous line repeats 1 times.
06:43:24.167 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:43:24.284 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:43:24.615 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 45)
06:43:24.615 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:43:24.620 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:43:24.625 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:43:24.628 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:43:24.659 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:43:24.674 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:43:24.767 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:43:24.767 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:43:24.934 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:43:25.567 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x000d, modifier: 0x0
06:43:25.667 T:139775056635584   DEBUG: OnKey: return (0xf00d) pressed, action is Select
06:43:25.667 T:139775056635584   DEBUG: Keyboard: scancode: 0x24, sym: 0x000d, unicode: 0x0000, modifier: 0x0
06:43:25.944 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 46)
06:43:25.944 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:43:25.948 T:139774576801536   DEBUG: RunQuery took 2 ms for 46 items query: SELECT * FROM tvshow_view
06:43:25.954 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:43:25.957 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:43:26.002 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:43:26.600 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:43:26.600 T:139775056635584   DEBUG: OnKey: down (0xf081) pressed, action is Down
06:43:26.750 T:139775056635584   DEBUG: Keyboard: scancode: 0x74, sym: 0x0112, unicode: 0x0000, modifier: 0x0
06:43:27.270 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 47)
06:43:27.270 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:43:27.274 T:139774576801536   DEBUG: RunQuery took 2 ms for 46 items query: SELECT * FROM tvshow_view
06:43:27.279 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:43:27.282 T:139774576801536   DEBUG: RunQuery took 1 ms for 225 items query: select * from movie_view
06:43:27.312 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:43:27.328 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
06:43:27.750 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:43:27.750 T:139775056635584   DEBUG: OnKey: up (0xf080) pressed, action is Up
06:43:27.933 T:139775056635584   DEBUG: Keyboard: scancode: 0x6f, sym: 0x0111, unicode: 0x0000, modifier: 0x0
06:43:28.383 T:139775056635584   DEBUG: Keyboard: scancode: 0x72, sym: 0x0113, unicode: 0x0000, modifier: 0x0
06:43:28.383 T:139775056635584   DEBUG: OnKey: right (0xf083) pressed, action is Right
06:43:28.484 T:139775056635584   DEBUG: Keyboard: scancode: 0x72, sym: 0x0113, unicode: 0x0000, modifier: 0x0
06:43:28.597 T:139774576801536   DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 48)
06:43:28.597 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all TV shows from xbmc database
06:43:28.601 T:139774576801536   DEBUG: RunQuery took 3 ms for 46 items query: SELECT * FROM tvshow_view
06:43:28.606 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all movies from xbmc database
06:43:28.609 T:139774576801536   DEBUG: RunQuery took 2 ms for 225 items query: select * from movie_view
06:43:28.639 T:139774576801536   DEBUG: service.watchedlist: get_watched_xbmc: Get all episodes from xbmc database
06:43:28.655 T:139774576801536   DEBUG: RunQuery took 14 ms for 2286 items query: select * from episode_view
Reply
So the addon seems to work in principal:
Quote:06:43:03.527 T:139774566573824  NOTICE: service.watchedlist: Notification. WatchedList: 31 movies and 187 episodes read from WL.
06:43:03.860 T:139774566573824  NOTICE: service.watchedlist: Notification. WatchedList: 220 movies and 2286 episodes read from Kodi-DB.

What makes me wonder is the format of your addon settings. Yours is the template file coming with the addon.
The settings.xml should look like this:

xml:
<settings>
    <setting id="autostart" value="false" />
    <setting id="db_format" value="0" />
    <setting id="dbbackup" value="true" />
    <setting id="dbbackupcount" value="4" />
   ....
</settings>

db_format is the option for SQLite file or mySQL.
It seems like your settings are somehow not set and you use the default watchedlist.db file instead of your mysql database.
I think you mixed up ~/.kodi/userdata/addon_data/service.watchedlist/settings.xml with ~/.kodi/addons/service.watchedlist/resources/settings.xml.

Or do you have a platform where the directory structure is somehow different?
Reply
(2017-11-06, 22:32)schapplm Wrote:
(2017-11-01, 19:58).:B:. Wrote: Is there a way I can fix/work around some shows reporting not to have IMDb numbers which causes their watch status not being saved in the database?

I was sometimes successful by manually rescraping the video folder in Kodi (Video->Files).
Also you can try deleting exported .nfo/.xml files in the media folders (if existing).
If that does not help you need to remove the files from your library and re-add them (perhaps by just renaming the folder).
Unfortunately none of the above work.And an uninstall and reinstall also does not work. I’m stumped... every show has an IMDb ID number (the tvdb number) but the program reports (one by one) that none have....
Reply
(2017-12-05, 10:10)phileas50 Wrote:
(2017-11-06, 22:32)schapplm Wrote:
(2017-11-01, 19:58).:B:. Wrote: Is there a way I can fix/work around some shows reporting not to have IMDb numbers which causes their watch status not being saved in the database?

I was sometimes successful by manually rescraping the video folder in Kodi (Video->Files).
Also you can try deleting exported .nfo/.xml files in the media folders (if existing).
If that does not help you need to remove the files from your library and re-add them (perhaps by just renaming the folder). 
Unfortunately none of the above work.And an uninstall and reinstall also does not work. I’m stumped... every show has an IMDb ID number (the tvdb number) but the program reports (one by one) that none have.... 
I'm having the exact same problem. Watched list worked perfectly. I changed nothing but upgraded to 17.6 (from 17.3), and now Watched List add-on gives me the same error as Phileas50. I assume something in the upgrade broke watched list?
Reply
(2017-12-05, 15:26)slipknutz Wrote: I'm having the exact same problem. Watched list worked perfectly. I changed nothing but upgraded to 17.6 (from 17.3), and now Watched List add-on gives me the same error as Phileas50. I assume something in the upgrade broke watched list?  
Please have a look at the discussion between #129 and #136. Especially see what the json command for VideoLibrary.GetTVShows gives you.
According to the wiki, the video library version did not change from 17.3 to 17.6 (remains version 107).
If you have the field imdbnumber not set in your library for the tv shows in question, you somehow have to fill it and the addon can not do anything. If you have an imdbnumber, we will have to investigate this further.
Reply
I finished the command, and posted the update below
Reply
Ok. The Get Tv Shows JSON command shows blank IMDB numbers. How do I fill those in myself? And im not sure why the TV Shows are the only ones not showing IMDB numbers now. The Get Movies JSON command worked great, and showed IMDB numbers for all of them. I assume I can edit the JSON live via the web command? Where do I get the IMBD number from? Just look up the show on IMBD.com and add the number there via the JSON command window? "tvshows":[{"imdbnumber":"","label":"30 Rock","title":"30 Rock","tvshowid":1},
Reply
  • 1
  • 13
  • 14
  • 15(current)
  • 16
  • 17
  • 35

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