can anyone help with a sql error that is thrown when scanning...? I'm currently running 6.5.5....I upgraded to see if it fixed this problem which started in 6.5.4 The scan populates the DB with most of the files...but no artwork...it appears that is has something to do with compiling the "various Artists" info. The tail of the log file is below:
2007-12-18 15:01:10.8496 -- VA postcheck for album 'Live at Budokan' (id: [57]) 2007-12-18 15:01:12.9843 --- Album has composite artist '58' 2007-12-18 15:01:12.9856 --- Album has composite artist '58' 2007-12-18 15:01:12.9868 --- Album has composite artist '58' 2007-12-18 15:01:13.9881 --- Album has composite artist '58' 2007-12-18 15:01:13.9893 --- Album has composite artist '58' 2007-12-18 15:01:13.9906 --- Album has composite artist '58' 2007-12-18 15:01:13.9918 --- Album has composite artist '58' 2007-12-18 15:01:13.9930 --- Album has composite artist '58' 2007-12-18 15:01:13.9942 --- Album has composite artist '58' 2007-12-18 15:01:13.9953 --- Album has composite artist '58' 2007-12-18 15:01:13.9960 -- VA postcheck for album 'Chicago Transit Authority' (id: [58]) 2007-12-18 15:01:13.0905 ERROR: Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_768_0.MYI' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. 2007-12-18 15:01:13.0907 ERROR: Backtrace follows: 2007-12-18 15:01:13.0910 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 826) frame 2: DBIx::Class::Storage::DBI::_select (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79) frame 3: DBIx::Class::Storage::DBI::Cursor::next (C:\Program Files\SlimServer\server\CPAN/DBIx/Class/ResultSet.pm line 701) frame 4: DBIx::Class::ResultSet::next (/<C:\Program Files\SlimServer\server\scanner.exe>Slim/Schema.pm line 1212) frame 5: Slim::Schema::mergeVariousArtistsAlbums (/<C:\Program Files\SlimServer\server\scanner.exe>Slim/Music/Import.pm line 312) frame 6: Slim::Music::Import::runScanPostProcessing (scanner.pl line 195) frame 7: main::__ANON__ (/<C:\Program Files\SlimServer\server\scanner.exe>DBIx/Class/Schema.pm line 584) frame 8: (eval) (/<C:\Program Files\SlimServer\server\scanner.exe>DBIx/Class/Schema.pm line 572) frame 9: DBIx::Class::Schema::txn_do (scanner.pl line 195) frame 10: (eval) (scanner.pl line 195) frame 11: main::main (scanner.pl line 314) 2007-12-18 15:01:13.2256 ERROR: Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.thumb, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak, contributorTracks.role, contributorTracks.contributor, contributorTracks.track FROM tracks me LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( contributorTracks.role = ? ) AND ( me.album = ? ) ) ) ORDER BY contributorTracks.track': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_768_0.MYI' (Errcode: 13) at C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. 2007-12-18 15:01:13.2260 ERROR: Backtrace follows: 2007-12-18 15:01:13.2262 Backtrace: frame 0: Slim::Schema::throw_exception (/<C:\Program Files\SlimServer\server\scanner.exe>DBIx/Class/Schema.pm line 606) frame 1: DBIx::Class::Schema::txn_do (scanner.pl line 195) frame 2: (eval) (scanner.pl line 195) frame 3: main::main (scanner.pl line 314) 2007-12-18 15:01:13.3173 forceCommit: syncing to the database. -- theStimmer ------------------------------------------------------------------------ theStimmer's Profile: http://forums.slimdevices.com/member.php?userid=7136 View this thread: http://forums.slimdevices.com/showthread.php?t=41170 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss
