Kodi Community Forum
Solved Artwork not displaying using MySQL 8 - Printable Version

+- 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: Solved Artwork not displaying using MySQL 8 (/showthread.php?tid=358186)

Artwork not displaying using MySQL 8 - brochild - 2020-11-05

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)

RE: Artwork not displaying using MySQL 8 - Karellen - 2020-11-05

@brochild

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

RE: Artwork not displaying using MySQL 8 - brochild - 2020-11-05

(2020-11-05, 03:37)Karellen Wrote: @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.

RE: Artwork not displaying using MySQL 8 - Karellen - 2020-11-05

(2020-11-05, 05:35)brochild Wrote: But after reading the log, its clearly my issue.
So you are ok now? You know how to fix the issue?

RE: Artwork not displaying using MySQL 8 - brochild - 2020-11-05

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.

RE: Artwork not displaying using MySQL 8 - Karellen - 2020-11-05

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

RE: Artwork not displaying using MySQL 8 - brochild - 2020-11-05

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

RE: Artwork not displaying using MySQL 8 - Karellen - 2020-11-05 

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... https://kodi.wiki/view/Advancedsettings.xml

RE: Artwork not displaying using MySQL 8 - Klojum - 2020-11-05

'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.

RE: Artwork not displaying using MySQL 8 - black_eagle - 2020-11-05

(2020-11-05, 02:13)brochild Wrote: 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?

RE: Artwork not displaying using MySQL 8 - brochild - 2020-11-06

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

Artwork not displaying using MySQL 8 - black_eagle - 2020-11-06

Thread marked solved.