(continued from previous post) frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema.pm line 236) frame 1: Slim::Schema::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Row.pm line 461) frame 2: DBIx::Class::Row::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Row.pm line 117) frame 3: DBIx::Class::Row::update (/usr/share/squeezecenter/CPAN/DBIx/Class/Relationship/CascadeActions.pm line 30) frame 4: DBIx::Class::Relationship::CascadeActions::update (/usr/share/squeezecenter/CPAN/DBIx/Class/InflateColumn.pm line 222) frame 5: DBIx::Class::InflateColumn::update (/usr/share/perl5/Slim/Schema/DBI.pm line 35) frame 6: Slim::Schema::DBI::update (/usr/share/perl5/Slim/Utils/Progress.pm line 115) frame 7: Slim::Utils::Progress::total (/usr/share/perl5/Slim/Utils/Scanner.pm line 324) frame 8: Slim::Utils::Scanner::scanDirectory (/usr/share/perl5/Slim/Music/MusicFolderScan.pm line 79) frame 9: Slim::Music::MusicFolderScan::startScan (/usr/share/perl5/Slim/Music/Import.pm line 491) frame 10: Slim::Music::Import::runImporter (/usr/share/perl5/Slim/Music/Import.pm line 335) frame 11: Slim::Music::Import::runScan (/usr/sbin/squeezecenter-scanner line 213) frame 12: (eval) (/usr/sbin/squeezecenter-scanner line 207) frame 13: main::main (/usr/sbin/squeezecenter-scanner line 353)
[08-09-04 22:15:08.9759] Slim::Schema::throw_exception (236) Error: Can't update Slim::Schema::Progress=HASH(0xa3f68c0): row not found [08-09-04 22:15:08.9762] Slim::Schema::throw_exception (236) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema.pm line 236) frame 1: Slim::Schema::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Row.pm line 461) frame 2: DBIx::Class::Row::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Row.pm line 117) frame 3: DBIx::Class::Row::update (/usr/share/squeezecenter/CPAN/DBIx/Class/Relationship/CascadeActions.pm line 30) frame 4: DBIx::Class::Relationship::CascadeActions::update (/usr/share/squeezecenter/CPAN/DBIx/Class/InflateColumn.pm line 222) frame 5: DBIx::Class::InflateColumn::update (/usr/share/perl5/Slim/Schema/DBI.pm line 35) frame 6: Slim::Schema::DBI::update (/usr/share/perl5/Slim/Utils/Progress.pm line 164) frame 7: Slim::Utils::Progress::update (/usr/share/perl5/Slim/Utils/Scanner.pm line 331) frame 8: Slim::Utils::Scanner::scanDirectory (/usr/share/perl5/Slim/Music/MusicFolderScan.pm line 79) frame 9: Slim::Music::MusicFolderScan::startScan (/usr/share/perl5/Slim/Music/Import.pm line 491) frame 10: Slim::Music::Import::runImporter (/usr/share/perl5/Slim/Music/Import.pm line 335) frame 11: Slim::Music::Import::runScan (/usr/sbin/squeezecenter-scanner line 213) frame 12: (eval) (/usr/sbin/squeezecenter-scanner line 207) frame 13: main::main (/usr/sbin/squeezecenter-scanner line 353) [08-09-04 22:15:09.0149] Slim::Schema::newTrack (939) Warning: Use of uninitialized value in sprintf at /usr/share/perl5/Slim/Schema.pm line 940. [08-09-04 22:15:09.0257] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'INSERT INTO genre_track (genre, track) VALUES (?, ?)': DBD::mysql::st execute failed: Column 'genre' cannot be null at /usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. [08-09-04 22:15:09.0261] Slim::Schema::Storage::throw_exception (70) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 70) frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 2: DBIx::Class::Storage::DBI::_execute (/usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 791) frame 3: DBIx::Class::Storage::DBI::insert (/usr/share/squeezecenter/CPAN/DBIx/Class/Row.pm line 75) frame 4: DBIx::Class::Row::insert (/usr/share/squeezecenter/CPAN/DBIx/Class/ResultSet.pm line 1335) frame 5: DBIx::Class::ResultSet::create (/usr/share/squeezecenter/CPAN/DBIx/Class/ResultSet.pm line 1381) frame 6: DBIx::Class::ResultSet::find_or_create (/usr/share/perl5/Slim/Schema/Genre.pm line 83) frame 7: Slim::Schema::Genre::add (/usr/share/perl5/Slim/Schema.pm line 2104) frame 8: Slim::Schema::_postCheckAttributes (/usr/share/perl5/Slim/Schema.pm line 985) frame 9: Slim::Schema::newTrack (/usr/share/perl5/Slim/Utils/Scanner.pm line 339) frame 10: Slim::Utils::Scanner::scanDirectory (/usr/share/perl5/Slim/Music/MusicFolderScan.pm line 79) frame 11: Slim::Music::MusicFolderScan::startScan (/usr/share/perl5/Slim/Music/Import.pm line 491) frame 12: Slim::Music::Import::runImporter (/usr/share/perl5/Slim/Music/Import.pm line 335) frame 13: Slim::Music::Import::runScan (/usr/sbin/squeezecenter-scanner line 213) frame 14: (eval) (/usr/sbin/squeezecenter-scanner line 207) frame 15: main::main (/usr/sbin/squeezecenter-scanner line 353) [08-09-04 22:15:09.0266] main::main (219) Error: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO genre_track (genre, track) VALUES (?, ?)': DBD::mysql::st execute failed: Column 'genre' cannot be null at /usr/share/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771. ] [08-09-04 22:15:09.0269] main::main (220) Error: Skipping post-process & Not updating lastRescanTime! ================================================================================ After the above, here is database content: mysql> select * from tracks; +----+---------------------------------------------------------------------------------------------------+---------------+---------------+---------------+--------------+-------+----------+--------------+------------+----------+------------+--------------+------+---------+-------+-----------+---------+------------+------------+----------+-----------------+--------+------+------------+------+------+-------+--------+----------+--------+--------------------------------------+--------------------+-------------+-------------+ | id | url | title | titlesort | titlesearch | customsearch | album | tracknum | content_type | timestamp | filesize | audio_size | audio_offset | year | secs | cover | vbr_scale | bitrate | samplerate | samplesize | channels | block_alignment | endian | bpm | tagversion | drm | disc | audio | remote | lossless | lyrics | musicbrainz_id | musicmagic_mixable | replay_gain | replay_peak | +----+---------------------------------------------------------------------------------------------------+---------------+---------------+---------------+--------------+-------+----------+--------------+------------+----------+------------+--------------+------+---------+-------+-----------+---------+------------+------------+----------+-----------------+--------+------+------------+------+------+-------+--------+----------+--------+--------------------------------------+--------------------+-------------+-------------+ | 1 | file:///data/library/music/Andy_McKee/Art_of_Motion/Andy_McKee.Art_of_Motion.01.Art_Of_Motion.mp3 | Art of Motion | ART OF MOTION | ART OF MOTION | NULL | NULL | 1 | mp3 | 1220573955 | 5849107 | 5844663 | 4316 | 2005 | 205.636 | NULL | 98 | 227000 | 44100 | NULL | NULL | 1 | NULL | NULL | ID3v2.4.0 | 0 | NULL | 1 | 0 | 0 | NULL | e3c46818-1056-4d35-a482-bd15f9b6463f | NULL | NULL | NULL | +----+---------------------------------------------------------------------------------------------------+---------------+---------------+---------------+--------------+-------+----------+--------------+------------+----------+------------+--------------+------+---------+-------+-----------+---------+------------+------------+----------+-----------------+--------+------+------------+------+------+-------+--------+----------+--------+--------------------------------------+--------------------+-------------+-------------+ 1 row in set (0.00 sec) mysql> select * from tracks_persistent; +----+---------------------------------------------------------------------------------------------------+--------------------------------------+-------+------------+--------+-----------+------------+ | id | url | musicbrainz_id | track | added | rating | playCount | lastPlayed | +----+---------------------------------------------------------------------------------------------------+--------------------------------------+-------+------------+--------+-----------+------------+ | 4 | file:///data/library/music/Andy_McKee/Art_of_Motion/Andy_McKee.Art_of_Motion.01.Art_Of_Motion.mp3 | e3c46818-1056-4d35-a482-bd15f9b6463f | NULL | 1220573955 | NULL | NULL | NULL | +----+---------------------------------------------------------------------------------------------------+--------------------------------------+-------+------------+--------+-----------+------------+ 1 row in set (0.00 sec) -- morrisde ------------------------------------------------------------------------ morrisde's Profile: http://forums.slimdevices.com/member.php?userid=19766 View this thread: http://forums.slimdevices.com/showthread.php?t=51957 _______________________________________________ unix mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/unix
