Music library won't complete scan, can't play any music from Squeezebox...

[Tim Power]

So, I've been unable to scan my Squeezebox music libray for quite some time, & am unable to figure out why. Now when I use my Squeezebox, I press right to look at the artists & it just swipes back to Artists. Same with Albums etc.

I keep getting this log error when Squeezecenter tries to scan my music collection. Anyone know the problem? I've reset & rebotted numerous times, nothing seems to be working. I haven't changed any settings either, one day it just stopped working. Any help would be appreciated!

[09-06-06 23:28:52.4531] main::main (219) 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_c9c_0.MYD' (Errcode: 17) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
]
[09-06-06 23:28:52.4537] main::main (220) Error: Skipping post-process & Not updating lastRescanTime!
[09-06-07 00:28:13.7954] 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_c9c_0.MYD' (Errcode: 17) at C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.
[09-06-07 00:28:13.8027] Slim::Schema::Storage::throw_exception (70) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (C:/PROGRA~1/SQUEEZ~1/server/Slim/Schema/Storage.pm line 70)
frame 1: Slim::Schema::Storage::throw_exception (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 2: DBIx::Class::Storage:BI::_execute (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 826)
frame 3: DBIx::Class::Storage:BI::_select (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 852)
frame 4: DBIx::Class::Storage:BI::select_single (C:\PROGRA~1\SQUEEZ~1\server\CPAN/DBIx/Class/ResultSet.pm line 509)
frame 5: DBIx::Class::ResultSet::single (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Schema.pm line 2345)
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/Schema.pm line 1147)
frame 8: Slim::Schema::updateOrCreate (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/Scanner.pm line 339)
frame 9: Slim::Utils::Scanner::scanDirectory (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/MusicFolderScan.pm line 79)
frame 10: Slim::Music::MusicFolderScan::startScan (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 491)
frame 11: Slim::Music::Import::runImporter (/<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Music/Import.pm line 335)
frame 12: Slim::Music::Import::runScan (scanner.pl line 213)
frame 13: (eval) (scanner.pl line 207)
frame 14: main::main (scanner.pl line 353)

[kdf]

On 7-Jun-09, at 8:45 PM, Tim Power wrote:
>
> me.titlesort, me.disc': DBD::mysql::st execute failed: Can't
> create/write to file 'C:\Windows\TEMP\#sql_1af4_0.MYD' (Errcode: 17)
> at
> /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>DBIx/Class/Storage/DBI.pm
> line
> 771.

This error is caused by a conflict with anti-virus software.
Configure your av scanner to ignore *.MYI and *.MYD files and the
problem should go away.

-kdf

[Teus de Jong]

If you're using McAfee, look here for a solution:

http://forums.slimdevices.com/showthread.php?t=56785

Teus