[kinslayer96]

NOTE: I also posted this here but I don't think its a windows specific issue so am hoping to have more luck in this forum. (If any admin could delete the old post that would be great).

Hello,

I recently had a HDD give up the ghost on me. Before it died I managed to save my MySQL database and the media that was on there. I have now got a shiny new HDD and have transferred all the data across to it.

However, for some reason that I can't fathom, most (but not all) of my thumbnails for both Movies and TV Shows no longer work. An example of the error that I get in the log is

Code:

DEBUG: CTextureCacheJob::GetImageHash - unable to stat url E:\TV Shows\24\Season 1\24.s01.e02.tbn

This error makes perfect sense as during the move I renamed/moved the paths for a lot of the media. This particular file (and others affected) now reside on D:\ rather than E:\ (its actually residing at SMB:\\MEDIACENTRE\D\.... but I shouldn't think that matters).

I followed the guide for moving all the paths for my media in the MySQL database that you can find here and updated all the paths accordingly.

So my question is. Why on earth is XBMC still looking in the old place for so many of my thumbnails? Is there a field in the MySQL database that I failed to update? Or is there some other reason? This issue doesn't just occur on one machine, it occurs on all machines that previously had XBMC installed before my HDD troubles.

Things I have tried:

• Things I have tried:
  
• Deleted ~/userdata/textures/Databases/Textures13.db and ~/userdata/Thumbnails and run XBMC
  
• Upgraded to 13.2 (from 13.1) on one machine as I believe the thumbnails are all cached locally for each device
  
• Frantically hunted through the videosDB in MySQL looking for a column I may have missed.
  

Frankly, I am out of ideas, so any help would be greatly appreciated. All the media that XBMC is trying to look for is definitely there, it just resides at D:\ (SMB:\\MEDIACENTRE\D\...) now rather than E:\.

I should point out that the thumbnails do get correctly reloaded if I manually refresh either the movie or the TV show. However this isn't really feasible for 200+ movies and 2000+ TV episodes. There isn't any way to manually refresh all the data that I am not aware of is there?

Thanks!

[black_eagle]

You probably need to look here http://forum.xbmc.org/showthread.php?tid=158373

If you're not sure how to use it, just ask in the thread.

[kinslayer96]

I did run it a couple of days ago actually (sorry I should have updated the post) with the -c argument and I still have the same problem. I will try again this evening with the -C argument and hope that this fixes it.

I'm coming around to the idea that it isn't a caching issue at all as I don't think it can even find the files to cache them in the first place. After running the script with -c I checked the Textures13.db and there were no records in there for the thumbnails that I was missing - which again, makes sense as it can't find them in the first place to be able to cache them.

[kinslayer96]

So, before running the python script linked to by black_eagle again, I thought I would look through the database once more on the offchance I had missed updating a table.

Turns out I had. So for anyone else running into this issue make sure you check the "art" table and ensure that the "url" field has the correct paths.

This table/field combination have such obvious names I'm not entirely sure how I missed it for so long!