Bug 2064 - Incorrect title and titlesort in tracks table
: Incorrect title and titlesort in tracks table
Status: RESOLVED INVALID
Product: Logitech Media Server
Classification: Unclassified
Component: Tagging
: 6.1.2
: PC RedHat Linux
: P2 normal (vote)
: ---
Assigned To: Dan Sully
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2005-09-02 20:23 UTC by Greg Whalin
Modified: 2005-09-03 07:58 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Greg Whalin 2005-09-02 20:23:32 UTC
I see this happen from time to time, but have yet to find what is causing it.  A
quick example of the problem.

[fw] [~/media/music/flac/clinic/internal_wrangler] > metaflac --list
01_voodoo_wop.flac --block-number=2
METADATA block #2
  type: 4 (VORBIS_COMMENT)
  is last: false
  length: 175
  vendor string: reference libFLAC 1.1.0 20030126
  comments: 7
    comment[0]: TITLE=Voodoo Wop
    comment[1]: ALBUM=Internal Wrangler
    comment[2]: TRACKNUMBER=01
    comment[3]: ARTIST=Clinic
    comment[4]: GENRE=Alternative
    comment[5]: CDDB=9d07480e
    comment[6]: DATE=2000-o
[fw] [~/media/music/flac/clinic/internal_wrangler] > 

and in the db ...

*************************** 5. row ***************************
                id: 1610
               url:
file:///home/gwhalin/media/music/flac/clinic/internal_wrangler/01_voodoo_wop.flac
             title: Doves - Pounding
         titlesort: DOVES POUNDING
             album: 107
          tracknum: 1
                ct: flc
               tag: 1
               age: 1125539671
                fs: 10250631
              size: 10250631
            offset: 0
              year: 2000
              secs: 101
             cover: NULL
         covertype: NULL
             thumb: NULL
         thumbtype: NULL
         vbr_scale: NULL
           bitrate: 805196
              rate: 44100
        samplesize: NULL
          channels: 2
        blockalign: NULL
            endian: NULL
               bpm: NULL
        tagversion: NULL
           tagsize: NULL
               drm: NULL
            rating: NULL
              disc: NULL
         playCount: NULL
        lastPlayed: NULL
      moodlogic_id: NULL
 moodlogic_mixable: NULL
musicmagic_mixable: NULL
 multialbumsortkey: CLINIC INTERNAL WRANGLER 001 DOVES POUNDING

Notice that the title is tagged w/ Doves The Pounding instead of the appropriate
tag info from the flac file.

I can get you more info and/or server access to take a look at this to help
matters along.  I am currently installed off of
slimserver-2005_08_31-1.noarch.rpm, and just switched to using mysql as backend
(same issue happened w/ SQLLite).

Thanks for any help here!
Comment 1 Greg Whalin 2005-09-02 20:24:52 UTC
Setting version info in bugzilla (missed it on bug creation).
Comment 2 KDF 2005-09-02 21:59:03 UTC
got any playlists that refer to that file with #EXTINF metadata?
cue sheets?
have you considered trying 6.2.0 nightlies, instead 6.1.2?  Most of the ongoing
work to fix database bugs is being done in 6.2
Comment 3 Greg Whalin 2005-09-03 07:19:00 UTC
> got any playlists that refer to that file with #EXTINF metadata?

Yikes!  That was it.  Had a playlist sitting there that had a few EXTINF lines
in it that I did not know was there.

Sorry for the false alarm here.  Please feel free to mark this bug as INVALID
and thanks for the quick fix.