[solved] No Fanart when playing (2 Viewers)

[horned_reaper]

this build should fix double for thumbs

This works as well! Thank you!
Can we use a database query to delete duplicates from the past (one-time cleanup)?

 

[ajs]

Can we use a database query to delete duplicates from the past?

If, delete all duplicate entries, then it is possible, if one of them, then I don’t even know.

 

[ajs]

If this select

SELECT FullPath, COUNT(Category) FROM Image WHERE SubCategory= 'MusicArtistThumbScraped' GROUP BY UPPER(FullPath) HAVING COUNT(UPPER(FullPath)) > 1 ORDER BY FullPath;

return duplicated then this should delete it:

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

But I did not check it

 

[horned_reaper]

Thanks!
This query deletes both entries of a duplicate. Can we delete only the second occurrence?

 

[ajs]

Can we delete only the second occurrence?

I dont know how, but may be ...

 

[ajs]

If record have different providers like FanartTV and AudioDB then may be like this:

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

 

[horned_reaper]

The following query doesn't return any record. Is it correct?

SELECT * FROM Image WHERE SubCategory = 'MusicArtistThumbScraped' AND Provider = 'AudioDB' AND UPPER(FullPath) IN (SELECT UPPER(FullPath) FROM Image WHERE SubCategory = 'MusicArtistThumbScraped' GROUP BY UPPER(FullPath) HAVING COUNT(UPPER(FullPath)) > 1);

 

[ajs]

AudioDB

I dont remember correct name fot this provider, need look to DB in Provider column for Artist thumb ...

 

[horned_reaper]

It's TheAudioDB. The following query works:

Delete FROM Image WHERE SubCategory = 'MusicArtistThumbScraped' AND Provider = 'TheAudioDB' AND UPPER(FullPath) IN (SELECT UPPER(FullPath) FROM Image WHERE SubCategory = 'MusicArtistThumbScraped' GROUP BY UPPER(FullPath) HAVING COUNT(UPPER(FullPath)) > 1);

In my opinion you can add it to the database maintenance tasks for other users having this issue.

 

[ajs]

In my opinion you can add it to the database maintenance tasks for other users having this issue.

I don’t see the point, I do not have such records in the database. And if they were, they do not affect anything, they only slightly increase the size of the database.