Login at Kodi Home

Mychale · 2019-01-25, 11:50

Hello all and a belated HNY 2019!

Well, I just stumbled across this gem of an addon that I didn't know existed, and I'm sad to say, having an issue of it not removing the stuff it lists. The list is perfect, showing the stuff I exactly need to remove. I feel if it removed all listed, my issue would be resolved too. Not sure why/what is causing the issue.

I run the addon, it shows 2039 DB issues, the ones I am having trouble with are listed, I click clean, script ends. Run it again, and it shows 2039 issues in DB again, click clean, script ends successfully, says to run Clean DB now, and over and over it goes.

Anyone else getting this issue? I have version 5.9 of the script installed on Kodi Leia RC5. MySQL on NAS with Media SMB links to my sources.
I keep checking both log files and during the clean library process, the URLs are still showing listed. The script.database.cleaner log is showing the listings as well, but nothing seems to get removed when I click the Clean button

Thank you.

C.O.D. · (This post was last modified: 2019-01-27, 12:35 by C.O.D..)

Hello,
since I'm on Leia RC5 (LibreELEC 8.95.003 / KODI 18.0 RC5) the addon aborts starting with an error. Subsequently a new 0 byte database file with the name MyVideos36.db is created.
The log file shows this:

11:19:07.372 T:1110221680 ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<--
- NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!
Error Type: <class 'sqlite3.OperationalError'>
Error Contents: no such table: path
Traceback (most recent call last):
File "/storage/.kodi/addons/script.database.cleaner/default.py", line 680, in <module>
cleaner_log_file(our_select, False)
File "/storage/.kodi/addons/script.database.cleaner/default.py", line 285, in cleaner_log_file
cursor.execute(our_select)
OperationalError: no such table: path
-->End of Python script error report<--

Is this due to database version changes from this new KODI version?

Thanks and best regards

sullysnet · 2019-02-03, 01:29

thanks for the script, I will need this. Can I install this right inside Kodi pointing it at the zip I downloaded?

sullysnet · 2019-02-03, 21:20

I actually got it to work. Is there one for the audio too? thanks

Mychale · 2019-02-05, 14:03

Anyone still monitoring this thread? Still looking for some help with this issue.

Thanks.

meddlingbanter · 2019-02-06, 07:31

(2019-01-25, 11:50)Mychale Wrote: Hello all and a belated HNY 2019!

Well, I just stumbled across this gem of an addon that I didn't know existed, and I'm sad to say, having an issue of it not removing the stuff it lists. The list is perfect, showing the stuff I exactly need to remove. I feel if it removed all listed, my issue would be resolved too. Not sure why/what is causing the issue.

I run the addon, it shows 2039 DB issues, the ones I am having trouble with are listed, I click clean, script ends. Run it again, and it shows 2039 issues in DB again, click clean, script ends successfully, says to run Clean DB now, and over and over it goes.

Anyone else getting this issue? I have version 5.9 of the script installed on Kodi Leia RC5. MySQL on NAS with Media SMB links to my sources.
I keep checking both log files and during the clean library process, the URLs are still showing listed. The script.database.cleaner log is showing the listings as well, but nothing seems to get removed when I click the Clean button

Thank you.

I was having the same symptoms as you. I would run the add-on over and over and it would have the same amount of entries to be removed. My issue turned out to be the database it was trying to clean. It was trying to clean an old database rather than the latest. In Settings, I had to go to Advanced and enable "Force database name" and set the database to MyVideos116. Once I did that it cleaned everything up and the built-in database cleaning now takes < 5 seconds.

Mychale · 2019-02-07, 03:41

@meddlingbanter - OMG, I never saw this and now it is so blatantly obvious. I ran the script again and did notice it was pulling from myvideos113, so I changed it to myvideos116 as you suggested and all is well with the world! Thank you, Thank you, I can't say it enough, THANK YOU SIR! Genius!

Tarkus_ · (This post was last modified: 2019-02-07, 06:34 by Tarkus_.)

Just barely discovered this wonderful addon today while researching the issue with slow cleanup of my database. On my Fire TV Stick, it's been an all-day project to run the cleanup. In fact, earlier today I had it running for 6 hours and it was only up to 18%! I quit and decided to look for a better way, which is how I found myself here.

Tried it on SPMC and it worked great right off the bat. Wasn't working on Kodi until I saw the issue others were having about it not using the correct database. Once I set the database name in settings, it worked great. Cleanup of 25,000+ entries took about a minute instead of all day! This addon is a godsend!

Question: I have 7 MyVideos* databases in my Database folder. Can I delete all but the highest numbered one? That's the one I directed this addon to use.

Thanks!

**Karellen** · 2019-02-07, 06:57

(2019-02-07, 06:33)Tarkus_ Wrote: Question: I have 7 MyVideos* databases in my Database folder. Can I delete all but the highest numbered one?

Should be safe, unless you have updated and then rolled back an update.

Be safe and check the correct versions here... https://kodi.wiki/view/Databases#Database_Versions

Tarkus_ · 2019-02-07, 07:08

(2019-02-07, 06:57)Karellen Wrote:
(2019-02-07, 06:33)Tarkus_ Wrote: Question: I have 7 MyVideos* databases in my Database folder. Can I delete all but the highest numbered one?
Should be safe, unless you have updated and then rolled back an update.

Be safe and check the correct versions here... https://kodi.wiki/view/Databases#Database_Versions

Thanks, that's very helpful! I have extra databases from the other types too, so it will be nice to get those pared to down to only what I need.

Thanks again!

glubbish · 2019-02-07, 13:27

Oddly with v18, I force MyVideos116 (as it wants MyVideos107 by default) and the startup screen shows MyVideos36
It however uses 116 and works.

MAX404 · 2019-02-25, 22:26

Hi everyone

I installed this add on on my Nvidia Shield TV Pro running a Kodi version 18.1 , with Guilouz skin on top , i could not make it work , every time i run it I got error:

No sources.xml
Cleaner error

I selected and deselected both of this options

Sources
Uses sources.xml to determine files to keep - STRONGLY recommended. Otherwise the database clean will remove only rtmp:// rtmpe:// addon:// http:// references
Uses sources.xml on this machine - lets you supply a list of sources from a different location (needed for MySQL users, shared sources.xml, network locations, etc)

but the result is the same, I do not have a sources.xml

What I am doing wrong?

MAX404 · 2019-02-25, 22:31

Sorry , I forgot to add the log...

https://pastebin.com/qMnXnqHt

rrrevin · 2019-02-28, 17:49

Anyone else having issues getting this to run under Leia 18.0? (Libreelec 9.0.0).
Was working perfectly under 17.6 (Whatever version of Libreelec that was).

When I run the add-on, it continually shows 662 items to clean up, but doesn't actually do it. Next run shows the same 662 items.
Is this something new to Leia?

rrrevin · 2019-02-28, 17:57

(2019-02-28, 17:49)rrrevin Wrote: Anyone else having issues getting this to run under Leia 18.0? (Libreelec 9.0.0).
Was working perfectly under 17.6 (Whatever version of Libreelec that was).

When I run the add-on, it continually shows 662 items to clean up, but doesn't actually do it. Next run shows the same 662 items.
Is this something new to Leia?

Found the posts above that state to force the database name under settings to MyVideos116. This worked! Smile

BUT.. 2 things:
1) The run screen still shows "MyVideos107" as the database to use, even though I updated it in Setting to MyVideos116
2) Could this add-on be changed to determine which database name to use instead of having people force it in settings?