Bugzilla – Bug 3487
Browsing into an album from song info displays all albums
Last modified: 2008-09-15 14:39:24 UTC
If I drill down via song info into the album, slimserver displays all albums, not the tracks on the selected album.
Also browsing to the artist from song info displays a list of all albums.
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).
possible fix in trunk change 7773
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 ()
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.