Bug 4900 - Roles in contributor_album Database will be overwritten
: Roles in contributor_album Database will be overwritten
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Scanner
: 6.5.2
: PC Windows XP
: P2 normal (vote)
: ---
Assigned To: Chris Owens
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2007-04-11 03:44 UTC by Controllator
Modified: 2008-12-18 11:12 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 Controllator 2007-04-11 03:44:01 UTC
I have a MP3-Album where the Artist is the Conductor.
The contributer_track Database is fine, as there are multiple entries possible.

The file has the following Tags:
TPE1 James Levine
TPE3 James Levine

This leads to Role 3 in the contributor_album Database for this Contributor and Album.
So the TPE1 is overwritten with the later TPE3.

In my opinion the TPE1 is far more important and should never overwritten.
So there should be a query to not overwrite the Role, if it's 1 or 5.
Or the simple and not reliable Solution is never overwriting.

The following Query in the Custom Browse Addon misses the the above Album, as the Role is not 1 or 5:

select albums.id,albums.title,substr(albums.titlesort,1,1) from albums,contributor_album,contributors
where
	albums.id=contributor_album.album and
	contributor_album.contributor=contributors.id and
	contributor_album.role in (1,5)
Comment 1 Squeezebox QA Team email alias 2007-05-02 12:40:33 UTC
related to bug 4925
Comment 2 Chris Owens 2007-05-15 14:53:39 UTC
Not going to get fixed for 6.5.2.
Comment 3 KDF 2007-05-17 16:03:03 UTC
since there is some mentioned relation to 4925, let's investigate for 6.5.3 and see if there is room to solve this one in that timeline.
Comment 4 KDF 2007-05-23 10:19:23 UTC
See the latest nightly builds as this is related to the checkins for bug 4882
Comment 5 Chris Owens 2007-06-21 09:46:57 UTC
Steven could you have a look and see if this bug still exists after the change KDF mentions?  Thanks.
Comment 6 Chris Owens 2007-06-27 10:53:07 UTC
Ping :)
Comment 7 Spies Steven 2007-06-28 15:30:51 UTC
Yes, this is now working for me with the latest nightly builds.  Using the example from comment #0 above I now get role 1 'ARTIST' and role 3 'CONDUCTOR' for contributer_album when before I only got role 3 'CONDUCTOR' for contributer_album.
Comment 8 KDF 2007-07-05 08:36:27 UTC
added a changelog entry at change 12335 and change 12336.
marking fixed, please reopen if there are any issues.