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
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/beta
