[brochild]

Would really appreciate any help with artwork on Kodi 19 Alpha 3

I have 3 HTPCs running in the house using mySQL 5 to sync movies, tv shows, and music database.
HTPC-1 was updated recently, with new motherboard, CPU, memory, SSD, etc , and new Windows 10 installation.
I took the opportunity to install mySQL 8, and then imported my old database and all was well on all  3 HTPCs.

I noticed all of a sudden that artwork on HTPC-1, running mySQL was fine, but on HTPC-2 and HTPC-3, there was no artwork.
All database data is available and synchronized, except artwork is not updating for my movies, but updating for my TV shows and music.
My movies are using Local Information scrapper, and TV shows are using external Movie Database scrapper from the Web.
I can right-click any movie and refresh the artwork successfully on HTPC-2 and HTPC-3.
Question is why is the artwork refresh no longer working on these 2 machines?

I will post a log shortly - I am away from home at  the moment
Thanks in advance for any suggestions on how to fix this.

Log for HTPC-2 posted here
I noticed these errors and not sure how to resolve them
2020-11-04 19:24:56.299 T:11404   DEBUG <general>: CTextureCacheJob::GetImageHash - unable to stat url C:\Users\Administrator\Downloads\kodi_videodb_2020-11-03\movies\Glory_4K_1989-fanart.jpg
2020-11-04 19:25:00.315 T:2592    DEBUG <general>: CTextureCacheJob::GetImageHash - unable to stat url C:\Users\Administrator\Downloads\kodi_videodb_2020-11-03\movies\Ad_Astra_4K_2019-fanart.jpg

I remember saving the exported movie database from HTPC-1 to the "Downloads" folder and then trying to import it again on HTPC-2.

Basically I am asking how do I fix my mistake (LoL)

[Karellen]

@brochild

That is not a skin issue so I have split your post.

[brochild]

@brochild

That is not a skin issue so I have split your post.

Thanks, I was not sure if I had a skin issue.
But after reading the log, its clearly my issue.

[Karellen]

But after reading the log, its clearly my issue.

So you are ok now? You know how to fix the issue?

[brochild]

I have absolutely no clue.

Was thinking maybe I could delete the database directory?
This is in the hope that Kody would rebuild it.
But which one?

I think there are several different directories with specific names.

Would appreciate a helping hand as always.

[Karellen]

ok, but you said you would post a Debug Log. So if you post that, we can check it out.

[brochild]

Yes, I posted the log in my edited 1st post above

I saw a bunch of these error messages pointing to the missing fanarts.
I'm trying to figure out how to fix them.

unable to stat url C:\Users\Administrator\Downloads\kodi_videodb_2020-11-03\movies\Glory_4K_1989-fanart.jpg

[Karellen]

xml:
CTextureCacheJob::GetImageHash - unable to stat url C:\Users\Administrator\Downloads\kodi_videodb_2020-11-03\movies\Dredd_3D_2012-poster.jpg

It seems to be a strange path for your artwork location. I don't see any pathsubstitution pointing to/from that location. Your Portable install does not seem to match that location either.

I am not a MySQL user, so I won't be much help. @Klojum will be able to help if he is around.

A few side issues...

• Your buffer settings are wrong... https://kodi.wiki/view/HOW-TO:Modify_the_video_cache
  
• Your passwords.xml substitution is incorrect.
  
• The tags in <pvr> I have never seen before. Where did you find those?
  

https://kodi.wiki/view/Advancedsettings.xml

[Klojum]

'stat' is a Linux command to get status information on a folder or file.
If that folder or file is unreachable or non-existent, there is a problem.
It doesn't have anything to do with MySQL, or SQLite for that matter.

It looks more like a user/file right's issue.

[black_eagle]

I remember saving the exported movie database from HTPC-1 to the "Downloads" folder and then trying to import it again on HTPC-2.

Why would you do that when both machines are meant to be pointing at the same (MySQL) database ?  In any case, did you back up your MySQL db from MySQL ?   If you did and it was working previously then just re-import it.  If not, then you should always make a backup from MySQL before messing with a live database.  My guess is that you exported the db from within Kodi.  If you did a single file export, this changes the artwork url to point at the export folder.  Is that perhaps what you have done?

[brochild]

Problem Solved
I deleted the Kodi database from MySQL server
Launched Kodi on one of the 2 problematic HTPC (HTPC-2)
Imported the saved Kodi database
Made sure all the artworks were ok
Launch Kodi on the other 2 HTPC hosts and made sure the artworks were ok.
That was it.

Thank you all for all your help, support, and suggestion

[black_eagle]

Thread marked solved.