Bug 12210 - Scanner will die when scanning special characters in filename
: Scanner will die when scanning special characters in filename
Status: RESOLVED DUPLICATE of bug 12188
Product: Logitech Media Server
Classification: Unclassified
Component: Scanner
: 7.4.0
: PC Windows Server 2003
: P4 critical (vote)
: ---
Assigned To: Unassigned bug - please assign me!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-05-29 23:59 UTC by Hartmut Schulla
Modified: 2009-05-31 10:01 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Hartmut Schulla 2009-05-29 23:59:41 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.
]
Comment 1 James Richardson 2009-05-31 10:01:02 UTC

*** This bug has been marked as a duplicate of bug 12188 ***