[RELEASE] Texture Cache Maintenance utility
I will try to reproduce the problem I'm having, step by step.

(2016-03-28, 23:29)Milhouse Wrote:
(2016-03-28, 15:58)ifsnop Wrote: Other is to delete the Textures13.db file, and reboot Kodi.

Textures13.db has nothing to do with NFO files.

True, I meant " .kodi/userdata/Database/MyVideos93.db"

(2016-03-28, 23:29)Milhouse Wrote: Maybe you're calling it incorrectly, are you specifying @qa.nfo.refresh with an integer value (number of days relative to today), eg. "@qa.nfo.refresh=0" to refresh any NFO changed since midnight, or "@qa.nfo.refresh=1" to refresh any NFO changed since midnight of the previous day, etc.?

To refresh your collection sets you would want to run something like:
Code:
texturecache.py qa movies @qa.nfo.refresh=0

If you still have problems upload a log (add "@logfile=tc.log" to the command line, and upload tc.log somewhere).

One of the movies I have was miss detected by Media Companion. After Kodi updated the library with the wrong information, I corrected the nfo file from within Media Companion. Now, I have no way to tell Kodi to re-read the corrected nfo file (with rescraping the full collection). Using texturecache:

Code:
# /storage/texturecache.py qax movies @qaperiod=9999 @qa.nfo.refresh=0 @logfile=tc.log
Successfully updated from v2.2.9 to v2.3.0
Movie    [Kolchak                                           ]: WARN (missing nfo; missing fanart, local not found)

Looking inside the database, there are two entries in the movie table, pointing to the same file.
Code:
# echo "select idMovie, idFile,c00,c22 from movie where c22 like '%El último hombre... viv%';"
| sqlite3 MyVideos93.db
23|4895|Kolchak|smb://192.168.0.200/hdfilms/7/mkv_7/ciencia ficción/El último hombre... vivo (1974) Charlton Heston, Anthony Zerbe, Rosalind Cash, Paul Koslo, Lincoln Kilpatrick.dual.subs.mkv
126|6803|El último hombre... vivo|smb://192.168.0.200/hdfilms/7/mkv_7/ciencia ficción/El último hombre... vivo (1971) Charlton Heston, Anthony Zerbe, Rosalind Cash, Paul Koslo, Lincoln Kilpatrick.dual.subs.mkv

Only to verify:

Code:
# echo "select * from files where idFile = '4895';" | sqlite3 MyVideos93.db  | more
4895|341|El último hombre... vivo (1974) Charlton Heston, Anthony Zerbe, Rosalind Cash, Paul Koslo, Lincoln Kilpatrick.dual.subs.mkv|||2015-04-09 10:46:10
# echo "select * from files where idFile = '6803';" | sqlite3 MyVideos93.db  | more
6803|341|El último hombre... vivo (1971) Charlton Heston, Anthony Zerbe, Rosalind Cash, Paul Koslo, Lincoln Kilpatrick.dual.subs.mkv|||2015-04-09 10:46:10

Is there an option within texturecache to delete the wrong movie entry?

Thanks in advance!
Reply
 
Thread Rating:
  • 17 Vote(s) - 4.76 Average


Messages In This Thread
Crash on Gotham on OS X - by desepticon - 2014-05-29, 17:57
RE: [RELEASE] Texture Cache Maintenance utility - by ifsnop - 2016-04-10, 23:31
Cleaning - by AleisterHH - 2018-05-28, 22:03
RE: Cleaning - by Milhouse - 2018-05-28, 22:16
qax genre not updated - by Just-Me_A-User - 2018-06-12, 22:06
RE: qax genre not updated - by Milhouse - 2018-06-12, 23:40


Logout Mark Read Team Forum Stats Members Help
[RELEASE] Texture Cache Maintenance utility4.7617