Bugzilla – Bug 1781
Wrong song title attached to songs in db
Last modified: 2011-03-16 04:40:39 UTC
For some reason, the wrong song title is being attached to several songs in my database. 6.0.2 has no problem here - the issue remains in the 2005-07-08 nightly version. There's no problem actually playing the music, it is just the display of titles in the Web and Player UI that is wrong. Probably the only way to discover the cause is to look at my db, so I'm going to attach it to this bug report along with a playlist that may also be involved. The incorrect song title is "With A Little Help From My Friends". It is part of the attached playlist in line 116. This playlist is in my playlistdir. file:///export/music/beatles/sgt_peppers_lonely_hearts_club_band/beatles_-_sgt_peppers_l onely_hearts_club_band.mp3#122.866666666667-286.866666666667 The song titles wrong on these albums. Every title is 'With A Little Help From My Friends' Billy Joel - Greatest Hits Volume 1 1973-1978 Billy Joel - Greatest Hits Volume 2 1978-1985 Paul Simon - Graceland Various Artists - Les Mis�rables: Highlights From The Complete Symphonic International Cast Recording Faur� - Requiem, Op. 48 / Stephen Cleobury / ECO / Choir Of King's College, Cambridge / EMI 49880
Created attachment 614 [details] sqlite database
Created attachment 615 [details] playlist in playlistdir
I've had this happen before, it always was fixed by a rescan so I never filed a bug. It seemed to be triggered most often when I was actively browsing the database while the initial scan takes place.
Unfortunately rescanning without browsing or playing music doesn't help me. I just tried another full wipe and rescan with the 2005-07-11 build and the problem is still there.
Jason - can you try out one of the 6.2 nightlies and let us know if this problem still exists? Thanks.
I just tried 2005-08-14 and the problem is still there - the same albums are affected too.
I noticed the schema was just bumped in 2005-08-15, so I wiped and gave that a try. The bug is still there.
Jason - I took a look at the DB - it's not much help unfortunately. The titles are all in there incorrectly. Could you send along the sgt peppers.mp3, and associated cue sheet (if there is one) ? Do you have tags in these files, or are you using Guess Tags? Thanks.
Created attachment 731 [details] cue sheet
The Sgt. Peppers is an album-length mp3 and too large to attach. It does not have any id3 tags, though. I've attached the cue sheet that I use for the album. I couldn't find a toggle for guess tags. I have what seem to be some default values there (since I haven't entered anything) guessFileFormats: - '(ARTIST - ALBUM) TRACKNUM - TITLE' - '/ARTIST/ALBUM/TRACKNUM - TITLE' - /ARTIST/ALBUM/TRACKNUM TITLE - /ARTIST/ALBUM/TRACKNUM. TITLE Hope this helps...
Just a note - I usually have 'include composers in artist list' turned on. I turned it off and wiped the db and the problem remained.
Jason - that pref is dynamic, you don't need to rebuild. Is there any chance I could get a login to your netbsd box?
Yes, I'll set up an account for you and send you the info via email.
Checked and this behavior does not happen with my library under Solaris with default server settings. So it's either something OS specific, a server setting, or one of my playlists. I'll try to narrow it down further by removing playlists and starting with default prefs on the NetBSD side.
Ok, I still get the incorrect behavior with a blank set of prefs and no playlists with perl 5.8.6/NetBSD. So it's back to looking at NetBSD or perl specific things.
Created attachment 832 [details] problem m3u file
When I remove the problem m3u file (see attachment) from my playlist dir and rescan, the problem goes away. In retrospect, this playlist was the obvious cause of the problem - I just didn't spot it earlier. It looks like an #EXTINF entry (added by slimserver, not me) is causing the trouble.
Jason - I just checked in a fix as subversion change 4379