<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 14.02.5004.000">
<TITLE>artwork problems after loss of artwork storage folders</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">Recently I lost a hard di</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">sk that happened to contain the folders</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">that formed</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> the storage groups for Fanart / Coverart / Banners. I wasn’t fussed as it seemed to me that it was all content that was</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">simple /</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">academic to regenerate</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> and would happen automatically</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">So I created</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">the new folders, updated the respective storage groups with the new folder details and walked away. However a lot of the artwork is not being regenerated successfully.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">I</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">’m not exactly clear what is failing</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> or why</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">, however I have made the following observations:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">- </FONT></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">For some recordings the filename that is being requested is different to the filename in the</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">new coverart folder</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">. For example on some Air Crash</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> Investigation episodes the file being requested was</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">“</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">Air Crash Investigation - Mayday Season 1_coverart.jpg</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">” whereas the file actually stored in the new coverart folder is called “</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">Mayday Season 1_coverart.jpg</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">”</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> I have checked the files recovered from the failed disk and I can see that the original file name is the file name being requested.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> It’s just that the new coverart directory has a different file name.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">- </FONT></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">The file being requested seems to be the file stored in the recordedartwork table. But the filename in the recordedartwork table sometimes does not align with the redownloaded files which seems to be the prob</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">lem.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">- </FONT></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">In the recordedartwork table I have a mixture of inetref values that are prefixed with ttvdb.py_ or tmdb.py_ and some without the prefix. In general the ones</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">WITHOUT</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> the prefix are the ones that are not displaying the artwork. But this is not universally the case. But as far as I can tell everything</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">WITH</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> the prefix is working perfectly.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">- </FONT></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">For some recordings the filename that is being requested does not exist. So for example</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">Doctor Who has</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">3 images loaded into the new coverart folder</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">mark@mythbackend-master:/media/servertwo/Myth_Cover_Art$ ls -a | grep Doctor</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Doctor Who (2005) Season 0_coverart.jpg</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Doctor Who (2005) Season 7_coverart.jpg</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Doctor Who (2005) Season 8_coverart.jpg</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">Seasons 7 and 8 display coverart correctly.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> But not Season 6.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"></FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">In the frontend logs I get this:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">2015-06-06 10:07:06.070712 I MythUIHelper: LoadCacheImage(myth://Coverart@mythbackend-master/Doctor Who (2005) Season 6_coverart.jpg,myth:--Coverart@mythbackend-master-Doctor Who (2005) Season 6_coverart.jpg--620x1080.png)</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">2015-06-06 10:07:06.070829 I MythUIHelper: LoadCacheImage(myth://Coverart@mythbackend-master/Doctor Who (2005) Season 6_coverart.jpg,myth:--Coverart@mythbackend-master-Doctor Who (2005) Season 6_coverart.jpg--620x1080.png)</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">2015-06-06 10:07:06.070881 I ImageLoader::LoadImage(myth:--Coverart@mythbackend-master-Doctor Who (2005) Season 6_coverart.jpg--620x1080.png) Found in cache, RefCount = 2</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">2015-06-06 10:07:06.070901 I ImageLoader::LoadImage(myth://Coverart@mythbackend-master/Doctor Who (2005) Season 6_coverart.jpg) Image is NULL</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">In the recordedartwork table I have:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">mysql> select inetref,season,coverart from recordedartwork where coverart like "%Doctor%";</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">+---------+--------+-----------------------------------------+</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">| inetref | season | coverart |</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">+---------+--------+-----------------------------------------+</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">| 78804 | 1 | Doctor Who (2005) Season 1_coverart.jpg |</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">| 78804 | 3 | Doctor Who (2005) Season 3_coverart.jpg |</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">| 78804 | 4 | Doctor Who (2005) Season 4_coverart.jpg |</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">| 78804 | 5 | Doctor Who (2005) Season 5_coverart.jpg |</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">| 78804 | 6 | Doctor Who (2005) Season 6_coverart.jpg |</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">| 78804 | 2 | Doctor Who (2005) Season 2_coverart.jpg |</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">| 78804 | 7 | Doctor Who (2005) Season 7_coverart.jpg |</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">| 78804 | 8 | Doctor Who (2005) Season 8_coverart.jpg |</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">| 78804 | 0 | Doctor Who (2005) Season 0_coverart.jpg |</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">+---------+--------+-----------------------------------------+</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">9 rows in set (0.00 sec)</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">In the old coverart folder I had:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">mythtv@mythbackend-master:/media/serverfour/ServerTwo/cover_art$ ls -a | grep Doctor</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Doctor Who (2005) Season 0_coverart.jpg</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Doctor Who (2005) Season 1_coverart.jpg</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Doctor Who (2005) Season 2_coverart.jpg</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Doctor Who (2005) Season 3_coverart.jpg</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Doctor Who (2005) Season 4_coverart.jpg</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Doctor Who (2005) Season 5_coverart.jpg</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Doctor Who (2005) Season 6_coverart.jpg</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Doctor Who (2005) Season 7_coverart.jpg</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Doctor Who (2005) Season 8_coverart.jpg</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">I have tried:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">- </FONT></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">Deleting /home/mythtv/.mythtv/</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">remotecache. It seemed to have a stack of graphics files</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">and I thought it might be a simple caching issue</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">but didn’t seem to help</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">- </FONT></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">I ran</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">mythmetadatalookup --refresh-all-artwork</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> several times but it</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">didn’t seem to help.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> It ran for about 15min a</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">nd ended successfully but I must admit</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">it didn’t appear</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">check recordings that already had artwork associated with them.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">- </FONT></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">I deleted from recordedartwork all the lines related to Air Crash Investigations. This worked perfectly</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">,</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">the entries in the recordedartwork</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">ta</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">ble</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">were regenerated by MythTV with all the correct file n</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">ames and now artwork displays correctly for those recordings.</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">Essentially I am proposing to delete everything out of the recordedartwork directory and let MythTV regenerate / redownload every</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">thing from scratch</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> and</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">let it</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"> <FONT FACE="Calibri">rebuild this table at the same time</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">. Based on the one test I did this seems like it should work. But wanted to see if anyone else had a better suggestion on what to try first or if emptying the recordedartwork table was likely to have unforeseen negative consequences</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">? Guidance would be greatly appreciated.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT FACE="Calibri">I don’t want to just move th</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri">e recovered files back as there appears to be a lot of corruption and I don’t really want to sort out which files have recovered successfully and which files are partially / fully corrupted. I would prefer to start from scratch on the coverart / fanart / banners and save my time for</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"><FONT FACE="Calibri"> working out which recordings have been successfully saved.</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-au"></SPAN><SPAN LANG="en-gb"></SPAN></P>
</BODY>
</HTML>