[solved] Mixed artist pictures (1 Viewer)

[horned_reaper]

Hello,

suddenly the Fanart pictures of several artists get replaced by seven Marilyn Manson Fanart pictures.
The same seven pictures get downloaed multiple times, with different artist names but the same ID in the file name each.
When I delete them from the Fanart database they get downloaded again.
If I disable them they get re-enabled during playback (overwrite existing Fanart pictures setting is enabled).

Is there an issue with my Fanart database or has someone spammed the online database?


Thank you and best regards

 

[ajs]

Is there an issue with my Fanart database or has someone spammed the online database?

Fanart is loaded either by the name of the Artist, or by his MBID, if the MBID is not correctly defined, then the fanart will not load correctly. You can view the MBID in the configurator or in the database, where you can also change it if it is not defined correctly.
If there is a debug FH log file and a problem artist, then I can try to look and explain why this is happening.

 

[horned_reaper]

Hell @ajs,

thanks for your fast response!
Can I list all MBID assignments with the configurator to see if there are multipple assignments with the same MBID?

 

[ajs]

Can I list all MBID assignments with the configurator to see if there are multipple assignments with the same MBID?

I don’t remember whether this column is displayed in the interface, and whether there is sorting by it. I look directly in the database, it’s more convenient for me.

 

[horned_reaper]

OK.
Is it a MySQL database? Is it password-protected?

 

[ajs]

SQLite database without password

--
WBR, ajs

 

[ajs]

Fanarthandler.db3, Image table, mbid column, i recommended use SQLite Expert for browse and change SQLite databases

SQLite administration | SQLite Expert

SQLite Expert - A powerful administration tool for your SQLite databases

www.sqliteexpert.com

--
WBR, ajs

 

[ajs]

One Artist maybe have multirecords with mbid

--
WBR, ajs

 

[ajs]

You can look to fanart folder, search fanart with Marilyn Manson inside pictures with names different from Marilyn Manson, it will be troubled artists. Then for these artists check MBID and if they are not correct, then fix them either in the database itself or through the configurator.

 

[horned_reaper]

Thanks for all these useful hints!

Many pictures have no MBID assigned:

And many pictures share the same number in their file name.

Moreover, the same MIDB is used for multiple artists:

How would you solve this issue?