+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: art location in relation to player and server (/showthread.php?tid=350264)
art location in relation to player and server - dr-oopie - 2019-12-21
im using a raspberry pi with advnacedsettings and have a remote sql and the media is on my server. i know that kodi caches art like thumbnails. my question is, after this cache, are the images called again when browsing the library? i dont want to spin up drives just to fetch images. the reason i ask is because when i was updating the sql paths for actors as an example, could i simply put all the actor images on a single drive in my server and update the paths in sql to that?
RE: art location in relation to player and server - Karellen - 2019-12-21
(2019-12-21, 02:45)dr-oopie Wrote: my question is, after this cache, are the images called again when browsing the library?Yes, the original images are re-checked when the time interval has been greater than 24 hours since the image was last viewed. If you delete the original image, the cached image will eventually disappear also.
(2019-12-21, 02:45)dr-oopie Wrote: i dont want to spin up drives just to fetch imagesYep, can be a problem. I overcame this problem by setting the "LastChecked" date in the db to one year in the future.
(2019-12-21, 02:45)dr-oopie Wrote: could i simply put all the actor images on a single drive in my server and update the paths in sql to that?I don't see why not. If you are keen, try it and let us know the results.
RE: art location in relation to player and server - dr-oopie - 2019-12-21
(2019-12-21, 02:50)Karellen Wrote: Yep, can be a problem. I overcame this problem by setting the "LastChecked" date in the db to one year in the future.
where do i change that setting?
RE: art location in relation to player and server - Karellen - 2019-12-21
It’s not a setting. You need to update the date/time entry.
RE: art location in relation to player and server - dr-oopie - 2019-12-22
(2019-12-21, 03:11)Karellen Wrote: It’s not a setting. You need to update the date/time entry.
sorry for being a noob but really confused as to where that would be. not sure if you mean system settings to move them forward or in the movie xml or in the sql or if its within the kodi database files. the way i set mine up is that i use ember to make the xml and thumbs which it stores the files within the movie directory so i was going to see if i could start with setting the thumbnails to a root path on a single share in unraid so all the images are cached to that and only that drive spins up. because otherwise i would have to scrape the movie and open the sql db to edit all the entries for new movies added manually.
RE: art location in relation to player and server - Karellen - 2019-12-22
(2019-12-21, 02:45)dr-oopie Wrote: when i was updating the sql paths for actorsFrom this statement I assumed you knew your way around databases, so now I am hesitant to guide you. But we have already started down that track, so I'll tell you what needs to be done, and I am sure you will figure out how to do it and most importantly create a backup of your database.
Open your Textures13.db database. In the texture table, update the lasthashcheck entries to some time in the future. I set mine to 1 year in the future. Of course this only applies to images already in your library, and as you add new media to your library, they will need to be updated also. Remember, this is not a setting, rather it is a dirty workaround
RE: art location in relation to player and server - dr-oopie - 2019-12-22
(2019-12-22, 02:22)Karellen Wrote:(2019-12-21, 02:45)dr-oopie Wrote: when i was updating the sql paths for actorsFrom this statement I assumed you knew your way around databases, so now I am hesitant to guide you. But we have already started down that track, so I'll tell you what needs to be done, and I am sure you will figure out how to do it and most importantly create a backup of your database.
Open your Textures13.db database. In the texture table, update the lasthashcheck entries to some time in the future. I set mine to 1 year in the future. Of course this only applies to images already in your library, and as you add new media to your library, they will need to be updated also. Remember, this is not a setting, rather it is a dirty workaround
ah i was looking at the MyVideos.db but i see that Textures is holding image stuff. thanks!