I tried to "only rescan playlists" today, but the Database optimization phase is throwing exceptions. Note that the scanner progress doesn't report a problem - says "The server has finished scanning your music collection.", but the log does report errors:
[21:14:23.1988] Slim::Music::Import::runScanPostProcessing (483) Starting Database optimization. [21:14:23.6093] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::db do failed: Column was set to data type implicit default; NULL supplied for NOT NULL column 'album' at row 1 [21:14:23.6101] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 957) frame 2: DBIx::Class::Storage::DBI::__ANON__ (P:/Music/SlimServer/trunk/server/Slim/Utils/SQLHelper.pm line 83) frame 3: (eval) (P:/Music/SlimServer/trunk/server/Slim/Utils/SQLHelper.pm line 83) frame 4: Slim::Utils::SQLHelper::executeSQLFile (P:/Music/SlimServer/trunk/server/Slim/Schema.pm line 433) frame 5: (eval) (P:/Music/SlimServer/trunk/server/Slim/Schema.pm line 432) frame 6: Slim::Schema::optimizeDB (P:/Music/SlimServer/trunk/server/Slim/Music/Import.pm line 487) frame 7: Slim::Music::Import::runScanPostProcessing (P:/Music/SlimServer/trunk/server/scanner.pl line 317) frame 8: (eval) (P:/Music/SlimServer/trunk/server/scanner.pl line 317) frame 9: main::main (P:/Music/SlimServer/trunk/server/scanner.pl line 454) [21:14:23.6108] Slim::Utils::SQLHelper::executeSQLFile (85) Error: Couldn't execute SQL statement: [INSERT INTO contributor_album (role,contributor,album) SELECT DISTINCT role,contributor,album FROM contributor_track,tracks where tracks.id=contributor_track.track;] : [Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::db do failed: Column was set to data type implicit default; NULL supplied for NOT NULL column 'album' at row 1 at P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm line 86 ] [21:14:36.0626] Slim::Music::Import::endImporter (700) Completed dbOptimize Scan in 12 seconds. SBS 7.5.1, SVN 30928. Phil _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
