Bugzilla – Bug 15049
Scanner crashes with non-ascii title
Last modified: 2011-01-14 00:54:54 UTC
[09-11-03 21:29:31.5805] Slim::Utils::Scanner::scanDirectory (333) Scanning: F:\Audio\mp3\unsorted\Malaguena\Guitar\Paco de Lucia - Malagueña Salerosa.mp3 [09-11-03 21:29:31.5897] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Incorrect string value: '\xD1A SAL...' for column 'titlesort' at row 1 [for Statement "INSERT INTO tracks (bitrate,audio_offset,drm,audio_size,block_alignme nt,remote,audio,titlesort,timestamp,url,lossless,c hannels,samplerate,secs,filesize,content_type,titl esearch,title,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"] [09-11-03 21:29:31.5903] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 957) frame 2: DBIx::Class::Storage:BI::__ANON__ (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1001) frame 3: Slim::Schema::newTrack (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1228) frame 4: Slim::Schema::updateOrCreate (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Utils/Scanner.pm line 347) frame 5: Slim::Utils::Scanner::scanDirectory (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/MusicFolderScan.pm line 79) frame 6: Slim::Music::MusicFolderScan::startScan (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 569) frame 7: Slim::Music::Import::runImporter (/<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 374) frame 8: Slim::Music::Import::runScan (scanner.pl line 294) frame 9: (eval) (scanner.pl line 288) frame 10: main::main (scanner.pl line 439) [09-11-03 21:29:31.5915] main::main (300) Error: Failed when running main scan: [Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Incorrect string value: '\xD1A SAL...' for column 'titlesort' at row 1 [for Statement "INSERT INTO tracks (bitrate,audio_offset,drm,audio_size,block_alignme nt,remote,audio,titlesort,timestamp,url,lossless,c hannels,samplerate,secs,filesize,content_type,titl esearch,title,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"] at /<C:\PROGRA~2\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 86
I just saw the identical bug in SbS 7.5. I was experimenting with scanning a folder of FLAC files with no tags, and no guess tags formats. When this case is encountered, the scanner uses the filename as the track title. It choked on this filename: 09 Corazon Espinado (Featuring Maná).flac [09-11-03 23:55:56.4392] Slim::Utils::Scanner::scanDirectory (333) Scanning: F:\Flac Test1\Santana\Supernatural\09 Corazon Espinado (Featuring Maná).flac [09-11-03 23:55:56.4456] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Incorrect string value: '\xC1' for column 'titlesort' at row 1 [for Statement "INSERT INTO tracks (bitrate,audio_offset,drm,audio_size,vbr_scale,remote,samplesize,audio,titlesort,timestamp,url,lossless,channels,samplerate,secs,filesize,content_type,titlesearch,title,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"] [09-11-03 23:55:56.4463] Slim::Schema::Storage::throw_exception (82) Backtrace:
Looks much like bug 12210, except in this bug it's failing on the titlesort colunn and in 12210 it fails on the titlesearch column. That bug was marked a dupe of another, which may have been incorrect.
Andy: is this yours to look at?
Yeah I'll look at it. Brad: does this file have tags or did you run into the same bug as Jim?
May be the same... Said file is/was indeed tagless..
Brad - is this still an issue?
I just ran a test with SbS 7.5 r29483 and the scanner still crashes in the same manner described above when it encounters a file with no tags and 'special' characters in the filename.
This also appears to affect the same INSERT INTO tracks statement in browse Music Folder (both 7.4 and 7.5 trunk, 7.3.4 is OK), resulting in the web interface and SqueezePlay interfaces hanging up when trying to browse the Music Folder.
I can't reproduce this, tried on Windows with 7.5 trunk. I wonder if you could maybe attach a zip file with the file in question, maybe copy/paste and rename didn't work properly or something.
Moving P3 and lower bugs to next release target
Attachments welcome