Bug 1982 - Wrong list of Albums for Artist
: Wrong list of Albums for Artist
Status: RESOLVED INVALID
Product: Logitech Media Server
Classification: Unclassified
Component: Audio
: unspecified
: PC Linux (other)
: P2 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2005-08-15 13:41 UTC by Hakan Tandogan
Modified: 2011-03-16 04:39 UTC (History)
0 users

See Also:
Category: ---


Attachments
part of screen shot displaying the problem (12.91 KB, image/jpeg)
2005-08-15 13:42 UTC, Hakan Tandogan
Details
Logfile with --d_sql (4.18 KB, text/plain)
2005-08-15 14:13 UTC, Hakan Tandogan
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Hakan Tandogan 2005-08-15 13:41:28 UTC
I'm running SVN revision 3975 on Linux with a MySQL backend.

I have multiple albums from Dire Straits. If I go to the "Browse Artists" page
and select Dire Straits, the header line reads "3 albums with 33 songs by 1
artist", but in the list below, I see only the first album (part of screen shot
attached).

If I go through "Browse Music Folder", I can see all three albums (o.k., all
three directories where I put the songs into, one directory per album like just
everyone else).

This happens even after I clear the database and do a full rescan.
Comment 1 Hakan Tandogan 2005-08-15 13:42:06 UTC
Created attachment 728 [details]
part of screen shot displaying the problem
Comment 2 Dan Sully 2005-08-15 13:47:45 UTC
What does the output of --d_sql say?
Comment 3 Hakan Tandogan 2005-08-15 14:13:35 UTC
Created attachment 730 [details]
Logfile with --d_sql

I just restarted the server and clicked on the Artist link
(http://my-server:9000/Fishbone/browsedb.html?hierarchy=artist,album,track&level=1&artist=28&player=my-player-id-here)
again.

If I manually run the query from the logfile, I get only one row from the
database.

If I omit the "AND contributor_track.role IN (1, 5)" part, I get all three
rows.


Regards,
Hakan
Comment 4 Dan Sully 2005-08-15 14:15:14 UTC
What do the tags look like for ARTIST, etc on those two albums? I'm betting that ARTIST isn't set.
Comment 5 Dan Sully 2005-09-15 11:47:06 UTC
Hakan - any update here? Is this still happening?
Comment 6 Hakan Tandogan 2005-09-15 11:56:55 UTC
Sorry, I was in the process of cleaning up the tags on my tracks.

At the moment (SVN 4294, database dropped and freshly rescanned) this doesn't
happen anymore for the few artists I have tested. Please close the bug; I'll
create a new one if I encounter this problem again.


Regards,
Hakan