Bug 10426 - Albums with tracks from more than one year can result in empy years
: Albums with tracks from more than one year can result in empy years
Status: NEW
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 7.4.0
: PC Windows Vista
: P3 minor with 5 votes (vote)
: Future
Assigned To: Andy Grundman
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2008-12-22 11:01 UTC by Nigel Birch
Modified: 2011-04-08 02:02 UTC (History)
5 users (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nigel Birch 2008-12-22 11:01:39 UTC
This is with SqueezeCentre v7.3.1.

I have an album where different tracks have different years, e.g.:

TRACKNUMBER=1
TITLE=India
YEAR=1961
ALBUM=Impressions
ARTIST=John Coltrane

TRACKNUMBER=2
TITLE=Up 'against The Wall
YEAR=1961
ALBUM=Impressions
ARTIST=John Coltrane

TRACKNUMBER=3
TITLE=Impressions
YEAR=1962
ALBUM=Impressions
ARTIST=John Coltrane

TRACKNUMBER=4
TITLE=After The Rain
YEAR=1963
ALBUM=Impressions
ARTIST=John Coltrane

When browsing (player UI or web interface) under years, 1961 shows but has no albums listed.

I assume this is because the scanner adds all tracks to the album, then cleans up and keeps the year for the album from the last track imported (bug 5211 related?), leaving empty years (if there are no other albums from that year).  In this case, I would expect that these would be cleaned up so that no empty years remain.

Thanks.
Comment 1 James Richardson 2009-01-07 15:04:58 UTC
Brandon:  Would this be solved by new schema?
Comment 2 Alessandro Guida 2009-01-17 06:29:26 UTC
I have the same problem in 7.3.3. Here is what I did:

* I created an album (FLAC) with 5 songs with 5 different years (from (1951 to
1955). 
* Done a clean and full rescan

Then I try to browse by Year and there is nothing under the years 1951 to 1954.
Under 1955 the album is listed (not sure whether it takes the highest or just
the last - should be the highest) but only one song (the one with 1955 as year)
is listed. The other 4 songs are not to be found anywhere!!!

So as it is now it doesn't work at all, which means Severity should be Major
and priority hopefully P1 and definetely we should not wait to the 8.0 release to fix this.

Note that there are really two probelms here:

1. What year to use for the albums that contain tracks form different years. This is already tracked (and suggestions made) in bug 5211.
2. Browsing by year should show the songs that have that year a track year. Nothing to do with what the album release date is. This is what this bug is about. 

Comment 3 Claus Hindsgaul 2009-02-09 06:09:50 UTC
(In reply to comment #2)
> I have the same problem in 7.3.3. Here is what I did:

I will just confirm to have excactly the same problem with empty choices in "browse by year" caused by compilations of songs from different years.
Comment 4 Sean Echevarria 2010-05-27 11:37:23 UTC
see also bug 12658
Comment 5 vagskal 2010-07-15 01:23:50 UTC
See also bug 15167
Comment 6 Mike Walsh 2011-04-08 01:36:30 UTC
Alan, i thought this might be inside the scope of onebrowser
Comment 7 Alan Young 2011-04-08 02:02:08 UTC
Would you like to test it?