Any thought on why I'm getting a 'data too long message'? The title field is of type text, so I'd guess that the complaint about the data being too long is spurious, and the problem is caused by the wide characters in the title. SlimServer v6.5 R7937 reports the system charset as cp1251, although the tables that have been created are in utf8. The two characters prior to the ' = 84' are U+1D15E and U+1D16D.
Chris Key 2006-06-13 10:30:33.5212 ERROR: newTrack: Couldn't create Track for file:///D:/iTunes%20Music/Beethoven%3B%20Royal%20Liverpool%20Philharmonic/Th e%20Nine%20Symphonies/5-08%20IV.%20Allegro%20Energic o%20E%20Sempre%20B.m4a : DBIx::Class::ResultSet::create(): Error executing 'INSERT INTO tracks (audio, bitrate, content_type, disc, filesize, remote, samplerate, secs, title, titlesearch, titlesort, tracknum, url, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' (`1', `686000', `mov', `5', `11360077', `0', `44100', `131.84', `IV. Allegro energico e sempre ben marcato Øà×Øà¡ = 84', `IV ALLEGRO ENERGICO E SEMPRE BEN MARCATO Øà×Øà¡ 84', `IV ALLEGRO ENERGICO E SEMPRE BEN MARCATO Øà×Øà¡ 84', `8', `file:///D:/iTunes%20Music/Beethoven%3B%20Royal%20Liverpool%20Philharmonic/T he%20Nine%20Symphonies/5-08%20IV.%20Allegro%20Energico%20E%20Sempre%20B.m4a' , `1991'): DBD::mysql::st execute failed: Data too long for column 'title' at row 1 at C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server\CPAN/DBIx/Class/Storage/DBI. pm line 525. DBD::mysql::st execute failed: Data too long for column 'title' at row 1 at C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server\CPAN/DBIx/Class/Storage/DBI. pm line 525. 2006-06-13 10:30:33.5514 Backtrace: frame 0: Slim::Schema::newTrack (C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server/Slim/Schema.pm line 598) frame 1: Slim::Schema::updateOrCreate (C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server/Slim/Schema/ResultSet/Track .pm line 121) frame 2: Slim::Schema::ResultSet::Track::updateOrCreate (C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server/Plugins/iTunes/Importer.pm line 352) frame 3: Plugins::iTunes::Importer::handleTrack (C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server/Plugins/iTunes/Importer.pm line 554) frame 4: Plugins::iTunes::Importer::handleEndElement (C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server\CPAN/XML/Parser/Expat.pm line 470) frame 5: (eval) (C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server\CPAN/XML/Parser/Expat.pm line 470) frame 6: XML::Parser::Expat::parse (C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server\CPAN/XML/Parser.pm line 187) frame 7: (eval) (C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server\CPAN/XML/Parser.pm line 186) frame 8: XML::Parser::parse (C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server\CPAN/XML/Parser.pm line 233) frame 9: (eval) (C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server\CPAN/XML/Parser.pm line 232) frame 10: XML::Parser::parsefile (C:\DOCUME~1\Chris\MYDOCU~1\slim\TRUNK_~1\server/Plugins/iTunes/Importer.pm line 125) frame 11: Plugins::iTunes::Importer::startScan (C:/DOCUME~1/Chris/MYDOCU~1/slim/TRUNK_~1/server/Slim/Music/Import.pm line 170) frame 12: Slim::Music::Import::runImporter (C:/DOCUME~1/Chris/MYDOCU~1/slim/TRUNK_~1/server/Slim/Music/Import.pm line 111) frame 13: Slim::Music::Import::startScan (C:/DOCUME~1/Chris/MYDOCU~1/slim/TRUNK_~1/server/scanner.bat line 157) frame 14: (eval) (C:/DOCUME~1/Chris/MYDOCU~1/slim/TRUNK_~1/server/scanner.bat line 135) frame 15: main::main (C:/DOCUME~1/Chris/MYDOCU~1/slim/TRUNK_~1/server/scanner.bat line 270) _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/beta
