PDA

View Full Version : Scan problem



jandoedel99
2008-09-24, 12:45
When i scan my mp3's the scan stops after a short period of time. The time is still counting.
I have complete delete the program + delete directory's after new install and first scan this is my log: "

[08-09-24 21:13:40.3721] Slim::Schema::Storage::throw_exception (70) Error: Error executing 'SELECT me.id, me.titlesort, me.contributor, 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 LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_1168_0.MYI' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
[08-09-24 21:13:40.3734] Slim::Schema::Storage::throw_exception (70) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema/Storage.pm line 70)
frame 1: Slim::Schema::Storage::throw_exception (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 773)
frame 2: DBIx::Class::Storage::DBI::_execute (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 826)
frame 3: DBIx::Class::Storage::DBI::_select (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 852)
frame 4: DBIx::Class::Storage::DBI::select_single (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/ResultSet.pm line 511)
frame 5: DBIx::Class::ResultSet::single (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 2352)
frame 6: Slim::Schema::_postCheckAttributes (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 985)
frame 7: Slim::Schema::newTrack (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/Scanner.pm line 339)
frame 8: Slim::Utils::Scanner::scanDirectory (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/MusicFolderScan.pm line 79)
frame 9: Slim::Music::MusicFolderScan::startScan (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 485)
frame 10: Slim::Music::Import::runImporter (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 329)
frame 11: Slim::Music::Import::runScan (scanner.pl line 222)
frame 12: (eval) (scanner.pl line 216)
frame 13: main::main (scanner.pl line 362)

[08-09-24 21:13:40.3998] main::main (228) Error: Failed when running main scan: [Carp::Clan::__ANON__(): Error executing 'SELECT me.id, me.titlesort, me.contributor, 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 LEFT JOIN tracks tracks ON ( tracks.album = me.id ) WHERE ( me.disc IS NULL AND me.discc IS NULL AND me.title = ? AND tracks.url LIKE ? ) GROUP BY me.id': DBD::mysql::st execute failed: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_1168_0.MYI' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.
]
[08-09-24 21:13:40.4006] main::main (229) Error: Skipping post-process & Not updating lastRescanTime!

There is a line:Can't create/write to file 'C:\WINDOWS\TEMP\#sql_1168_0.MYI' (Errcode: 17) at /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm line 771.

How to solve this?
I use windows XP and the last nightly 7.3-2327
If i use a prev. version i got the same error.

Secret Squirrel
2008-09-24, 12:53
Sounds like your antivirus is causing you the trouble. There are MANY posts & solutions in the forums, but it comes down to either ignoring *.MY* files in your antivirus or just disabling your antivirus.

HTH,

SS

jandoedel99
2008-09-24, 13:38
I have found that pctools spyware doctor give the problem.
But now I have after the scanning no artist info.

Thanks so far

Secret Squirrel
2008-09-25, 05:09
Glad to hear that you made some progress. Tagging is am art. You might first check out the wiki as there's lots of information there: http://wiki.slimdevices.com/index.php/Beginners_Guide_To_Tagging I have followed those guidelines using MP3Tag with great results. I think the one thing that made the most difference was removing all the tags except for ID3.

I hope this will keep you on trail!

SS

jandoedel99
2008-09-26, 13:55
I have complete retag my mp3's and delete old tags. Now is artist displaying correct.

Thanks.