[SlimDevices: Beta] Re: Slimserver loses all my music on latest trunk :-(

[JJZolx]

Triode;169335 Wrote: 
> Thanks Jim - looks to me that you have a song with a path longer than
> 255 characters?  Just looked and I made the info entry 255 characters
> long.  I need to add something to trucate strings before  adding them
> to the database.

No, that doesn't seem to be the problem.  Here's the scanner.log again,
this time with the scan.scanner debug switch enabled.  The file that it
chokes on is:

L:\flac\André Previn\After Hours\01 There'll Never Be Another You.flac

Could it be the unicode character in the folder name?


Code:
--------------------
    [12:04:58.3108] Slim::Utils::Scanner::scanDirectory (325) Adding file:///E:/flac/America/The%20Complete%20Greatest%20Hits/22%20Paradise.flac to database.
  [12:04:58.3692] Slim::Utils::Scanner::scanDirectory (325) Adding file:///E:/flac/Andr%E9%20Previn/After%20Hours/01%20There%27ll%20Never%20Be%20Another%20You.flac to database.
  [12:04:58.6897] Slim::Schema::Storage::throw_exception (69) Error: Error executing 'UPDATE progress SET done = ?, info = ? WHERE ( id = ? )': DBD::mysql::st execute failed: Data too long for column 'info' at row 1 at C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
  [12:04:58.6904] Slim::Schema::Storage::throw_exception (69) Backtrace:
  
  frame 0: Slim::Utils::Log::logBacktrace (C:/Program Files/SlimServer Dot3/server/Slim/Schema/Storage.pm line 69)
  frame 1: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
  frame 2: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Storage/DBI.pm line 797)
  frame 3: DBIx::Class::Storage::DBI::update (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Row.pm line 115)
  frame 4: DBIx::Class::Row::update (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Relationship/CascadeActions.pm line 30)
  frame 5: DBIx::Class::Relationship::CascadeActions::update (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/InflateColumn.pm line 222)
  frame 6: DBIx::Class::InflateColumn::update (C:/Program Files/SlimServer Dot3/server/Slim/Schema/DBI.pm line 35)
  frame 7: Slim::Schema::DBI::update (C:/Program Files/SlimServer Dot3/server/Slim/Utils/Progress.pm line 143)
  frame 8: Slim::Utils::Progress::update (C:/Program Files/SlimServer Dot3/server/Slim/Utils/Scanner.pm line 319)
  frame 9: Slim::Utils::Scanner::scanDirectory (C:/Program Files/SlimServer Dot3/server/Slim/Music/MusicFolderScan.pm line 76)
  frame 10: Slim::Music::MusicFolderScan::startScan (C:/Program Files/SlimServer Dot3/server/Slim/Music/Import.pm line 421)
  frame 11: Slim::Music::Import::runImporter (C:/Program Files/SlimServer Dot3/server/Slim/Music/Import.pm line 268)
  frame 12: Slim::Music::Import::runScan (C:/Program Files/SlimServer Dot3/server/scanner.pl line 181)
  frame 13: (eval) (C:/Program Files/SlimServer Dot3/server/scanner.pl line 175)
  frame 14: main::main (C:/Program Files/SlimServer Dot3/server/scanner.pl line 311)
  
  [12:04:58.7009] main::main (187) Error: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'UPDATE progress SET done = ?, info = ? WHERE ( id = ? )': DBD::mysql::st execute failed: Data too long for column 'info' at row 1 at C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
  ]
  [12:04:58.7014] main::main (188) Error: Skipping post-process & Not updating lastRescanTime!
  [12:04:59.2319] Slim::bootstrap::theEND (338) Got to the END
  [12:04:59.2324] Slim::bootstrap::sigint (302) Got sigint
--------------------


-- 
JJZolx

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