[RELEASE] Texture Cache Maintenance utility - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33) +--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116) +--- Thread: [RELEASE] Texture Cache Maintenance utility (/showthread.php?tid=158373) Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
|
RE: [RELEASE] Texture Cache maintenance utility - Milhouse - 2013-03-18 Updated to version 0.1.5. Added "p" option (prune) to identify and display cached files that are not present in the media library, eg. image/thumbnail previews that accumulate in the cache over time, or deleted movies/tv shows/music that remain in the texture cache even after cleaning the database. Option "P" will automatically remove these unnecessary files. This version also significantly improves the performance of option r/R, which identifies "orphaned" thumbnail files (ie. image files not referenced in the texture cache db) RE: [RELEASE] Texture Cache maintenance utility - Milhouse - 2013-03-20 Update to version 0.1.6. Added additional support for season-all-fanart.jpg and season-all-banner.jpg images. RE: [RELEASE] Texture Cache maintenance utility - charrua - 2013-03-23 Thanks for the great script, it's very useful. Running on Win8 with Python 2.7.3, XBMC 13.0a1 using a remote MySQL DB, I'm having an error with the c/C option, it downloads the first image fine, but then before getting the second image to download it returns the following error: Code: texturecache.py C movies "30 Days of Night" Any ideas to solve this problem? RE: Texture Cache interrogation utility - popcornmix - 2013-03-23 (2013-03-13, 17:54)MilhouseVH Wrote: Version 0.1.2 now up... when performing a "qa" check, only movies or tvshow episodes added during the previous 30 days will be considered. Increase/reduce this period by specifying a value (in days) for qaperiod in the properties file, eg. "qaperiod=9999" would effectively restore v0.1.1 behaviour which didn't restrict by period. Seemed to work great detecting missing information. The question is, is it possible to force a refresh (i.e. download new plot/rating/thumbnail) on the episodes with missing items? RE: [RELEASE] Texture Cache maintenance utility - Milhouse - 2013-03-23 (2013-03-23, 15:53)charrua Wrote: Any tips to solve this problem? Hi yes, I've just been debugging this with another forum member. Not sure why it happens, as I don't get it on either Ubuntu 12.10 or Raspberry Pi, but it seems necessary to close the web server connection between image requests. Can you try downloading the latest version (0.1.9): Code: rm ./texturecache.py and then add "webserver.singleshot = yes" to the properties file texturecache.cfg RE: [RELEASE] Texture Cache maintenance utility - charrua - 2013-03-23 (2013-03-23, 16:01)MilhouseVH Wrote:It's fixed, thanks a bunch for the quick answer and solution!(2013-03-23, 15:53)charrua Wrote: Any tips to solve this problem?Hi yes, I've just been debugging this with another forum member. Not sure why it happens, as I don't get it on either Ubuntu 12.10 or Raspberry Pi, but it seems necessary to close the web server connection between image requests. RE: Texture Cache interrogation utility - Milhouse - 2013-03-23 (2013-03-23, 15:56)popcornmix Wrote: Seemed to work great detecting missing information. Yes, it's possible, but not sure how effective it will be as it depends on the XBMC scraper replacing the missing information - from my experience defective meta-data can be incredibly "sticky"... I've added a "qax" option (it's in latest version 0.1.9), and it's experimental, but if you run it (eg. ./texturecache.py qax tvshows or ./texturecache.py qax tvshows "big bang", it also works for movies) then it will initiate a library rescan for those episode directories (eg. Season 5, Season 6 etc.) containing episodes that fail to pass QA - let me know how you get on... RE: [RELEASE] Texture Cache maintenance utility - Milhouse - 2013-03-23 (2013-03-23, 16:12)charrua Wrote: It's fixed, thanks a bunch for the quick answer and solution! I've just updated the latest version so that it shouldn't require the extra property - if it experiences a web connection problem it will switch to "single shot" mode, can you test this and let me know if it works (you'll need to remove the webserver.singleshot property from the configuration file first). RE: [RELEASE] Texture Cache maintenance utility - charrua - 2013-03-23 (2013-03-23, 17:01)MilhouseVH Wrote: I've just updated the latest version so that it shouldn't require the extra property - if it experiences a web connection problem it will switch to "single shot" mode, can you test this and let me know if it works (you'll need to remove the webserver.singleshot property from the configuration file first).The new version is running perfectly (at least in my environment) without the 'webserver.singleshot' property in the config file. I'm even running two instances at once without any problem. Great work! RE: [RELEASE] Texture Cache maintenance utility - Milhouse - 2013-03-23 Thanks for confirming! RE: [RELEASE] Texture Cache maintenance utility - jmarshall - 2013-03-23 MilhouseVH: mind detailing the queries you use on Textures13.db and what you'd thus need exposed the exact same functionality through JSON-RPC? Cheers, Jonathan RE: [RELEASE] Texture Cache maintenance utility - Milhouse - 2013-03-23 (2013-03-23, 22:39)jmarshall Wrote: MilhouseVH: mind detailing the queries you use on Textures13.db and what you'd thus need exposed the exact same functionality through JSON-RPC? The main query to extract from Textures13.db is: Code: SELECT t.id, t.cachedurl, t.lasthashcheck, t.url, s.height, s.width, s.usecount, s.lastusetime FROM texture t JOIN sizes s ON (t.id = s.idtexture) with an optional filter (WHERE) when searching. I'd also want the ability to delete rows (by id), and also remove the underlying file system object. In addition, I walk the files in Thumbnails folder, so being able to get a list of all the files in Thumbnails would be nice. So in summary: 1) Method to search the texture table (joined with sizes table) and return all rows and columns, or a filtered subset 2) Method to delete rows from database tables (using texture.id), with optional deletion of associated filesystem (cachedurl) object 3) Method to get list of all files present in the Thumbnails folder 4) Method to delete files that are in the Thumbnails folder RE: [RELEASE] Texture Cache maintenance utility - ctawn - 2013-03-24 I tried to run this on my ATV2 and got this error: Code: ATV2:/bin root# ./texturecache.py c I installed it in /bin/ and I first installed Python 2.5.1 with "apt-get install python". What am I doing wrong here? RE: [RELEASE] Texture Cache maintenance utility - Milhouse - 2013-03-24 (2013-03-24, 02:32)ctawn Wrote: What am I doing wrong here? Just to make sure there wasn't a problem with versions, can you remove texturecache.py and download it again. I've only ever tested this on Python 2.7.3, and the current version runs fine, and unfortunately I don't have Python 2.5.1 to test with... EDIT: OK, thought I'd try this on my old OpenELEC 1.0 x86 box which is running Python 2.6.6 and have reproduced - working on a fix... RE: [RELEASE] Texture Cache maintenance utility - Milhouse - 2013-03-24 @ctawn: new version (0.2.2) uploaded, working with Python 2.6.6 which had the same error you had with 2.5.1, so hopefully it's now fixed. Not sure if I can support 2.5.1 going forward but we'll see (doesn't the ATV2 have a more recent version of Python?) Also in this version, webserver authentication is now supported - add webserver.username and webserver.password to the properties file. |