• 1
  • 2
  • 3(current)
  • 4
  • 5
  • 35
Release WatchedList - service to automatically save/restore watched state
#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
Reply
#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
Reply
#33
anybody running v14yes? Is WatchedList compatible?
Reply
#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.
Reply
#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?
Reply
#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.
Reply
#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.
Reply
#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.
Reply
#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.
Reply
#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.
Reply
#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.
Reply
#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 MQ ?
Reply
#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.
Reply
#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!
Reply
#45
Great product!
Reply
  • 1
  • 2
  • 3(current)
  • 4
  • 5
  • 35

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