[Pisomojado]

Hmm... I used your video database cleaner v0.5.9.  It took 8 hours.  Then I started it again, and it looks the same as when I began.  It still says on the summary window "Database is - MyVideos107 There are 1406 entries to be removed"

[MAX404]

Hmm... I used your video database cleaner v0.5.9.  It took 8 hours.  Then I started it again, and it looks the same as when I began.  It still says on the summary window "Database is - MyVideos107 There are 1406 entries to be removed"

hi mate

There is a newer version (0.61) try it and see if it work better , download it from here

[Pisomojado]

AMAZING!!!  What took 8 hours to fail yesterday took 8 SECONDS to succeed today!  I love it! Thank you very much.  Please put this update in your repo for schmoes like me.

[MAX404]

AMAZING!!!  What took 8 hours to fail yesterday took 8 SECONDS to succeed today!  I love it! Thank you very much.  Please put this update in your repo for schmoes like me.

Better late than never..... Glad it worked

[nojoe]

Hi, i'm trying to drop only some old reference rows from the MyVideos116.db -> tvshow table but i doesn't really know how.
This addon here doesn't help. Doing something wrong?

[Skerlnik]

Hello!  I attempted to use V0.6.1 with Kodi 19 (by changing the xbmc.python dependency version to 3.0.0 in the addon.xml), but of course it didn't work.  Is there any chance of getting an updated script that works for Kodi 19?  I see they're still on MyVideos116.db.

On a side note, there is a script error on like 543:

except Exception,e:

Thanks!

[scott967]

Hello!  I attempted to use V0.6.1 with Kodi 19 (by changing the xbmc.python dependency version to 3.0.0 in the addon.xml), but of course it didn't work.  Is there any chance of getting an updated script that works for Kodi 19?  I see they're still on MyVideos116.db.

On a side note, there is a script error on like 543:

except Exception,e:

Thanks!

I can take a quick look. the syntax for exceptions changes 2/3 and that's an easy fix.

scott s.
.

[Skerlnik]

Hello!  I attempted to use V0.6.1 with Kodi 19 (by changing the xbmc.python dependency version to 3.0.0 in the addon.xml), but of course it didn't work.  Is there any chance of getting an updated script that works for Kodi 19?  I see they're still on MyVideos116.db.

On a side note, there is a script error on like 543:

except Exception,e:

Thanks!

I can take a quick look. the syntax for exceptions changes 2/3 and that's an easy fix.

scott s.
. 

Hi Scott,

I am a long time coder, but Py is new to me   I have been trying to update this script to make it function with Kodi 19, but no luck yet.  There is a py3 compatible version of script.module.myconnpy at https://forum.kodi.tv/showthread.php?tid=349745, since Kodi 19 ships with the xbmc.python addon version 3.0.0.  

I've also run the default.py source through the 2to3 script that comes with the Python3 tools, and thankfully it didn't change much (just some unicode types).  

The script does bomb at line 177 though:

 Error Contents: 'str' object has no attribute 'decode'
                                            Traceback (most recent call last):
                                              File "C:\Users\***\AppData\Roaming\Kodi\addons\script.database.cleaner\default.py", line 177, in <module>
                                                addonpath = addon.getAddonInfo('path').decode('utf-8')
                                            AttributeError: 'str' object has no attribute 'decode'

I'm wondering if this Addon() method has changed with Kodi versions:

(line 174) addon = xbmcaddon.Addon()

Hope this info helps you!

[scott967]

I updated the script, while I was at it I updated the assets, language, and settings.  The new settings format isn't working 100% but you can just use the current settings.xml.  You can get it from a Matrix_py3 branch I created on a fork.  I don't use this at all so no idea if it works right.  Here is a link to my github repo fork:  https://github.com/scott967/script.datab...Matrix_py3

Again, make sure you get the Matrix_py3 branch, not master.  If this is working for you I will PR it over to black_eagle.

I might mention that the Kodi python interface used to get/return utf-8 encoded bytes but now does unicode strings.  Py2 code can still use the old methods via the kodi-six module that's available, but IMHO since a unique version is needed for Matrix anyway, I don't see much reason to keep 2/3 compatibility.  I might need to go back and check what is being written out to files, as without explicit encoding py3 will write text to files using a default encoding.

scott s.
.

[Skerlnik]

I updated the script, while I was at it I updated the assets, language, and settings.  The new settings format isn't working 100% but you can just use the current settings.xml.  You can get it from a Matrix_py3 branch I created on a fork.  I don't use this at all so no idea if it works right.  Here is a link to my github repo fork:  https://github.com/scott967/script.datab...Matrix_py3

Again, make sure you get the Matrix_py3 branch, not master.  If this is working for you I will PR it over to black_eagle.

I might mention that the Kodi python interface used to get/return utf-8 encoded bytes but now does unicode strings.  Py2 code can still use the old methods via the kodi-six module that's available, but IMHO since a unique version is needed for Matrix anyway, I don't see much reason to keep 2/3 compatibility.  I might need to go back and check what is being written out to files, as without explicit encoding py3 will write text to files using a default encoding.

scott s.
.

I have tested this, and then compared the backup DB to the modified DB, and it indeed works!!  Thank you for your great work Scott!

[black_eagle]

@scott967 Thanks very much

[reids]

O M G Thank you so much for this, worked beautifully.

[Rouzax]

I've installed this from the github https://github.com/the-black-eagle/scrip...r/releases version 0.6.1
Did a clean and I did see it removed some entries from my database but I still see entries in the files and path to shows that I know are not on the filesystem anymore.

How do I clean those out?

[bobdude]

Hmm... I used your video database cleaner v0.5.9.  It took 8 hours.  Then I started it again, and it looks the same as when I began.  It still says on the summary window "Database is - MyVideos107 There are 1406 entries to be removed"

hi mate

There is a newer version (0.61) try it and see if it work better , download it from here 

Hi there,
I just tried your script, but it says the advancedsettings.xml may be malformed. I connect to a mysql database on a NAS. Kodi connects fine. What is the issue here? Unfortunately I can't find the database-cleaner-log. Debugging just tells me the same thing (malformed settings).
So what can I do?

many thanks in advance :-)

[black_eagle]

@bobdude Please post a copy of your advancedsettings.xml to https://paste.kodi.tv . If the addon is flagging it as an issue then it's likely either a closing tag is missing somewhere or a comment in it is incorrectly formed.  Without seeing the file though that's just a guess.