Home of the Squeezebox™ & Transporter® network music players.
Results 1 to 2 of 2
  1. #1

    7.4 scanning issues (multidisc sets, flac/cue)

    Just upgraded to Squeezebox Server 7.4 without a hitch, except that the new scanning module is having trouble recognising my multidisc sets (this worked fine under previous versions).

    This is specifically with albums ripped to single flac files with cue sheets. I have set multi-disc sets to be recognised as a single album, but the new scanner does not pick up the disc number ("REM DISC" in the cue sheet) or total discs ("REM DISCC" in the cue sheet) tags, but more fatally also completely misses the last track of each disc. Hence tracks are displayed in tracknumber order only, mixing up the multi discs, with the last track of each disc missing.

    Folder structure is "my music\artist\album\..." so all cue sheets for multi-disc sets are in the same folder (as are the flac files they point to obviously).

    No relevant errors in the scanner log (there are other errors relating to other files, but that might be for another post).

    I've had a look at the MySQL database data, and can confirm that the "disc" and "discc" columns are not being populated for these tracks in the Tracks table. Should I file a bug, or just change the way I set up my cue sheets? If so, how?

    System info:

    Version: 7.4.0 - r28672 @ Mon Sep 28 19:51:11 PDT 2009
    OS: Windows XP - EN - cp1252
    Platform: 586
    Perl Version: 5.10.0 - MSWin32-x86-multi-thread
    MySQL Version: 5.1.34-community

    Sample cue sheet below:

    Code:
    REM DISC 1
    REM DISCC 2
    REM GENRE "C19th/C20th Classical"
    REM DATE 1971
    REM DISCID B9125C0D
    REM COMMENT "ExactAudioCopy v0.99pb4"
    CATALOG 0028943873123
    PERFORMER "Beethoven"
    TITLE "Beethoven · Favourite Piano Sonatas"
    REM REPLAYGAIN_ALBUM_GAIN -1.24dB
    REM REPLAYGAIN_ALBUM_PEAK 0.993500
    FILE "Beethoven · Favourite Piano Sonatas (Disc 1).flac" WAVE
      TRACK 01 AUDIO
        TITLE "Sonata N°8 In C Minor, Op.13 'Pathetique' - I. Grave - Allegro Di Molto E Con Brio"
        PERFORMER "Beethoven"
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        ISRC NLA507500177
        REM REPLAYGAIN_TRACK_GAIN +1.57dB
        REM REPLAYGAIN_TRACK_PEAK 0.772278
        INDEX 00 00:00:00
        INDEX 01 00:00:32
      TRACK 02 AUDIO
        TITLE "Sonata N°8 In C Minor, Op.13 'Pathetique' - II. Adagio Cantabile"
        PERFORMER "Beethoven"
        ISRC NLA507500178
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        REM REPLAYGAIN_TRACK_GAIN +9.29dB
        REM REPLAYGAIN_TRACK_PEAK 0.462219
        INDEX 00 09:40:34
        INDEX 01 09:43:32
      TRACK 03 AUDIO
        TITLE "Sonata N°8 In C Minor, Op.13 'Pathetique' - III. Rondo (Allegro)"
        PERFORMER "Beethoven"
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        ISRC NLA507500179
        REM REPLAYGAIN_TRACK_GAIN +2.29dB
        REM REPLAYGAIN_TRACK_PEAK 0.619812
        INDEX 01 15:03:32
      TRACK 04 AUDIO
        TITLE "Sonata N°14 In C Sharp Minor, Op.27, N°2 'Moonlight' - I. Adagio Sostenuto"
        PERFORMER "Beethoven"
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        ISRC NLA507200089
        REM REPLAYGAIN_TRACK_GAIN +3.38dB
        REM REPLAYGAIN_TRACK_PEAK 0.606781
        INDEX 00 19:34:33
        INDEX 01 19:41:32
      TRACK 05 AUDIO
        TITLE "Sonata N°14 In C Sharp Minor, Op.27, N°2 'Moonlight' - II. Allegretto"
        PERFORMER "Beethoven"
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        ISRC NLA507200090
        REM REPLAYGAIN_TRACK_GAIN -1.85dB
        REM REPLAYGAIN_TRACK_PEAK 0.898651
        INDEX 01 25:43:57
      TRACK 06 AUDIO
        TITLE "Sonata N°14 In C Sharp Minor, Op.27, N°2 'Moonlight' - III. Presto"
        PERFORMER "Beethoven"
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        ISRC NLA507200091
        REM REPLAYGAIN_TRACK_GAIN -3.08dB
        REM REPLAYGAIN_TRACK_PEAK 0.993500
        INDEX 01 28:09:20
      TRACK 07 AUDIO
        TITLE "Sonata N°15 In D Major, Op.28 'Pastoral' - I. Allegro"
        PERFORMER "Beethoven"
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        ISRC NLA507625105
        REM REPLAYGAIN_TRACK_GAIN -2.03dB
        REM REPLAYGAIN_TRACK_PEAK 0.976532
        INDEX 00 35:40:33
        INDEX 01 35:50:32
      TRACK 08 AUDIO
        TITLE "Sonata N°15 In D Major, Op.28 'Pastoral' - II. Andante"
        PERFORMER "Beethoven"
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        ISRC NLA507625106
        REM REPLAYGAIN_TRACK_GAIN -0.26dB
        REM REPLAYGAIN_TRACK_PEAK 0.904541
        INDEX 00 46:30:32
        INDEX 01 46:37:32
      TRACK 09 AUDIO
        TITLE "Sonata N°15 In D Major, Op.28 'Pastoral' - III. Scherzo (Allegro Assai)"
        PERFORMER "Beethoven"
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        ISRC NLA507625107
        REM REPLAYGAIN_TRACK_GAIN -0.54dB
        REM REPLAYGAIN_TRACK_PEAK 0.888397
        INDEX 01 53:25:57
      TRACK 10 AUDIO
        TITLE "Sonata N°15 In D Major, Op.28 'Pastoral' - IV. Rondo (Allegro Ma Non Troppo)"
        PERFORMER "Beethoven"
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        ISRC NLA507625108
        REM REPLAYGAIN_TRACK_GAIN -1.92dB
        REM REPLAYGAIN_TRACK_PEAK 0.942200
        INDEX 01 55:43:32
      TRACK 11 AUDIO
        TITLE "Sonata N°26 In E Flat, Op.81a 'Les Adieux' - I. Das Lebewohl (Adagio - Allegro)"
        PERFORMER "Beethoven"
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        ISRC NLA507625122
        REM REPLAYGAIN_TRACK_GAIN -0.04dB
        REM REPLAYGAIN_TRACK_PEAK 0.818329
        INDEX 00 61:04:32
        INDEX 01 61:12:32
      TRACK 12 AUDIO
        TITLE "Sonata N°26 In E Flat, Op.81a 'Les Adieux' - II. Abwesenheit (Andante Espressivo)"
        PERFORMER "Beethoven"
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        ISRC NLA507625123
        REM REPLAYGAIN_TRACK_GAIN +3.59dB
        REM REPLAYGAIN_TRACK_PEAK 0.546753
        INDEX 00 68:26:33
        INDEX 01 68:32:32
      TRACK 13 AUDIO
        TITLE "Sonata N°26 In E Flat, Op.81a 'Les Adieux' - III. Das Wiedersehen (Vivacissimamento)"
        PERFORMER "Beethoven"
        REM BAND "Alfred Brendel (Piano)"
        REM COMPOSER "Beethoven, Ludwig Van"
        ISRC NLA507625124
        REM REPLAYGAIN_TRACK_GAIN -1.46dB
        REM REPLAYGAIN_TRACK_PEAK 0.826904
        INDEX 01 72:28:70

  2. #2

    Follow up...

    Actually, I think I posted too hastily, and mixed up 2 issues. The discnumber and total discs tags are not being picked up (ISSUE 1), but closer examination reveals that the last track is missing on ALL my albums, not just multdisc sets (ISSUE 2). Edited extracts from scanner log here (this is repeated for all albums):

    Code:
    [09-09-29 10:07:03.4047] Slim::Formats::Playlists::parseList (83) Error: While running $playlistClass->read(): [Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Out of range value for column 'secs' at row 1 [for Statement "INSERT INTO tracks (audio_offset,audio_size,secs,replay_peak,remote,titlesort,audio,tracknum,content_type,titlesearch,replay_gain,url,title,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)"] at /<D:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Schema/Storage.pm line 86]
    [09-09-29 10:07:03.4054] Slim::Utils::Scanner::scanDirectory (328) Scanning: V:\My Music\William Basinski\Variations For Piano & Tape\Variations For Piano & Tape.cue
    [09-09-29 10:07:03.4493] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Data truncated for column 'replay_gain' at row 1 [for Statement "INSERT INTO tracks (bitrate,audio_offset,audio_size,vbr_scale,replay_peak,samplesize,remote,titlesort,audio,timestamp,replay_gain,url,lossless,channels,samplerate,secs,content_type,tracknum,titlesearch,title,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"]
    [09-09-29 10:07:03.4497] Slim::Schema::Storage::throw_exception (82) Backtrace:
    
    "SNIP"
    
    [09-09-29 10:07:03.4503] Slim::Formats::readTags (180) Error: While trying to ->getTag(V:\My Music\William Basinski\Variations For Piano & Tape\Variations For Piano & Tape.flac) : Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Data truncated for column 'replay_gain' at row 1 [for Statement "INSERT INTO tracks (bitrate,audio_offset,audio_size,vbr_scale,replay_peak,samplesize,remote,titlesort,audio,timestamp,replay_gain,url,lossless,channels,samplerate,secs,content_type,tracknum,titlesearch,title,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"] at /<D:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Schema/Storage.pm line 86
    [09-09-29 10:07:03.4507] Slim::Formats::readTags (180) Backtrace:
    
    "SNIP"
    
    [09-09-29 10:07:03.4510] Slim::Formats::Playlists::CUE::parse (191) Warning: Use of uninitialized value in int at /<D:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Formats/Playlists/CUE.pm line 191.
    [09-09-29 10:07:03.4513] Slim::Formats::Playlists::CUE::parse (191) Warning: Use of uninitialized value in modulus (%) at /<D:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Formats/Playlists/CUE.pm line 191.
    [09-09-29 10:07:03.4515] Slim::Formats::Playlists::CUE::parse (191) Warning: Use of uninitialized value in int at /<D:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Formats/Playlists/CUE.pm line 191.
    [09-09-29 10:07:03.4518] Slim::Formats::Playlists::CUE::parse (191) Warning: Use of uninitialized value in subtraction (-) at /<D:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Formats/Playlists/CUE.pm line 191.
    [09-09-29 10:07:03.4520] Slim::Formats::Playlists::CUE::parse (217) Error: Couldn't get duration of file:///V:/My%20Music/William%20Basinski/Variations%20For%20Piano%20&%20Tape/Variations%20For%20Piano%20&%20Tape.flac
    [09-09-29 10:07:03.4596] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Data truncated for column 'replay_gain' at row 1 [for Statement "INSERT INTO tracks (bitrate,audio_offset,audio_size,vbr_scale,replay_peak,samplesize,remote,titlesort,audio,timestamp,replay_gain,url,lossless,channels,samplerate,secs,content_type,tracknum,titlesearch,title,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"]
    [09-09-29 10:07:03.4600] Slim::Schema::Storage::throw_exception (82) Backtrace:
    
    "SNIP"
    
    [09-09-29 10:07:03.4606] Slim::Formats::readTags (180) Error: While trying to ->getTag(V:\My Music\William Basinski\Variations For Piano & Tape\Variations For Piano & Tape.flac) : Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Data truncated for column 'replay_gain' at row 1 [for Statement "INSERT INTO tracks (bitrate,audio_offset,audio_size,vbr_scale,replay_peak,samplesize,remote,titlesort,audio,timestamp,replay_gain,url,lossless,channels,samplerate,secs,content_type,tracknum,titlesearch,title,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"] at /<D:\PROGRA~1\SQUEEZ~2\server\scanner.exe>Slim/Schema/Storage.pm line 86
    [09-09-29 10:07:03.4610] Slim::Formats::readTags (180) Backtrace:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •