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

[ajs]

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.

This would work good?

Everything remains as before, except for updates at startup plug, and when you click Scrape [ S ] button in the configurator.

Try it, if it works badly, then I can fix it.

 

[D3ltoroxp]

@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 !

 

[TranceManNZ]

Now it runs like in the past. Fast progres bar in seconds its finished. Thanks !

Also just tested and that's the way we like it. Thanks heaps for your hard work. Great to have Fanart working again.

 

[catavolt]

Just must agree
Nice work

 

[HomeY]

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]

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.

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.

 

[ajs]

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.

 

[ajs]

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.

 

[ajs]

No fanart found for Artist: CRIS CAB.

Try 62nd build. Maybe he find.

 

[HomeY]

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]

Today I will myself into combat 3 HTPC put 62 build.