[black_eagle]

It identifies the paths to delete no worries, but then fails to delete them.

Ah, in that case it might have something to do with the way it changes from the SELECT statement to the DELETE statement.  Because it has to work with both MySQL and SQLite I seem to recall it was a little tricky at first to get it to format a command that both db types could use.  There are some slight differences between the syntax of the two.  There are also things you can do in SQLite that won't work in MySQL and vice-versa. As it can produce it's own debug log, you should be able to look in there to see the commands that were executed and then try them in the db's interface to see what results that gives.  Probably returns a set of zero items if it's not deleting something where the SELECT statement does return a set.

[kenmills]

It identifies the paths to delete no worries, but then fails to delete them.

Ah, in that case it might have something to do with the way it changes from the SELECT statement to the DELETE statement.  Because it has to work with both MySQL and SQLite I seem to recall it was a little tricky at first to get it to format a command that both db types could use.  There are some slight differences between the syntax of the two.  There are also things you can do in SQLite that won't work in MySQL and vice-versa. As it can produce it's own debug log, you should be able to look in there to see the commands that were executed and then try them in the db's interface to see what results that gives.  Probably returns a set of zero items if it's not deleting something where the SELECT statement does return a set.

Ah, that is great info thx!  I'll start looking there first ...

[Mahava]

Just updated the code a little more, as the latest Matrix 9.1 threw errors.  It works again now, so if you update to the latest Kodi, you'll need to re download and install the latest 1.0.1 

Let me know if you have any problems with the add-on and I'll see what I can do.

Thanks for this fork.   Was wondering why it doesn't have an icon.  I'm displaying program addons on home page widget as 'squares', but this has only a generic kodi open box icon.

Hey!  Hmm... I'm not sure, it looks fine on my install.  It may be a file type issue, I'll look into that.  Thanks!

I fixed it by adding an 'assets' tag to addon.xml under the extension point group:

<assets>
             <icon>icon.png</icon>
             <fanart>fanart.png</fanart>
             <screenshot></screenshot>
</assets>

then restarted kodi and the proper icon is showing now.   Sorry, I do have a github account but don't know how to make the change there.

[kenmills]

Thanks for this fork.   Was wondering why it doesn't have an icon.  I'm displaying program addons on home page widget as 'squares', but this has only a generic kodi open box icon.

Hey!  Hmm... I'm not sure, it looks fine on my install.  It may be a file type issue, I'll look into that.  Thanks!

I fixed it by adding an 'assets' tag to addon.xml under the extension point group:

<assets>
             <icon>icon.png</icon>
             <fanart>fanart.png</fanart>
             <screenshot></screenshot>
</assets>

then restarted kodi and the proper icon is showing now.   Sorry, I do have a github account but don't know how to make the change there.

Good catch  I updated the Github, thanks!

[kenmills]

OK, the GitHub has been updated with the latest version of the Database Cleaner.  I think we can now take it out of BETA stage as it has been tested extensively. 

I joined forces with a seasoned Python developer, who wishes to remain off the scene, but I added his name in the addon as he really did the tricky stuff!

We incorporated the texturescache.py file (by Milhouse) to help in the cleanup.  Also we built a Deep Clean option, for those pesky database entries that won't go away :-)

I edited the text in the addon, as per recommendations.

Please try it out and let me know what you think and let me now if there is any documentation that needs to be improved.

Cheers!
Ken

[Klojum]

@kenmills

Does that mean we can basically close our other forum thread on this subject?
Otherwise having two threads gets a bit confusing.

[C.O.D.]

Hey!  Hmm... I'm not sure, it looks fine on my install.  It may be a file type issue, I'll look into that.  Thanks!

I fixed it by adding an 'assets' tag to addon.xml under the extension point group:

<assets>
             <icon>icon.png</icon>
             <fanart>fanart.png</fanart>
             <screenshot></screenshot>
</assets>

then restarted kodi and the proper icon is showing now.   Sorry, I do have a github account but don't know how to make the change there.

Good catch  I updated the Github, thanks!

Are you sure? There's no icon in version 3.0 and no assets tags..?

[kenmills]

I fixed it by adding an 'assets' tag to addon.xml under the extension point group:

<assets>
             <icon>icon.png</icon>
             <fanart>fanart.png</fanart>
             <screenshot></screenshot>
</assets>

then restarted kodi and the proper icon is showing now.   Sorry, I do have a github account but don't know how to make the change there.

Good catch  I updated the Github, thanks!

Are you sure? There's no icon in version 3.0 and no assets tags..?

Argh sorry.  That was done before I started using github desktop and must have gotten overwritten.  Re-added, thx!

[kenmills]

@kenmills

Does that mean we can basically close our other forum thread on this subject?
Otherwise having two threads gets a bit confusing.

Yes of course, thx!  I just posted on  there to close the thread and move over here :-)

[C.O.D.]

@kenmills
No problem, thanks too (especially for the addon)

[kenmills]

@kenmills
No problem, thanks too (especially for the addon)

You are very welcome, I am glad to give back to the community.  And I actually enjoyed the process 

[Klojum]

We incorporated the texturescache.py file (by Milhouse) to help in the cleanup

I haven't looked closely at this yet ( all colors of 5G waves are dancing around me at the moment ), but did you copy the whole routines of texturescache into the Video Database Cleaner, or do users have to separately download the texturescache.py file so it can be imported as an external routine?

Milhouse has left the Kodi scene, but his tool may still be developed further as a standalone tool by others. Python-2 to Python-3 support for starters..?

[kenmills]

We incorporated the texturescache.py file (by Milhouse) to help in the cleanup

I haven't looked closely at this yet ( all colors of 5G waves are dancing around me at the moment ), but did you copy the whole routines of texturescache into the Video Database Cleaner, or do users have to separately download the texturescache.py file so it can be imported as an external routine?

Milhouse has left the Kodi scene, but his tool may still be developed further as a standalone tool by others. Python-2 to Python-3 support for starters..?

The texturecache.py has been converted for Python 3 an has been included.  We incorporated the ability to change the main features in the cfg file within the Database Cleaner addon as also the ability to run the texturecache after the DB Cleaner runs.

[kidbizkit]

Is it safe to install and use this now?

[kenmills]

Is it safe to install and use this now?

Hey - for Matrix yes.