Hi there, Not sure if this is the correct place to report bugs but I am having a problem scanning my tunes with version 6.5 and above. Even the latest nightly build.
I have run the scanner manually and it throws up the error below. Obviously the year is wrong "2002002" in my MP3's but I think the scanner should handle this better. The previous version did. Richard 2006-12-20 13:40:21.6411 newTrack(): Created track 'Hurt' (id: [1801]) 2006-12-20 13:40:21.6429 -- Track is a local track 2006-12-20 13:40:21.6469 SELECT me.id, me.name, me.namesort, me.namesearch, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable FROM genres me WHERE ( ( me.namesearch = ? ) ): 'COUNTRY' 2006-12-20 13:40:21.6562 SELECT me.genre, me.track FROM genre_track me WHERE ( ( me.genre = ? AND me.track = ? ) OR ( me.genre = ? AND me.track = ? ) ): '19', '1801', '19', '1801' 2006-12-20 13:40:21.6611 INSERT INTO genre_track (genre, track) VALUES (?, ?): '19', '1801' 2006-12-20 13:40:21.6650 -- Track has genre 'Country' 2006-12-20 13:40:21.6694 SELECT me.id, me.name, me.namesort, me.moodlogic_id, me.moodlogic_mixable, me.musicmagic_mixable, me.namesearch, me.musicbrainz_id FROM contributors me WHERE ( ( me.namesearch = ? ) ): 'JOHNNY CASH' 2006-12-20 13:40:21.6815 SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( ( me.contributor = ? AND me.role = ? AND me.track = ? ) OR ( me.contributor = ? AND me.role = ? AND me.track = ? ) ): '164', '1', '1801', '164', '1', '1801' 2006-12-20 13:40:21.6871 INSERT INTO contributor_track (contributor, role, track) VALUES (?, ?, ?): '164', '1', '1801' 2006-12-20 13:40:21.6916 -- Track has contributor 'Johnny Cash' of role 'ARTIST' 2006-12-20 13:40:21.6927 -- Track has 1 contributor(s) 2006-12-20 13:40:21.6941 -- Track primary contributor is 'Johnny Cash' (id: [164]) 2006-12-20 13:40:21.6954 -- Checking for discs 2006-12-20 13:40:21.7010 SELECT me.id, me.titlesort, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me WHERE ( ( ( me.id = ? ) ) ): '207' 2006-12-20 13:40:21.7059 -- Same album 'American IV (The Man Comes Around)' (id: [207]) than previous track 2006-12-20 13:40:21.7112 -- Updating album 'American IV (The Man Comes Around)' (id: [207]) with columns: 2006-12-20 13:40:21.7123 --- titlesort : AMERICAN IV THE MAN COMES AROUND 2006-12-20 13:40:21.7131 --- titlesearch : AMERICAN IV THE MAN COMES AROUND 2006-12-20 13:40:21.7138 --- year : 20022002 2006-12-20 13:40:21.7164 -- Track has album 'American IV (The Man Comes Around)' (id: [207]) 2006-12-20 13:40:21.7215 SELECT me.role, me.contributor, me.album FROM contributor_album me WHERE ( ( me.album = ? AND me.contributor = ? AND me.role = ? ) OR ( me.album = ? AND me.contributor = ? AND me.role = ? ) ): '207', '164', '1', '207', '164', '1' 2006-12-20 13:40:21.7268 -- Contributor 'Johnny Cash' (id: [164]) linked to album 'American IV (The Man Comes Around)' (id: [207]) with role: 'ARTIST' 2006-12-20 13:40:21.7296 UPDATE albums SET year = ? WHERE ( id = ? ): '20022002', '207' 2006-12-20 13:40:21.7342 UPDATE tracks SET album = ? WHERE ( id = ? ): '207', '1801' 2006-12-20 13:40:21.7416 SELECT me.id FROM years me WHERE ( ( me.id = ? ) ): '20022002' 2006-12-20 13:40:21.8309 INSERT INTO years (id) VALUES (?): '20022002' 2006-12-20 13:40:21.8337 ERROR: Error executing 'INSERT INTO years (id) VALUES (?)': DBD::mysql::st execute failed: Duplicate entry '65535' for key 1 at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. 2006-12-20 13:40:21.8348 ERROR: Backtrace follows: 2006-12-20 13:40:21.8360 Backtrace: frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 788) frame 2: DBIx::Class::Storage::DBI::insert (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Row.pm line 75) frame 3: DBIx::Class::Row::insert (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/PK/Auto.pm line 43) frame 4: DBIx::Class::PK::Auto::insert (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 1335) frame 5: DBIx::Class::ResultSet::create (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 1381) frame 6: DBIx::Class::ResultSet::find_or_create (/PerlApp/Slim/Schema.pm line 2163) frame 7: Slim::Schema::_postCheckAttributes (/PerlApp/Slim/Schema.pm line 807) frame 8: Slim::Schema::newTrack (/PerlApp/Slim/Utils/Scanner.pm line 322) frame 9: Slim::Utils::Scanner::scanDirectory (/PerlApp/Slim/Utils/Scanner.pm line 90) frame 10: Slim::Utils::Scanner::scanPathOrURL (scanner.pl line 168) frame 11: (eval) (scanner.pl line 168) frame 12: main::main (scanner.pl line 312) 2006-12-20 13:40:22.1187 ERROR: Scanner: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO years (id) VALUES (?)': DBD::mysql::st execute failed: Duplicate entry '65535' for key 1 at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. -- Dicko ------------------------------------------------------------------------ Dicko's Profile: http://forums.slimdevices.com/member.php?userid=9098 View this thread: http://forums.slimdevices.com/showthread.php?t=30780 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
