Release - WatchedList - service to automatically save/restore watched state

  Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
schapplm Offline
Member
Posts: 77
Joined: Apr 2013
Reputation: 2
Post: #31
I noticed this behaviour too on XBMC 13.2 with a db file on a windows share. It did not solve by moving the file to a nfs share (see posts above).
Therefore I added an option to make a mysql database for the addon. Since you already had the addon installed, you still had the not-working SQLite DB File option activated. I kept this option for down-compatibility.
You have to change the addon configuration. Instructions how to configure the addon is in the addon wiki.
Instructions how to migrate from SQLite to mySQL is also in the wiki

My addon: service.watchedlist
My HTPC: Kodi 17.0; Ubuntu 16.04 LTS x64; AMD A6-6400K; MSI FM2-A55M-E33; 4GB Kingston HyperX RAM; Digital Devices Cine CT V6 DVB-C; Streacom FC8B Evo with 120W picoPSU
find quote
Th3Eagle Offline
Junior Member
Posts: 9
Joined: Dec 2013
Reputation: 0
Post: #32
Worked like a charm on all 3 systems (2x win 7 en 1x openlec-raspi).

Thank you for the recommendation. Took me some work to get MySQL running at first using the tutorials in the wiki. Eventualy I switched to WAMP. Took me 5 min... Smile
find quote
Win a 2 Offline
Junior Member
Posts: 41
Joined: Feb 2012
Reputation: 0
Post: #33
anybody running v14yes? Is WatchedList compatible?
find quote
schapplm Offline
Member
Posts: 77
Joined: Apr 2013
Reputation: 2
Post: #34
(2015-01-04 21:58)Win a 2 Wrote:  anybody running v14yes? Is WatchedList compatible?
I am currently running the addon on two systems with Kodi 14.0 Helix and a shared mySQL database. Works fine, like in XBMC 13.2 Gotham.

My addon: service.watchedlist
My HTPC: Kodi 17.0; Ubuntu 16.04 LTS x64; AMD A6-6400K; MSI FM2-A55M-E33; 4GB Kingston HyperX RAM; Digital Devices Cine CT V6 DVB-C; Streacom FC8B Evo with 120W picoPSU
find quote
Gink Offline
Junior Member
Posts: 18
Joined: Apr 2012
Reputation: 0
Post: #35
Does the setting "Follow User Setting Watched/Unwatched" actually do anything? The description "Run in background and update the watchedlist database every time the user changes a watched state" makes me think it should be updating the database in real time when I set something to watched, or finish a show and it gets marked watched. I'm using a mysql database and it seems like watched states are only getting set on the periodic full updates I currently have set for every 12 hours.

So is the only way to keep multiple xbmc instances synced is to set it to run full updates more often? Will that interrupt viewing or make menus unresponsive if I run periodic updates every hour or so, but turn off the progress indicator?
find quote
schapplm Offline
Member
Posts: 77
Joined: Apr 2013
Reputation: 2
Post: #36
(2015-01-25 04:22)Gink Wrote:  Does the setting "Follow User Setting Watched/Unwatched" actually do anything? The description "Run in background and update the watchedlist database every time the user changes a watched state" makes me think it should be updating the database in real time when I set something to watched, or finish a show and it gets marked watched. I'm using a mysql database and it seems like watched states are only getting set on the periodic full updates I currently have set for every 12 hours.
This setting behaves as you assume it should. It leads to permanent activity of the addon in background. Basically, there is an endless loop which checks for user action. If user action is detected (press any key on remote or keyboard), the whole database is compared to the state before and is synched with the mySQL database.
You can see if that works, if you set debug mode in addon settings to enabled and enable debug logging in kodi. Then there should be log entries in kodi.log like "18:00:37 T:140017353058048 DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 0)"
I tested this to be working. It could take some time between setting something as watched (or unwatched) and the message being displayed, because the addon has to crunch the entire database.

(2015-01-25 04:22)Gink Wrote:  So is the only way to keep multiple xbmc instances synced is to set it to run full updates more often? Will that interrupt viewing or make menus unresponsive if I run periodic updates every hour or so, but turn off the progress indicator?
normally for full sync you should use the method above. However running the full update without the progress bars should not disturb using kodi in the menu of while watching media.

My addon: service.watchedlist
My HTPC: Kodi 17.0; Ubuntu 16.04 LTS x64; AMD A6-6400K; MSI FM2-A55M-E33; 4GB Kingston HyperX RAM; Digital Devices Cine CT V6 DVB-C; Streacom FC8B Evo with 120W picoPSU
find quote
Win a 2 Offline
Junior Member
Posts: 41
Joined: Feb 2012
Reputation: 0
Post: #37
Add-on is marked as "update available" for weeks now - but update failes, iirc i have 1.0.1 installed via superrepo.
Updated my openeelec to 5.0 today - error still the same.
find quote
Gink Offline
Junior Member
Posts: 18
Joined: Apr 2012
Reputation: 0
Post: #38
(2015-01-25 19:14)schapplm Wrote:  Basically, there is an endless loop which checks for user action. If user action is detected (press any key on remote or keyboard), the whole database is compared to the state before and is synched with the mySQL database.
You can see if that works, if you set debug mode in addon settings to enabled and enable debug logging in kodi. Then there should be log entries in kodi.log like "18:00:37 T:140017353058048 DEBUG: service.watchedlist: watch_user_changes: Check for user changes (no. 0)"

Thanks for the info. I enabled debugging in both, but there's no sign of a service.watchedlist or any other indication of the loop watching anything.
Perhaps it has something to do with my combination of settings. Does having the autorun set to periodic cause the service to sleep and not be watching? Is it necessary to set the autostart mode to "no update" for it to stay running in the background?

Code:
else: # no autostart, only watch user
                    sleeptime = 3600 # arbitrary time for infinite loop

Do the different sleeptime values for one or periodic updates mean the service isn't watching in the space between full updates?

Sorry if I'm missing something obvious, but I've been marking things watched and see nothing in debug logs, nor any change in the episode_watched table for the show. The add-on seems functional, so I'm thinking I must just not understand the settings.

-----
I tested switching autostart mode to "no update" and restarting xbmc. Now I see the service running anytime I press a button on the remote. Takes a few minutes to update the DB, but definitely works with those settings. It doesn't pick up the changes that I made previously, which makes sense as it is comparing states of the xbmc db, but I could run a manual update to get it up to date, then it will track all changes going forward.

Appreciate the assistance, now that I understand how it is working, I should be able to get the settings just right to sync my media centers.
(This post was last modified: 2015-01-25 21:30 by Gink.)
find quote
schapplm Offline
Member
Posts: 77
Joined: Apr 2013
Reputation: 2
Post: #39

  1. check if you use the current version 1.0.3. I fixed a few waiting time related bugs recently.
  2. have you installed the addon from zip? I believe, only copying the folder into the .../addons/ directory does not set it into autostart (and does not install the dependencies). There should come at least one notification at kodi startup.
  3. did you set any delay time before execution in the Watchedlist addon settings? This delays the watching user states too.
  4. If this does not solve the problem, post the contents of userdata/addon_data/service.watchedlist/settings.xml and all lines of kodi.log containing the term "service.watchedlist". Further I need your version number of Kodi.

(2015-01-25 20:59)Gink Wrote:  Do the different sleeptime values for one or periodic updates mean the service isn't watching in the space between full updates?
The watching of the user is always active after the starting delay. So it is watching in the space between full updates.

My addon: service.watchedlist
My HTPC: Kodi 17.0; Ubuntu 16.04 LTS x64; AMD A6-6400K; MSI FM2-A55M-E33; 4GB Kingston HyperX RAM; Digital Devices Cine CT V6 DVB-C; Streacom FC8B Evo with 120W picoPSU
(This post was last modified: 2015-01-25 21:12 by schapplm.)
find quote
Gink Offline
Junior Member
Posts: 18
Joined: Apr 2012
Reputation: 0
Post: #40
Thanks for the response. I'm running 1.0.3 on XBMCbuntu 12, installed from zip.

At the moment I'm running it set to follow user input, which is working with autostart set to none. Also no delay is set.

When I had autostart set to periodic, 12 hours and debugging activated in the plugin and xbmc there were no service.watchedlist entries in the logs except on manual or periodic full updates. Now, with periodic turned off, I see the service.watchedlist entries any time I push a button on the remote.

If I have some time this weekend I'll do some more testing and set it back to periodic and get the settings and logs.
find quote
schapplm Offline
Member
Posts: 77
Joined: Apr 2013
Reputation: 2
Post: #41
(2015-01-25 19:36)Win a 2 Wrote:  Add-on is marked as "update available" for weeks now - but update failes, iirc i have 1.0.1 installed via superrepo.
Updated my openeelec to 5.0 today - error still the same.

The addon is available via the official addon repository now. This should solve the update problems.

My addon: service.watchedlist
My HTPC: Kodi 17.0; Ubuntu 16.04 LTS x64; AMD A6-6400K; MSI FM2-A55M-E33; 4GB Kingston HyperX RAM; Digital Devices Cine CT V6 DVB-C; Streacom FC8B Evo with 120W picoPSU
(This post was last modified: 2015-01-31 19:47 by schapplm.)
find quote
TRaSH Offline
Posting Freak
Posts: 1,189
Joined: Jul 2011
Reputation: 12
Location: Holland, The Netherlands
Post: #42
it doesn't show up in the Gotham official repository,
but i got it from you google code en installed it as a zip.
it worked as a charm.
beeing that trakt isn't still working this is the best next thing to keep your database sync.

LibreElec Kodi | Aeon MQ7 | Onkyo TX-SR875 | Teufel System 5 THX Cinema 5.1 
SuperMicro Server WSE2012R2 | E3-1241 v3 | RAM 32 GB | Drivepool 18TB
find quote
donnuts Offline
Junior Member
Posts: 1
Joined: Jan 2015
Reputation: 0
Post: #43
Hi,

I just go this error. I can't update since then.

Code:
write_wl_wdata: MySQL Database error 1292 (22007): Incorrect datetime value: '1422825328' for column 'lastPlayed' at row 15 while updating movie A Christmas Story (1983)

[edit]
Well... I got this error (incorrect datetime value) everytime and for each files. So, I deleted the database and started a new one. This seems to be good now.
(This post was last modified: 2015-02-02 01:30 by donnuts.)
find quote
warrell Offline
Member
Posts: 70
Joined: Jan 2012
Reputation: 2
Post: #44
Just wanted to drop a note in to say what a fantastic add-on services a real need and very simple to use thank you!
find quote
ap90033 Offline
Junior Member
Posts: 36
Joined: Dec 2009
Reputation: 0
Post: #45
Great product!
(This post was last modified: 2015-02-19 05:21 by ap90033.)
find quote
Post Reply