Home of the Squeezebox™ & Transporter® network music players.
Page 15 of 25 FirstFirst ... 51314151617 ... LastLast
Results 141 to 150 of 241
  1. #141
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,472

    Multi Library support in LMS 7.9

    The Library Demo plugin is not needed for the Library View menu to show
    up. It's part of the Additional Browse Modes plugin.

    Michael


    Am 13.01.15 13:38, schrieb Michael Herger:
    >> marcoc1712 wrote:
    >>> I discovered you have to enable LIbrary demo plugin to have the Library
    >>> view enabled, plus You have to enable it for the player you are using in
    >>> web UI.

    >>
    >> Ah. Yes, I have the demo plugin disabled. If that's the case, this
    >> should probably be made so that it's not required.

    >
    > Definitely. Thanks for the heads up!
    >


    --

    Michael

  2. #142
    Senior Member JJZolx's Avatar
    Join Date
    Apr 2005
    Location
    Colorado
    Posts
    11,548
    Quote Originally Posted by mherger View Post
    The Library Demo plugin is not needed for the Library View menu to show
    up. It's part of the Additional Browse Modes plugin.
    Thanks. Does that mean that browsing/changing library views in the player UIs also goes away when the ABM plugin is disabled?

  3. #143
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,472

    Multi Library support in LMS 7.9

    Could you try to run that query against your library.db file using some
    SQLite client (command line or SQLite Manager extension in firefox)?

    > Code:
    > --------------------
    >
    > [15-01-13 13:20:14.0735] Slim::Control::Queries::albumsQuery (671) Albums query: SELECT albums.discc AS 'albums.discc', contributors.name AS 'contributors.name', contributors.namesort AS 'contributors.namesort', albums.disc AS 'albums.disc', albums.titlesort AS 'albums.titlesort', albums.titlesearch AS 'albums.titlesearch', albums.contributor AS 'albums.contributor', albums.id AS 'albums.id', albums.title AS 'albums.title', albums.artwork AS 'albums.artwork', albums.compilation AS 'albums.compilation', albums.year AS 'albums.year' FROM albums JOIN contributor_album ON contributor_album.album = albums.id JOIN contributors ON contributors.id = contributor_album.contributor JOIN tracks ON tracks.album = albums.id JOIN library_track ON library_track.track = tracks.id WHERE contributor_album.role IN (?, ?) AND library_track.library = ? GROUP BY albums.id ORDER BY contributors.namesort COLLATE en_US , albums.year, albums.titlesort COLLATE en_US LIMIT ?,? / [5, 1, "9e75b8cb",

    10
    > 0, 100]


    Just replace the ? placeholders with the parameters listed at the end.
    And you'll probably have to remove the COLLATE en_US, too. Takes a
    fraction of a second to execute on my Atom based server, with a
    sub-library of about 17k tracks.

    SELECT albums.discc AS 'albums.discc', contributors.name AS
    'contributors.name', contributors.namesort AS 'contributors.namesort',
    albums.disc AS 'albums.disc', albums.titlesort AS 'albums.titlesort',
    albums.titlesearch AS 'albums.titlesearch', albums.contributor AS
    'albums.contributor', albums.id AS 'albums.id', albums.title AS
    'albums.title', albums.artwork AS 'albums.artwork', albums.compilation
    AS 'albums.compilation', albums.year AS 'albums.year' FROM albums JOIN
    contributor_album ON contributor_album.album = albums.id JOIN
    contributors ON contributors.id = contributor_album.contributor JOIN
    tracks ON tracks.album = albums.id JOIN library_track ON
    library_track.track = tracks.id WHERE contributor_album.role IN (5,1)
    and library_track.library = "2da2d7ab" group by albums.id order by
    contributors.namesort,albums.year, albums.titlesort limit 10;

    Get a list of library IDs:

    SELECT library FROM library_tracks GROUP BY library;

    --

    Michael

  4. #144
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,472

    Multi Library support in LMS 7.9

    >> The Library Demo plugin is not needed for the Library View menu to show
    >> up. It's part of the Additional Browse Modes plugin.

    >
    > Thanks. Does that mean that browsing/changing library views in the
    > player UIs also goes away when the ABM plugin is disabled?


    Yes.

    --

    Michael

  5. #145
    Senior Member pippin's Avatar
    Join Date
    Oct 2007
    Location
    Berlin
    Posts
    14,763
    Quote Originally Posted by mherger View Post
    Could you try to run that query against your library.db file using some
    SQLite client (command line or SQLite Manager extension in firefox)?
    Takes several minutes, too, completely hanging the process while querying.

    Would a "Clear & Rescan" make me lose my library definition? Probably yes, right?
    ---
    learn more about iPeng, the iPhone and iPad remote for the Squeezebox and
    Logitech UE Smart Radio as well as iPeng Party, the free Party-App,
    at penguinlovesmusic.com
    New: iPeng 9, the Universal App for iPhone, iPad and Apple Watch

  6. #146
    Senior Member pippin's Avatar
    Join Date
    Oct 2007
    Location
    Berlin
    Posts
    14,763
    Do you want to have my library.db?
    ---
    learn more about iPeng, the iPhone and iPad remote for the Squeezebox and
    Logitech UE Smart Radio as well as iPeng Party, the free Party-App,
    at penguinlovesmusic.com
    New: iPeng 9, the Universal App for iPhone, iPad and Apple Watch

  7. #147
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,472

    Multi Library support in LMS 7.9

    > Takes several minutes, too, completely hanging the process while
    > querying.


    Ok, then at least we know where to continue the search.

    > Would a "Clear & Rescan" make me lose my library definition? Probably
    > yes, right?


    No, the definitions are stored in a prefs file.

    > Do you want to have my library.db?


    Yes, please. Thanks!

    --

    Michael

  8. #148
    Senior Member pippin's Avatar
    Join Date
    Oct 2007
    Location
    Berlin
    Posts
    14,763
    OK, I've sent the library.db. Please let me know if you didn't get it, was still 18MB or so...
    ---
    learn more about iPeng, the iPhone and iPad remote for the Squeezebox and
    Logitech UE Smart Radio as well as iPeng Party, the free Party-App,
    at penguinlovesmusic.com
    New: iPeng 9, the Universal App for iPhone, iPad and Apple Watch

  9. #149
    Senior Member
    Join Date
    Dec 2009
    Location
    Albinea (RE) Italy
    Posts
    818
    Quote Originally Posted by mherger View Post
    Could you try to run that query against your library.db file using some
    SQLite client (command line or SQLite Manager extension in firefox)?


    ...

    SELECT albums.discc AS 'albums.discc', contributors.name AS
    'contributors.name', contributors.namesort AS 'contributors.namesort',
    albums.disc AS 'albums.disc', albums.titlesort AS 'albums.titlesort',
    albums.titlesearch AS 'albums.titlesearch', albums.contributor AS
    'albums.contributor', albums.id AS 'albums.id', albums.title AS
    'albums.title', albums.artwork AS 'albums.artwork', albums.compilation
    AS 'albums.compilation', albums.year AS 'albums.year' FROM albums JOIN
    contributor_album ON contributor_album.album = albums.id JOIN
    contributors ON contributors.id = contributor_album.contributor JOIN
    tracks ON tracks.album = albums.id JOIN library_track ON
    library_track.track = tracks.id WHERE contributor_album.role IN (5,1)
    and library_track.library = "2da2d7ab" group by albums.id order by
    contributors.namesort,albums.year, albums.titlesort limit 10;

    Get a list of library IDs:

    SELECT library FROM library_tracks GROUP BY library;

    --

    Michael
    Took 2s in my Dual Core XP 3.01 GHz, 4GB (limited to 3 by XP).

    Library: 58K tracks, 4K Albums, 9K Artists.
    SubLibrary: 30K tracks, 2K Albums, 3K Artists.

    Marco
    __________________________________________________ ______________________
    Author of C-3PO plugin, Squeezelite-R2, Falcon Web interface - See www.marcoc1712.it

  10. #150
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,472

    Multi Library support in LMS 7.9

    > OK, I've sent the library.db. Please let me know if you didn't get it,
    > was still 18MB or so...


    logitech.com or herger.net? Haven't received anything...

    --

    Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •