Fanart Handler Plugin v4.0.X.000 (5 Viewers)

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,369
    Kyiv
    Home Country
    Ukraine Ukraine
    • Thread starter
    • Moderator
    • #31
    I guess items skipped all still retry to get images in now playing?
    At start looking for those that are missing, and they have not been updated for more than 2 weeks (the plugin worked before). When playing music and pictures not in the database, looking for immediately. :rolleyes:

    This would work good?
    Everything remains as before, except for updates at startup plug, and when you click Scrape [ S ] button in the configurator. :D

    Try it, if it works badly, then I can fix it. :cool::coffee:
     

    D3ltoroxp

    MP Donator
  • Premium Supporter
  • June 1, 2008
    3,308
    205
    Home Country
    Germany Germany
    @D3ltoroxp @TranceManNZ
    FanartHandler 4.0.0.59 (Beta):
    * Fixed updating of artists and albums at the start, now for anyone looking for pictures in the past two weeks, the search will not occur.
    * Reduced the capture database. A large transaction is broken into many small ones.
    * Optimized algorithm.
    Now it runs like in the past. Fast progres bar in seconds its finished. Thanks !
     

    HomeY

    Test Group
  • Team MediaPortal
  • February 23, 2008
    6,475
    4,645
    49
    ::1
    Home Country
    Netherlands Netherlands
    Just updated my previous version (.51) to .59 and i get dB errors. Do i need to start with a clean dB again?
    [hide=Errors]
    Code:
    2014-12-03 11:09:25,651] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:table Image has no column named MBID query:INSERT INTO Image (Id, Category, Provider, Key1, Key2, FullPath, SourcePath, AvailableRandom, Enabled, DummyItem, Time_Stamp, MBID) VALUES('52121','MusicFanartScraped','FanartTV','joan osborne','','D:\MP_Shared\thumbs\Skin FanArt\Scraper\music\JOAN OSBORNE (52121).jpg','http://assets.fanart.tv/fanart/music/746916c9-fd36-44e6-823d-03185e596f58/artistbackground/osborne-joan-505658aa62560.jpg','True', 'True', 'False','20141203','746916c9-fd36-44e6-823d-03185e596f58');
    [2014-12-03 11:09:25,911] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:table Image has no column named MBID query:INSERT INTO Image (Id, Category, Provider, Key1, Key2, FullPath, SourcePath, AvailableRandom, Enabled, DummyItem, Time_Stamp, MBID) VALUES('52122','MusicFanartScraped','FanartTV','joan osborne','','D:\MP_Shared\thumbs\Skin FanArt\Scraper\music\JOAN OSBORNE (52122).jpg','http://assets.fanart.tv/fanart/music/746916c9-fd36-44e6-823d-03185e596f58/artistbackground/osborne-joan-505658e802240.jpg','True', 'True', 'False','20141203','746916c9-fd36-44e6-823d-03185e596f58');
    [2014-12-03 11:09:26,144] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:table Image has no column named MBID query:INSERT INTO Image (Id, Category, Provider, Key1, Key2, FullPath, SourcePath, AvailableRandom, Enabled, DummyItem, Time_Stamp, MBID) VALUES('123783','MusicFanartScraped','FanartTV','joan osborne','','D:\MP_Shared\thumbs\Skin FanArt\Scraper\music\JOAN OSBORNE (123783).jpg','http://assets.fanart.tv/fanart/music/746916c9-fd36-44e6-823d-03185e596f58/artistbackground/osborne-joan-537a50c52abea.jpg','True', 'True', 'False','20141203','746916c9-fd36-44e6-823d-03185e596f58');
    [2014-12-03 11:09:26,358] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:table Image has no column named MBID query:INSERT INTO Image (Id, Category, Provider, Key1, Key2, FullPath, SourcePath, AvailableRandom, Enabled, DummyItem, Time_Stamp, MBID) VALUES('123784','MusicFanartScraped','FanartTV','joan osborne','','D:\MP_Shared\thumbs\Skin FanArt\Scraper\music\JOAN OSBORNE (123784).jpg','http://assets.fanart.tv/fanart/music/746916c9-fd36-44e6-823d-03185e596f58/artistbackground/osborne-joan-537a50c53f0aa.jpg','True', 'True', 'False','20141203','746916c9-fd36-44e6-823d-03185e596f58');
    [2014-12-03 11:13:31,398] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:no such column: MBID query:SELECT DISTINCT MBID FROM Image WHERE Key1 = 'cris cab' LIMIT 0,1;
    [2014-12-03 11:13:32,388] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:table Image has no column named MBID query:INSERT INTO Image (Id, Category, Provider, Key1, Key2, FullPath, SourcePath, AvailableRandom, Enabled, DummyItem, Time_Stamp, MBID) VALUES('D:\MP_Shared\thumbs\Skin FanArt\Scraper\music\cris cab (27759).jpg', 'MusicFanartScraped', 'Dummy', 'cris cab','', null, null, 'False', 'False', 'True', '20141203', 'f42839a2-9137-4c49-b986-239d3bdd9d9b');
    [/hide]

    ** EDIT **
    Never mind, deleted the dB, created a new 1, seems fine. Errors gone.
    Code:
    03-Dec-2014 11:28:23  Info [     DatabaseManager]: NowPlayingScrape is starting for Artist: CRIS CAB. 
    03-Dec-2014 11:28:23 Debug [             Scraper]: Initialize MP stripped prefixes: The, Les, Die - False 
    03-Dec-2014 11:28:23 Debug [             Scraper]: Trying to find Fanart for Artist: CRIS CAB. 
    03-Dec-2014 11:28:24 Debug [             Scraper]: MuzicBrainz: Extract ID: f42839a2-9137-4c49-b986-239d3bdd9d9b 
    03-Dec-2014 11:28:24 Debug [             Scraper]: Fanart.TV: Trying to find pictures for Artist (Fanart): CRIS CAB. 
    03-Dec-2014 11:28:24  Info [     DatabaseManager]: No fanart found for Artist: CRIS CAB. 
    03-Dec-2014 11:28:24  Info [     DatabaseManager]: NowPlayingScrape is done.
     
    Last edited:

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,369
    Kyiv
    Home Country
    Ukraine Ukraine
    • Thread starter
    • Moderator
    • #36
    Do i need to start with a clean dB again?
    Very strange, you have not refreshed database. Therefore, such an error. But I do not see there version of the database, so I can not say exactly what to do. :([DOUBLEPOST=1417608253][/DOUBLEPOST]PS: But I kind of found a bug, why this might be. The new version has corrected. Now will test himself, and lay out.
     
    Last edited:

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,369
    Kyiv
    Home Country
    Ukraine Ukraine
    • Thread starter
    • Moderator
    • #37
    FanartHandler 4.0.0.62 (Beta):
    + Improved SQL queries when searching for the missing pictures.
    + Before updating the database, automatically makes a backup copy of the old database.
    + The database has been updated to version 3.3. After updating the initial search may take some time.
    + Added question when updating images in the configurator, to do an update or do a full search.
    * Fixed a bug database updates. Fields can be entanglement at gradual upgrade to the database.
    * Error should go away for artists such as Beetles - The Beetles. etc.
    * Reorganization procedures image search.

    PS: Who uses mpSync plugin, update the database on the master, and then manually copy it to the store and customers.
     

    Attachments

    • FanartHandler.4.0.0.62.Beta.zip
      258 KB

    HomeY

    Test Group
  • Team MediaPortal
  • February 23, 2008
    6,475
    4,645
    49
    ::1
    Home Country
    Netherlands Netherlands
    Try 62nd build. Maybe he find.
    That artist isn't in my dB, it was from NowPlaying while listening to Webstream radio, so can't try that.
    The reason why it didn't find it, is because it's not available ;)
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,369
    Kyiv
    Home Country
    Ukraine Ukraine
    • Thread starter
    • Moderator
    • #40
    Today I will myself into combat :D 3 HTPC put 62 build. :coffee:
     

    Users who are viewing this thread

    Top Bottom