[solved] Mixed artist pictures (1 Viewer)

[ajs]

I run this select on my DB and see problem not in Case, i try to fix this problem another way ...

 

[horned_reaper]

Thanks for your engagement!

To my understanding the SQL queries only duplicates where one record is from local source and the another one is from local source. Duplicates where both records are from local source are not found.

 

[ajs]

Duplicates where both records are from local source are not found.

In my opinion this is not possible ...

 

[horned_reaper]

But there are several such records in my FH database!

Category	SubCategory	FullPath	MBID	SourcePath
MusicFanart	MusicFanartManual	C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\music\Boney M. (7278).jpg		C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\music\Boney M. (7278).jpg
MusicFanart	MusicFanartScraped	C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Boney M. (7278).jpg		C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Skin FanArt\Scraper\Music\Boney M. (7278).jpg

 

[ajs]

But there are several such records in my FH database!

Mystery, tried to make a change. I went through the phone to the home server, then to the test computer, made changes and here is the test result. I am not sure how this works and whether it works at all. It is very inconvenient to do something from work, on my home computer.

 

[ajs]

try

 

[horned_reaper]

try

Thanks!
Will it do a database clean-up and/or prevent new duplicate entries?

 

[ajs]

Duplicates where both records are from local source are not found.

Maybe this help:

SELECT FullPath, COUNT(Provider) FROM Image WHERE Provider = 'Local' GROUP BY UPPER(FullPath) HAVING COUNT(UPPER(FullPath)) > 1 ORDER BY FullPath;

 

[ajs]

Will it do a database clean-up and/or prevent new duplicate entries?

Some cleanups when updating the database are added. But maybe not all.

 

[horned_reaper]

Maybe this help:

SELECT FullPath, COUNT(Provider) FROM Image WHERE Provider = 'Local' GROUP BY UPPER(FullPath) HAVING COUNT(UPPER(FullPath)) > 1 ORDER BY FullPath;

With this query the duplicate local source records are shown.
Is it possible to change the query to delete them?