•   
  • 1
  • 12
  • 13
  • 14
  • 15
  • 16(current)
[Release] WatchedList - service to automatically save/restore watched state
I fixed the imdb number. By removing the tv show, and rescanning it back in, the IMDB number is now showing on that GET TV SHOW JSON command. 

Thank you for this add on, and thank you for the help.
Reply
(2017-12-07, 04:45)slipknutz Wrote: I fixed the imdb number. By removing the tv show, and rescanning it back in, the IMDB number is now showing on that GET TV SHOW JSON command. 

Thank you for this add on, and thank you for the help.
Reply
Removed from where? Physically from the disk or from the database?
Reply
Hello,

I'm new here, I am using this add-on to simply sync my watched series between 2 Kodi Android TV without to have to rely on any external DB.

It worked so flawlessly I hardly have anything to say except Kudos Smile

Since a few days (weeks) I encounter a strange error: when trying to launch the process I get an error reading
Database error while opening /storage/emulated/0/Android/data/org.xbmc.kodi/files/.Kodi/userdata/addon_data/service.watcheedlist
File is encrypted or is not a database.

To be noted, I try to write on an son share, and it worked fine before.
If I set a local path it works fine.
I tried changing the SMB destination and resetting the permission, is is not linked to the storage unit.
It's as if it tries to write a local copy to an inexistent local path.

Do you have any idea about this issue?

Thanks in advance

Guigui
Reply
(2017-12-27, 23:59)guigui_bebert Wrote: Since a few days (weeks) I encounter a strange error: ...
The procedure of the addon for a database file on a network share is to copy it on the local filesystem (.kodi/userdata/addon_data/service.watchedlist/dbcopy or a similar path). Then the addon runs as normal and copies the file back to the network share.
So my guess is, that already the part of copying does not work for you. If you enable the debug logging (for kodi and watchedlist), your log file should contain something similar to this:
Quote:10:52:08.514 T:139943538456320  NOTICE: service.watchedlist: created directory /home/moritz/.kodi/userdata/addon_data/service.watchedlist/dbcopy
10:52:09.495 T:139943538456320  NOTICE: service.watchedlist: Dropbox database downloaded: /watchedlist.db -> /home/moritz/.kodi/userdata/addon_data/service.watchedlist/dropbox.db
...
10:52:09.499 T:139943538456320    INFO: service.watchedlist: database_backup: database backup copy created to /home/moritz/.kodi/userdata/addon_data/service.watchedlist/dbcopy/20171228_105209-watchedlist.db.zip
10:52:09.499 T:139943538456320 WARNING: FileNFS::...
10:52:09.503 T:139943538456320   DEBUG: CNFSFile::...
10:52:09.509 T:139943538456320   DEBUG: service.watchedlist: copied db file /home/moritz/.kodi/userdata/addon_data/service.watchedlist/dbcopy/watchedlist.db -> nfs://192.168.2.21/volume1/Archiv1/Anwendungsdaten/XBMC/service.watchedlist/watchedlist_nw.db. Success: 1
10:52:09.511 T:139943538456320  NOTICE: service.watchedlist: created directory /home/moritz/.kodi/userdata/addon_data/service.watchedlist/dbcopy
I used NFS but I also tested this with SMB network shares before. Perhaps you also have a corrupted database file already in your userdata folder.
My addon: service.watchedlist
My HTPC: Kodi 17.6; 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
Reply
(2017-12-28, 12:02)schapplm Wrote: The procedure of the addon for a database file on a network share is to copy it on the local filesystem (.kodi/userdata/addon_data/service.watchedlist/dbcopy or a similar path). Then the addon runs as normal and copies the file back to the network share.
So my guess is, that already the part of copying does not work for you. If you enable the debug logging (for kodi and watchedlist), your log file should contain something similar to this:

 Hello @schapplm ,

Thanks for the reply
From What I understood, the local part of the db file was failing.
Here is what I got in the log after turning debugging on:
 
Quote: 17:49:23.138 T:2123888928 NOTICE: service.watchedlist: Update Library Manual Run.
17:49:23.300 T:2123888928 NOTICE: service.watchedlist: created directory /storage/emulated/0/Android/data/org.xbmc.kodi/files/.kodi/userdata/addon_data/service.watchedlist/dbcopy
17:49:23.305 T:2123888928 DEBUG: CSMBFile::Open - opened smb://READYNAS/Backups/Kodi/watchedList_Kodi_addon/Backups/watchedlist.db, fd=10001
17:49:23.312 T:2123888928 DEBUG: CSMBFile::Close closing fd 10001
17:49:23.313 T:2123888928 DEBUG: service.watchedlist: copied db file smb://READYNAS/Backups/Kodi/watchedList_Kodi_addon/Backups/watchedlist.db -> /storage/emulated/0/Android/data/org.xbmc.kodi/files/.kodi/userdata/addon_data/service.watchedlist/dbcopy/watchedlist.db. Success: 1
17:49:23.315 T:2123888928 ERROR: service.watchedlist: Database error while opening /storage/emulated/0/Android/data/org.xbmc.kodi/files/.kodi/userdata/addon_data/service.watchedlist/dbcopy/watchedlist.db. 'file is encrypted or is not a database'
17:49:23.315 T:2123888928 NOTICE: service.watchedlist: Notification. Watchedlist: SQLite Error (WL DB): file is encrypted or is not a database
17:49:23.322 T:2123888928 WARNING: SMBFile::OpenForWrite() called with overwriting enabled! - smb://READYNAS/Backups/Kodi/watchedList_Kodi_addon/Backups/watchedlist.db
17:49:23.324 T:18446744072108177696 DEBUG: ------ Window Init (DialogNotification.xml) ------
17:49:23.333 T:2123888928 DEBUG: CSMBFile::Close closing fd 10001
17:49:23.335 T:2123888928 DEBUG: service.watchedlist: copied db file /storage/emulated/0/Android/data/org.xbmc.kodi/files/.kodi/userdata/addon_data/service.watchedlist/dbcopy/watchedlist.db -> smb://READYNAS/Backups/Kodi/watchedList_Kodi_addon/Backups/watchedlist.db. Success: 1
17:49:23.336 T:2123888928 NOTICE: service.watchedlist: Notification. Watchedlist: Error: Error opening WL-database
17:49:23.343 T:2123888928 WARNING: SMBFile::OpenForWrite() called with overwriting enabled! - smb://READYNAS/Backups/Kodi/watchedList_Kodi_addon/Backups/watchedlist.db
17:49:23.352 T:2123888928 DEBUG: CSMBFile::Close closing fd 10001
17:49:23.354 T:2123888928 DEBUG: service.watchedlist: copied db file /storage/emulated/0/Android/data/org.xbmc.kodi/files/.kodi/userdata/addon_data/service.watchedlist/dbcopy/watchedlist.db -> smb://READYNAS/Backups/Kodi/watchedList_Kodi_addon/Backups/watchedlist.db. Success: 1
17:49:23.354 T:2123888928 INFO: CPythonInvoker(23, /storage/emulated/0/Android/data/org.xbmc.kodi/files/.kodi/addons/service.watchedlist/manual.py): script successfully run
17:49:23.673 T:2123888928 INFO: Python script stopped
17:49:23.674 T:2123888928 DEBUG: Thread LanguageInvoker 2123888928 terminating  

Is there something I am missing?


Edit: I tried renaming the local file in /addon_data/... into .old: same issue, the newly created file is not accessible
Guigui
Reply
What you can try is:
  • copy the database file to a local folder and set WatchedList to use that local database file. By this we can check if this is related to the file itself or the network access (which could e.g. corrupt the file while copying with wrong permissions)
  • If the problem seems to be the file: Open the database file with a program like sqliteman, as described in the wiki.
  • If you can open the file with the other tool but not with Kodi/WatchedList, then it might be a version issue of the python sqlite3 module. Then the easiest thing for you is to create a new file: Just set the addon to use a file that does not exist and start it. After the first run which creates a new file, you can insert your data from the old file again using Export/Import syntax similar to this wiki subsection
My addon: service.watchedlist
My HTPC: Kodi 17.6; 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
Reply
@schapplm
Great addon. Just switched from nfo watchedstate updater to this. Very clean and well done! Smile

Small typo in us english: Settings "Startup delay beforE action [minutes]"
Missing the "e" at the end of "before".

Thanks again!
A Confluence ZEITGEIST (Modernized Confluence Skin)
Reply
Hello, Thank you for a superb addon, I have been using WatchedList for years.

I have a question around the Dropbox integration, which I have recently started using due to some form of issue I have with accessing the network located DB file. The dropbox integration is exactly what I needed and it worked very well for me on my system (OpenELEC). The problem is that I have had some strange issues with OpenELEC, so I tried LibreELEC, which solved my problems with OpenELEC (display issues).

My problem is that when I installed Watchedlist, and tried to configure Dropbox support, when I tried to setup the Dropbox API key, I get an error stating Dropbox API error in the top right hand corner of the screen. I thought it was strange, because I have never seen this on OpenELEC. I configured it fine before, and again on my Android device, and it worked fine. I then added a discreet GPU and installed OpenELEC (solving my display issues), but found that watchedlist did the same thing as with LibreELEC.

I assume it is a fault with Python, because when I viewed the log I found the following error:07:43:30.639 T:140070029313792 ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<--- NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!Error Type: <type 'exceptions.ImportError'>Error Contents: No module named pkg_resourcesTraceback (most recent call last):File "/storage/.kodi/addons/script.module.dropbox/authenticate.py", line 10, in <module>from lib.dropbox import DropboxOAuth2FlowNoRedirectFile "/storage/.kodi/addons/script.module.dropbox/lib/dropbox/__init__.py", line 3, in <module>from .dropbox import __version__, Dropbox, DropboxTeam, create_session # noqa: F401File "/storage/.kodi/addons/script.module.dropbox/lib/dropbox/dropbox.py", line 35, in <module>from .session import (File "/storage/.kodi/addons/script.module.dropbox/lib/dropbox/session.py", line 1, in <module>import pkg_resourcesImportError: No module named pkg_resources-->End of Python script error report<--
Any assistance getting the Dropbox API working please, this will be greatly appreciated.
Reply
(2017-12-31, 13:06)Original-MrBee Wrote: ... My problem is that when I installed Watchedlist, and tried to configure Dropbox support, when I tried to setup the Dropbox API key, I get an error stating Dropbox API error in the top right hand corner of the screen ...
The Dropbox authentification mechanism seems to be broken for Android devices. LibreElec seems to be a full linux distribution, but perhaps with a reduced set of python libraries. (I don't use it so I am not sure there).
Can you make sure, that you have the newest version of the dropbox module? Look in the .kodi/addons/script.module.dropbox/addon.xml. The current version should be 8.4.1, where an import error was fixed for the authentification.

A quick workaround could be to do the authentification on a Windows or Ubuntu machine and then just copy the entry dropbox_apikey of .kodi/userdata/addon_data/service.watchedlist/settings.xml

P.S. Please format your log output (e.g. as quote) for better readability and for avoiding eye cancer :-)
My addon: service.watchedlist
My HTPC: Kodi 17.6; 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
Reply
(2017-12-29, 11:03)schapplm Wrote: What you can try is:
  • copy the database file to a local folder and set WatchedList to use that local database file. By this we can check if this is related to the file itself or the network access (which could e.g. corrupt the file while copying with wrong permissions)
  • ...
 
  
Thanks for the answer, all the .db files are now empty.

Another thing that might help: I face the same issue when I set a brand new destination folder, the result is always the same: a file 8 Kb is created (watchedlist.db or anything that I specify) but the error is the same.

From what I see the old files that have been backuped by the system were 90 Kb.

I'll try to generate a local .db file but from my previous tests it worked flawlessly.

I'll also try to create a local file at the temporary destination before it is transfered to the SMB to see if in this case it works.

Guigui
Reply
  •   
  • 1
  • 12
  • 13
  • 14
  • 15
  • 16(current)
 
Thread Rating:
  • 2 Vote(s) - 5 Average



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