[m4x1m]

Thanks for this mate -- exactly what I've been looking for. With the latest release however, I don't get a response from any of the options on the menu. I click the buttons for each option, and nothing happens. Any idea what I may be doing wrong? Thanks.

---

Never mind my post above -- looking at the log file it would appear the process starts, but there's no visual inidication that the plugin starts -- at least not in the skin I'm using (Arctic II).

Could you post a debug log?

[Middle]

found something,
doing query delete, it cant delete if the file path has ' in the name.

Code:

20:37:08 T:4036   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: near "N": syntax error
                                            Traceback (most recent call last):
                                              File "C:\Users\Fabio\AppData\Roaming\XBMC\addons\script.thumbnailscleaner\resources\lib\tcQueryGui.py", line 83, in onClick
                                                cachedUrl = RawXbmcDb.query( "SELECT cachedurl FROM texture WHERE url='" + url + "'" )
                                              File "C:\Users\Fabio\AppData\Roaming\XBMC\addons\script.thumbnailscleaner\resources\lib\tcCommon.py", line 66, in query
                                                cursor.execute( str )
                                            OperationalError: near "N": syntax error
                                            -->End of Python script error report<--

this is the file name example

Code:

http://static-cdn.jtvnw.net/ttv-boxart/Ghosts%20'N%20Goblins-272x380.jpg

[m4x1m]

found something,
doing query delete, it cant delete if the file path has ' in the name.

Thanks, I will fix this bug in the next release, but you must wait this weekend.

[m4x1m]

New Version
script.thumbnailscleaner-1.1.0.zip

Code:

v1.1.0:
- Fixed bug related to the query for delete textures.

[Middle]

New Version
script.thumbnailscleaner-1.1.0.zip

Code:

v1.1.0:
- Fixed bug related to the query for delete textures.

All looking good now, no problem so far doing query deletes. Thanks.
The only thing is that when i select all and hit delete button there is no pop up dialog or any info telling me that all went OK or not, instead it pops keyboard dialog again. not sure if this is normal behavior.

[m4x1m]

All looking good now, no problem so far doing query deletes. Thanks.
The only thing is that when i select all and hit delete button there is no pop up dialog or any info telling me that all went OK or not, instead it pops keyboard dialog again. not sure if this is normal behavior.

Yes is normal.
When you click the delete button, the script, after deleting, resends the query, if the query does not produce any other result (for example when you delete all) the virtual keyboard is showed for a new query.

[Anjel]

if i run xbmc on multiple platforms, 2x XIOS machines on xiosbmc, and 1x windows box running xbmc, all shared on 1 sql database do i just have to update one with this script and it will adjust the rest or do i have to redo this on all machines?

[m4x1m]

if i run xbmc on multiple platforms, 2x XIOS machines on xiosbmc, and 1x windows box running xbmc, all shared on 1 sql database do i just have to update one with this script and it will adjust the rest or do i have to redo this on all machines?

I can't test this situation, I don't know if works. If you want to try and let us know, please make a backup (texture database and thumbnails folder)

In any case in the log you find the folder and the database path that the script try to use, you can check if all is correctly!

[ctawn]

Can this now be used in theory to clean ONLY thumbnails generated by video add-ins? I tried setting everything BUT add-ins to "disable" and run simulate. Result:

it showed a list of paths that were on networked volumes that were clearly NOT add-in generated. Then it crashed.

[m4x1m]

Can this now be used in theory to clean ONLY thumbnails generated by video add-ins? I tried setting everything BUT add-ins to "disable" and run simulate. Result:

it showed a list of paths that were on networked volumes that were clearly NOT add-in generated. Then it crashed.

This script cleans everything that isn't in the video or music database. The setting to disable, is a previous request by a user for make the operation faster. If, for example, you don't use xbmc for the music or if you isn't set any image for the genres, and much more. Pay attention, if you disable, for example, music artists, the script remove all artist thumbs if exist. In the log, you can find the two path that the script try to use, one for thumbnails folder and another one for the database Texture13.db

Remember that the script is tested only with Frodo! Could you post the log when the script is crashed??

[ctawn]

Can this now be used in theory to clean ONLY thumbnails generated by video add-ins? I tried setting everything BUT add-ins to "disable" and run simulate. Result:

it showed a list of paths that were on networked volumes that were clearly NOT add-in generated. Then it crashed.

This script cleans everything that isn't in the video or music database. The setting to disable, is a previous request by a user for make the operation faster. If, for example, you don't use xbmc for the music or if you isn't set any image for the genres, and much more. Pay attention, if you disable, for example, music artists, the script remove all artist thumbs if exist. In the log, you can find the two path that the script try to use, one for thumbnails folder and another one for the database Texture13.db

Remember that the script is tested only with Frodo! Could you post the log when the script is crashed??

Wow so you're saying if you disable the movies, you are actually removing ALL movie thumbnails? that really doesn't make a whole lot of sense. Shouldn't it do exactly the opposite: skip the whole category and keep all of its thumbnails? That's very confusing. Maybe instead of "disable" you should say "delete all in this category".

what exactly is "everything" that "isn't in the video or music database"? Are you saying these databases clean their indexes but leave the cached files orphaned?

PS: I am using this with Frodo and will need to run it again with same settings and debug mode on. (just checked xbmc.log.old and it has nothing relevant).

[m4x1m]

Wow so you're saying if you disable the movies, you are actually removing ALL movie thumbnails? that really doesn't make a whole lot of sense. Shouldn't it do exactly the opposite: skip the whole category and keep all of its thumbnails? That's very confusing. Maybe instead of "disable" you should say "delete all in this category".

The script works for exclusion (First post). First reads all files that are present in your thumbnails folder then reads all fields that are present in the texture13.db and store them in 2 array.
The script sends JOSN queries for everything about art thumbs fanart then remove from the 2 array stored previously.
"Disable CHECKING for the movies" if you want to turn off the control for the exclusion.

what exactly is "everything" that "isn't in the video or music database"? Are you saying these databases clean their indexes but leave the cached files orphaned?

At the end, the script show you what wants to delete and you can select what you want to keep (from texture13.db).
No, all orphans files or files linked to the deleted fields from texture db will moved to your selected destination folder. Same thing when you use the QUERY button for delete textures.

PS: I am using this with Frodo and will need to run it again with same settings and debug mode on. (just checked xbmc.log.old and it has nothing relevant).

Every log starts with [Thumbnails Cleanaer] although, in the end, it tells you only what is checking and what found.

I hope I was clear, english is not my mother language.

[ctawn]

I hope I was clear, english is not my mother language.

Unfortunately it's not too clear to me, but it's probably the technical aspects and not your English, which is pretty good.

I tried again and this time I only selected the "disable" option for music albums and songs. It ran through the simulation, but then still presented a list of many files that are located on networked volumes. I could not do anything with this list. It would not scroll, and I could not select ALL or NONE. Then the ATV crashed. Here's the log up to the crash.

I'm not sure this can do what I need it to even if it worked. Can you please explain how I can delete only the thumbnails generated as previews by video add-ons, and not touch anything else?

[m4x1m]

Unfortunately it's not too clear to me, but it's probably the technical aspects and not your English, which is pretty good.

I tried again and this time I only selected the "disable" option for music albums and songs. It ran through the simulation, but then still presented a list of many files that are located on networked volumes. I could not do anything with this list. It would not scroll, and I could not select ALL or NONE. Then the ATV crashed. Here's the log up to the crash.

I'm not sure this can do what I need it to even if it worked. Can you please explain how I can delete only the thumbnails generated as previews by video add-ons, and not touch anything else?

I analyzed the debug log and the script isn't crashed. Probably the result list is very long and this can a little bit slowing xbmc, for this seem to be blocked, try to wait.
The script can't delete particular thumbnails, but excludes all thumbnails present in database (the list is on the first post) and then deletes the remained files (previews generated when you browse the folders, previews generated if you use artwork downloader, youtube etc). You can exclude particulars file or folder by adding a pattern in addons settings - extra (for exclude all extrafanarts) logo.png cdart.png that actually aren't stored in database - this is the default value. Also you can use QUERY button to delete particular textures.

[ctawn]

I analyzed the debug log and the script isn't crashed. Probably the result list is very long and this can a little bit slowing xbmc, for this seem to be blocked, try to wait.
The script can't delete particular thumbnails, but excludes all thumbnails present in database (the list is on the first post) and then deletes the remained files (previews generated when you browse the folders, previews generated if you use artwork downloader, youtube etc). You can exclude particulars file or folder by adding a pattern in addons settings - extra (for exclude all extrafanarts) logo.png cdart.png that actually aren't stored in database - this is the default value. Also you can use QUERY button to delete particular textures.

Well, XBMC itself crashes. But anyway, how could I use the QUERY button to delete only images from video add-ons?