Bug 3487 - Browsing into an album from song info displays all albums
: Browsing into an album from song info displays all albums
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Web Interface
: 6.5b1
: PC Windows XP
: P2 normal (vote)
: ---
Assigned To: Chris Owens
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-06-06 11:34 UTC by Philip Meyer
Modified: 2008-09-15 14:39 UTC (History)
1 user (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Philip Meyer 2006-06-06 11:34:46 UTC
If I drill down via song info into the album, slimserver displays all albums, not the tracks on the selected album.
Comment 1 Philip Meyer 2006-06-06 11:38:17 UTC
Also browsing to the artist from song info displays a list of all albums.
Comment 2 Philip Meyer 2006-06-06 11:48:29 UTC
Also browsing to the Year from the song info, although this returns the albums in alphabetical order (browsing to the artist returns the albums in artist album order).

Comment 3 KDF 2006-06-06 13:20:06 UTC
possible fix in trunk change 7773
Comment 4 KDF 2006-06-06 17:41:48 UTC
year is still buggered.  dan suggested albums.year, and album.year but neither seems to have any effect on the underlying sql call:

$VAR1 = {
          'album' => 'track',
          'year' => 'album'
        };
$VAR1 = {
          'album.year' => '1991'
        };
2006-06-06 14:03:24.6585 working on levelname: [album]
2006-06-06 14:03:24.6665 SELECT COUNT( DISTINCT( me.id ) ) FROM tracks me ()
2006-06-06 14:03:24.6720 SELECT COUNT( DISTINCT( me.id ) ) FROM albums me ()
2006-06-06 14:03:24.6776 SELECT COUNT( DISTINCT( me.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id )  JOIN alb
ums album ON ( album.id = contributorAlbums.album ) ()
2006-06-06 14:03:24.6821 find:
$VAR1 = {
          'track' => {
                       'me.year' => '1991'
                     }
        };
2006-06-06 14:03:24.6829 running resultset on: album
working on level: [Year]
$self->result_class: [Slim::Schema::Year]
$self->result_source->schema->source($level)->result_class: [Slim::Schema::Year]
Calling method: [browse]
working on level: [Album]
$self->result_class: [Slim::Schema::Year]
$self->result_source->schema->source($level)->result_class: [Slim::Schema::Album]
Calling method: [descendAlbum]
2006-06-06 14:03:24.6898 SELECT COUNT( DISTINCT( me.id ) ) FROM albums me ()
2006-06-06 14:03:24.6935 SELECT LEFT(me.titlesort, 1), COUNT( DISTINCT(me.id) ) FROM albums me GROUP BY LEFT(me.titlesort, 1) ORDER BY me.titlesort, me.disc ()
2006-06-06 14:03:24.7249 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 FROM albums me GROUP BY me.id ORDER BY me.titlesort, me.disc LIMIT 51 () 
Comment 5 KDF 2006-06-16 11:54:20 UTC
fixed using year.year instead of album.year.  This is an side-effect of the album/year class inheritance.  Since the issue in the summary now works, marking as FIXED. the inheritance problems are covered in bug 3500.