[solved] Mixed artist pictures (1 Viewer)

[ajs]

Ah, OK, these are the calculated values.

Yes, can you run this SQL select?

SELECT Id, Key1, FullPath, SourcePath, Category, Provider FROM Image WHERE Key1 IN ('madeline juno') AND Enabled = 1 AND DummyItem = 0 AND (iWidth > 960 AND iHeight > 540 AND Ratio >= 1.3) AND SubCategory IN ('MusicFanartManual','MusicFanartScraped');

 

[horned_reaper]

No results:

 

[ajs]

No results

I change SQL select to lower 'madeline juno' - its correct try again with 'madeline juno' ...

 

[horned_reaper]

You're the man!
It's case-sensitive!

Now I'm really looking forward to your new DLL with the !!! artist and the SQL query fixes!

 

[ajs]

You're the man!
It's case-sensitive!

In the plugin, all calls are already in lowercase (this is my mistake with copy paste), if you get the result in a query in lowercase, then I have no idea why it does not work for this artist.

 

[horned_reaper]

Oh, I see.
More debugging information would help us to further trace the issue.

 

[ajs]

More debugging information would help us to further trace the issue.

This select return results?

SELECT Id, Key1, FullPath, SourcePath, Category, Provider FROM Image WHERE Key1 IN ('madeline juno') AND Enabled = 1 AND DummyItem = 0 AND (iWidth > 960 AND iHeight > 540 AND Ratio >= 1.3) AND SubCategory IN ('MusicFanartManual','MusicFanartScraped');

 

[horned_reaper]

Yes, it returns the four Fanart entries.

 

[ajs]

Yes, it returns the four Fanart entries.

Very strange, it should then show for this artist, if we got pictures from the database, then we check them for size and proportion. And that’s all. But somewhere here, something does not work out ...

 

[horned_reaper]

Right.
I just retried but it doesn't display the pictures for this artist and I can't see any related error message in the FH and MediaPortal logs.