Virtual libraries + Qobuz

[mherger]

Go to Settings/Advanced/Logging. There you’ll find a category database.sql or similar. Set this to debug, run the test, set back to warning. Then send me the resulting server.log.zip from that same page.

[OlivierS]

Hello,

After many tries here is what I observed with debug logging for database.sql:
I finally obtain some interesting line in server.log after clearing and rescanning everything, then navigating for the first time in the views; this line is the last one, and nothing more appear in the logfile after that

[23-05-28 09:39:10.9908] Slim::Control::Queries::artistsQuery (1110) Artists query: SELECT contributors.id, contributors.name, contributors.namesort FROM contributors LEFT JOIN contributor_album ON contributor_album.contributor = contributors.id LEFT JOIN library_contributor ON library_contributor.contributor = contributors.id WHERE ((contributor_album.role IN (1,4,5) ) AND library_contributor.library = ?) OR (contributors.extid IS NOT NULL AND contributors.extid != '') GROUP BY contributors.id ORDER BY contributors.namesort COLLATE en_US LIMIT ?,? / ["286ff79e", 0, 25_000]

The WHERE clause contains a hard coded condition on contributors.extid, which is not empty in the case of qobuz artists, as mentioned before...
I sent the logfile to your dropbox and hope this information is useful.

Best regards

[mherger]

[23-05-28 09:39:10.9908] Slim::Control::Queries::artistsQuery (1110) Artists query: SELECT contributors.id, contributors.name, contributors.namesort FROM contributors LEFT JOIN contributor_album ON contributor_album.contributor = contributors.id LEFT JOIN library_contributor ON library_contributor.contributor = contributors.id WHERE ((contributor_album.role IN (1,4,5) ) AND library_contributor.library = ?) OR (contributors.extid IS NOT NULL AND contributors.extid != '') GROUP BY contributors.id ORDER BY contributors.namesort COLLATE en_US LIMIT ?,? / ["286ff79e", 0, 25_000]

The WHERE clause contains a hard coded condition on contributors.extid, which is not empty in the case of qobuz artists, as mentioned before...

Yes! That looks very much like it. I'll have to look into this.

[OlivierS]

Hello,

This is probably not a surprise: when I disable the plugin 'Online Music Library Integration', no Qobuz intruders in artists view

Searching for a work around I'm trying the plugin 'Additional Browse Modes'; at first glance there is no problem with online artists, just one remark: when a browse folder is pinned to home screen, it appears subsequent modifications of parameters of that view are present in the browse view in 'My Music' screen but are not reported to the home pinned one; that's not too much annoying but maybe a warning message somewhere in the process would be preferable; I spent a lot of time with that !

Regards

[mherger]

Searching for a work around I'm trying the plugin 'Additional Browse Modes'; at first glance there is no problem with online artists, just one remark: when a browse folder is pinned to home screen, it appears subsequent modifications of parameters of that view are present in the browse view in 'My Music' screen but are not reported to the home pinned one; that's not too much annoying but maybe a warning message somewhere in the process would be preferable; I spent a lot of time with that !

You should probably mention this in the Material skin thread. Or is this any other UI?

[OlivierS]

Yes, you're right, it's a Material skin subject.

[mherger]

The WHERE clause contains a hard coded condition on contributors.extid, which is not empty in the case of qobuz artists, as mentioned before...

I've applied a change to 8.4 to NOT include those artists. Could you please give it a try? New build should be out shortly - check out the timestamp of the installer package: https://downloads.slimdevices.com/nightly/?ver=8.4

[OlivierS]

OK, thank you, a couple of tries says it works fine