[solved] Mixed artist pictures (1 Viewer)

ajs · April 22, 2020

horned_reaper said:
Is it possible to change the query to delete them?

Why not

In my opinion, so ...

SQL:

DELETE FROM Image WHERE Provider = 'Local' AND UPPER(FullPath) IN (SELECT UPPER(FullPath) FROM Image WHERE Provider = 'Local' GROUP BY UPPER(FullPath) HAVING COUNT(UPPER(FullPath)) > 1);

ajs · April 22, 2020

I can add this to DB upgrade...

--
WBR, ajs

horned_reaper · April 22, 2020

Thank you very much!
I've deleted all duplicate records and will test if they reoccur with the new FH DLL.

By the way, do you know how to shrink the MySQL database file after the clean-up?

ajs · April 22, 2020

horned_reaper said:
By the way, do you know how to shrink the MySQL database file after the clean-up?

When updating, this is done automatically, the version will be updated the first time a new plug-in is launched with the old data base.

ajs · April 22, 2020

But in SQLite Explorer in DB properties buttons present like Vacuum, Reindex etc...

horned_reaper · April 22, 2020

Oh, I just see it - my database file decreased from 118 to 88MB! Great!

horned_reaper · April 22, 2020

Error messages with the new DLL after the clean-up:

Code:

[2020-04-22 20:03:09,411] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'robbie williams & nicole kidman' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Robbie Williams & Nicole Kidman (3858).jpg';
[2020-04-22 20:03:09,743] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'robbie williams & nicole kidman' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Robbie Williams & Nicole Kidman (3860).jpg';
[2020-04-22 20:03:10,163] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'robbie williams & nicole kidman' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Robbie Williams & Nicole Kidman (3854).jpg';
[2020-04-22 20:03:10,729] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'robbie williams & nicole kidman' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Robbie Williams & Nicole Kidman (3857).jpg';
[2020-04-22 20:03:11,440] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'robbie williams & nicole kidman' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Robbie Williams & Nicole Kidman (3855).jpg';
[2020-04-22 20:03:12,277] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'robbie williams & nicole kidman' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Robbie Williams & Nicole Kidman (3856).jpg';
[2020-04-22 20:03:13,277] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'robbie williams & nicole kidman' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Robbie Williams & Nicole Kidman (3859).jpg';
[2020-04-22 20:03:14,410] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'robbie williams & nicole kidman' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Robbie Williams & Nicole Kidman (3861).jpg';
[2020-04-22 20:03:17,612] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'robbie williams & nicole kidman' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Robbie Williams & Nicole Kidman (178990).jpg';
[2020-04-22 20:03:21,527] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'robbie williams & nicole kidman' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Robbie Williams & Nicole Kidman (2).jpg';
[2020-04-22 20:51:22,707] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'above & beyond pres oceanlab' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Above & Beyond pres. Oceanlab (167170).jpg';
[2020-04-22 20:51:22,959] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'above & beyond pres oceanlab' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Above & Beyond pres. Oceanlab (53936).jpg';
[2020-04-22 20:51:23,367] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'above & beyond pres oceanlab' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Above & Beyond pres. Oceanlab (167165).jpg';
[2020-04-22 20:51:23,931] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'above & beyond pres oceanlab' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Above & Beyond pres. Oceanlab (167168).jpg';
[2020-04-22 20:51:25,144] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'above & beyond pres oceanlab' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Above & Beyond pres. Oceanlab (167169).jpg';
[2020-04-22 20:51:26,232] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'above & beyond pres oceanlab' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Above & Beyond pres. Oceanlab (167164).jpg';
[2020-04-22 20:51:27,893] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'above & beyond pres oceanlab' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Above & Beyond pres. Oceanlab (167166).jpg';
[2020-04-22 20:51:30,097] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'above & beyond pres oceanlab' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Above & Beyond pres. Oceanlab (167167).jpg';
[2020-04-22 20:51:31,403] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'above & beyond pres oceanlab' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Above & Beyond pres. Oceanlab (0).jpg';
[2020-04-22 20:51:32,633] [Error  ] [ScraperNowWorker] [ERROR] - SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR/ERROR detailed:no such column: Povider query:DELETE FROM Image WHERE Key1 = 'above & beyond pres oceanlab' AND Key2 = '' AND Category = 'MusicFanart' AND SubCategory = 'MusicFanartScraped' AND Povider = 'Local' AND FullPath = 'C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Above & Beyond pres. Oceanlab (1).jpg';

This happens only once when I play this artist the first time after the clean-up with the new DLL.

horned_reaper · April 22, 2020

There's a typo:
... AND Povider = 'Local' AND ...

ajs · April 22, 2020

Sorry... I fix this latter...

--
WBR, ajs

ajs · April 22, 2020

Fixed ... try this ...

[solved] Mixed artist pictures (1 Viewer)

ajs

Development Group

ajs

Development Group

horned_reaper

Test Group

ajs

Development Group

ajs

Development Group

horned_reaper

Test Group

horned_reaper

Test Group

horned_reaper

Test Group

ajs

Development Group

ajs

Development Group

Attachments

Users who are viewing this thread