PDA

View Full Version : Problem scanning my tunes with latest 6.5.1



Dicko
2006-12-20, 06:51
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.