This file has grief. 

I'm surprised that Squeezebox Server scans the file at all for you.  It
crashes my scanner with its multiple REPLAY_GAIN tags. (Squeezebox
Server's scanner doesn't validate data very well - it joins the multiple
RG tags, attempts to insert something that doesn't look like a valid
number into a numeric field in the database and crashes with a database
error.)

I have a feeling you already worked on this file with Mp3tag.  The file
posted has multiple FLAC vorbis comment blocks, not just repeats of
fields within what should be a single comment block.  I can't figure how
to edit it in Mp3tag, as it tends to add additional FLAC comment blocks
when you do.  Can't even strip out all of the tags to start over.

Metaflac can strip out the multiple vorbis comment blocks using the
following.  The embedded cover art should be preserved.


Code:
--------------------
    metaflac --remove --block-type=VORBIS_COMMENT --dont-use-padding [FLACfile]
--------------------


Andy, if you're still watching, here's the scanner crash on the RG
tag:


Code:
--------------------
    [09-10-17 23:34:13.7238] Slim::Utils::Scanner::scanDirectory (333) 
Scanning: F:\Flac Test1\Bibio\Ambivalence Avenue\01 Bibio - Ambivalence 
Avenue.flac
  [09-10-17 23:34:13.7341] 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,drm,audio_size,vbr_scale,replay_peak,samplesize,remote,titlesort,audio,cover,timestamp,replay_gain,url,lossless,channels,samplerate,secs,filesize,content_type,titlesearch,title,year)
 VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"]
  [09-10-17 23:34:13.7349] Slim::Schema::Storage::throw_exception (82) 
Backtrace:
  
  frame 0: Slim::Utils::Log::logBacktrace (C:/Program Files/Squeezebox Server 
7.4 Trunk/server/Slim/Schema/Storage.pm line 82)
  frame 1: Slim::Schema::Storage::throw_exception (C:\Program Files\Squeezebox 
Server 7.4 Trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 957)
  frame 2: DBIx::Class::Storage::DBI::__ANON__ (C:/Program Files/Squeezebox 
Server 7.4 Trunk/server/Slim/Schema.pm line 1001)
  frame 3: Slim::Schema::newTrack (C:/Program Files/Squeezebox Server 7.4 
Trunk/server/Slim/Schema.pm line 1228)
  frame 4: Slim::Schema::updateOrCreate (C:/Program Files/Squeezebox Server 7.4 
Trunk/server/Slim/Utils/Scanner.pm line 347)
  frame 5: Slim::Utils::Scanner::scanDirectory (C:/Program Files/Squeezebox 
Server 7.4 Trunk/server/Slim/Music/MusicFolderScan.pm line 79)
  frame 6: Slim::Music::MusicFolderScan::startScan (C:/Program Files/Squeezebox 
Server 7.4 Trunk/server/Slim/Music/Import.pm line 569)
  frame 7: Slim::Music::Import::runImporter (C:/Program Files/Squeezebox Server 
7.4 Trunk/server/Slim/Music/Import.pm line 374)
  frame 8: Slim::Music::Import::runScan (C:/Program Files/Squeezebox Server 7.4 
Trunk/server/scanner.pl line 294)
  frame 9: (eval) (C:/Program Files/Squeezebox Server 7.4 
Trunk/server/scanner.pl line 288)
  frame 10: main::main (C:/Program Files/Squeezebox Server 7.4 
Trunk/server/scanner.pl line 439)
  
  [09-10-17 23:34:13.7363] main::main (300) Error: Failed when running main 
scan: [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,drm,audio_size,vbr_scale,replay_peak,samplesize,remote,titlesort,audio,cover,timestamp,replay_gain,url,lossless,channels,samplerate,secs,filesize,content_type,titlesearch,title,year)
 VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"] at C:/Program 
Files/Squeezebox Server 7.4 Trunk/server/Slim/Schema/Storage.pm line 86]
  [09-10-17 23:34:13.7369] main::main (301) Error: Skipping post-process & Not 
updating lastRescanTime!
  
--------------------


-- 
JJZolx

Jim
------------------------------------------------------------------------
JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10
View this thread: http://forums.slimdevices.com/showthread.php?t=69897

_______________________________________________
ripping mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/ripping

Reply via email to