SlimChances wrote:
> Is it possible to get Albums and New Albums under Erland's Custom
> Browse, Multilibrary to function again. They were working a few versions
> ago.
As stated, at least twice, before - the issue is with CustomBrowse. If
you look in your LMS log you will see errors such as:
Code:
--------------------
19-07-25 07:39:59.8545] Slim::Control::Request::execute (1888) Error: While
trying to run function coderef [Plugins::CustomBrowse::Plugin::cliJiveHandler]:
[Carp::Clan::__ANON__(): Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db
prepare_cached failed: too many SQL variables [for Statement "SELECT me.id,
me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc,
me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain,
me.replay_peak, me.musicbrainz_id, me.title, contributorAlbums.role,
contributorAlbums.contributor, contributorAlbums.album, contributor.id,
contributor.name, contributor.namesort, contributor.musicmagic_mixable,
contributor.namesearch, contributor.musicbrainz_id FROM albums me LEFT JOIN
contributor_album contributorAlbums ON contributorAlbums.album = me.id LEFT
JOIN contributors contributor ON contributor.id = contributorAlbums.contributor
WHERE ( me.id IN ( ?, ............. ? ) ) ORDER BY contributorAlbums.album"] at
/home/crai
g/Downloads/logitechmediaserver-7.9.2-1543258616/Slim/Schema/Storage.pm line
126
--------------------
(I've modified the above to remove many of the "?" charaters that are
logged)
You state that it worked before - my guess is that it has not worked
since v0.5.0 This version is when I started asking LMS for all items in
one go, rather than in blocks of 100 as you scrolled. I'm pretty sure
CustomBrowse does not like being asked for so many items. The "New
Albums" section, when placed into the top-level (as in not under "Custom
Browse"), used to also fail - but was made to work by restricing the
number of items asked for to the configured new music limit. Looks like
custom browse does not like being asked for more than 999 items.
However, should you think it has worked since 0.5.0, please feel free to
install each of the versions since, and confirm where the breakage
started. (Note, after each install you will need to restar tLMS, and
clear your browser's cache)
------------------------------------------------------------------------
cpd73's Profile: http://forums.slimdevices.com/member.php?userid=66686
View this thread: http://forums.slimdevices.com/showthread.php?t=109624
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
