Bugzilla – Bug 12210
Scanner will die when scanning special characters in filename
Last modified: 2009-05-31 10:01:02 UTC
I'm using Slimserver on W2K3 with "own" MySQL-Installation: Version: 7.4 - 26452 @ Thu May 7 01:11:14 PDT 2009 Hostname: pc08 IP-Adresse des Servers: 192.168.0.8 Server-HTTP-Portnummer: 9001 Betriebssystem: Windows Server 2003 - DE - cp1252 Plattformarchitektur: 586 Perl-Version: 5.8.8 - MSWin32-x86-multi-thread MySQL-Version: 5.0.51a-community-nt When scanning the music-directory dataset names, the scanner will die by following character combinations: äß, öß, üß and ` . After replacing äß by äss everything will be fine. Some scanner messages: [09-05-29 19:20:21.4328] main::main (254) Error: Skipping post-process & Not updating lastRescanTime! [09-05-29 19:31:08.1713] main::main (138) Starting SqueezeCenter scanner (v7.4, r26452, Thu May 7 01:11:14 PDT 2009) [09-05-29 19:32:15.0703] Slim::Schema::Storage::throw_exception (81) Error: Error executing 'INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, block_alignment, content_type, drm, filesize, lossless, remote, replay_gain, replay_peak, samplerate, secs, tagversion, timestamp, title, titlesearch, titlesort, url, vbr_scale, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: Incorrect string value: '\x99LL NE...' for column 'titlesearch' at row 1 at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771. [09-05-29 19:32:15.0708] Slim::Schema::Storage::throw_exception (81) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 81) frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 773) frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 788) frame 3: DBIx::Class::Storage::DBI::insert (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Row.pm line 75) frame 4: DBIx::Class::Row::insert (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/PK/Auto.pm line 43) frame 5: DBIx::Class::PK::Auto::insert (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/ResultSet.pm line 1337) frame 6: DBIx::Class::ResultSet::create (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 994) frame 7: Slim::Schema::newTrack (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 1210) frame 8: Slim::Schema::updateOrCreate (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/Scanner.pm line 336) frame 9: Slim::Utils::Scanner::scanDirectory (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/MusicFolderScan.pm line 79) frame 10: Slim::Music::MusicFolderScan::startScan (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 520) frame 11: Slim::Music::Import::runImporter (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 349) frame 12: Slim::Music::Import::runScan (scanner.pl line 247) frame 13: (eval) (scanner.pl line 241) frame 14: main::main (scanner.pl line 387) [09-05-29 19:32:15.0743] main::main (253) Error: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, block_alignment, content_type, drm, filesize, lossless, remote, replay_gain, replay_peak, samplerate, secs, tagversion, timestamp, title, titlesearch, titlesort, url, vbr_scale, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: Incorrect string value: '\x99LL NE...' for column 'titlesearch' at row 1 at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771. ] [09-05-29 19:32:15.0746] main::main (254) Error: Skipping post-process & Not updating lastRescanTime! [09-05-29 19:35:03.5870] main::main (138) Starting SqueezeCenter scanner (v7.4, r26452, Thu May 7 01:11:14 PDT 2009) [09-05-29 19:43:23.1588] Slim::Schema::Storage::throw_exception (81) Error: Error executing 'INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, block_alignment, content_type, drm, filesize, lossless, remote, replay_gain, replay_peak, samplerate, secs, tagversion, timestamp, title, titlesearch, titlesort, url, vbr_scale, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: Incorrect string value: '\x99LL NE...' for column 'titlesearch' at row 1 at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771. [09-05-29 19:43:23.1593] Slim::Schema::Storage::throw_exception (81) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 81) frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 773) frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 788) frame 3: DBIx::Class::Storage::DBI::insert (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Row.pm line 75) frame 4: DBIx::Class::Row::insert (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/PK/Auto.pm line 43) frame 5: DBIx::Class::PK::Auto::insert (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/ResultSet.pm line 1337) frame 6: DBIx::Class::ResultSet::create (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 994) frame 7: Slim::Schema::newTrack (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/Scanner.pm line 336) frame 8: Slim::Utils::Scanner::scanDirectory (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/MusicFolderScan.pm line 79) frame 9: Slim::Music::MusicFolderScan::startScan (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 520) frame 10: Slim::Music::Import::runImporter (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 349) frame 11: Slim::Music::Import::runScan (scanner.pl line 247) frame 12: (eval) (scanner.pl line 241) frame 13: main::main (scanner.pl line 387) [09-05-29 19:43:23.1709] main::main (253) Error: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, block_alignment, content_type, drm, filesize, lossless, remote, replay_gain, replay_peak, samplerate, secs, tagversion, timestamp, title, titlesearch, titlesort, url, vbr_scale, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)': DBD::mysql::st execute failed: Incorrect string value: '\x99LL NE...' for column 'titlesearch' at row 1 at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771. ]
*** This bug has been marked as a duplicate of bug 12188 ***