I too am running Debian Lenny and cannot scan my music collection. I wanted to evaluate SqueezeCenter before using it and the related hardware, but cannot even get as far as scanning in my music collection.
The log file output with some relevant debug information turned on is attached below. I had a more interesting output, but deleted it on re-installing SqueezeCenter (oops). It looks like the MYSQL queries for insertion are running correctly, however the resulting row id number is not being retrieved because it sometimes says uninitialized values are being used in the file: /usr/share/perl5/Slim/Schema.pm:940 In the resultingl log message created by that line of code, the value for $title->track looks correct, so I assume the problem is that $track->id has not been set. Any help for getting this running? Or is this a bug in SqueezeCenter? Details below on application versions, log file outputs, and mysql database content. ================================================================================ Some application versions, all installed via .deb files: Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Cfg-files/Unpacked/Failed-cfg/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad) ||/ Name Version Description +++-===================================-===================================-====================================================================================== ii libmysqlclient15-dev 5.0.51a-6 MySQL database development files ii libmysqlclient15off 5.0.51a-6 MySQL database client library ii perl 5.10.0-11 Larry Wall's Practical Extraction and Report Language ii squeezecenter 7.2~23028 Streaming Audio Server ================================================================================ I enabled some debugging options and captured the following output in the log file: [08-09-04 22:15:01.5889] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' [08-09-04 22:15:04.9352] Slim::Web::Settings::Server::Basic::handler (68) Initiating scan of type: wipecache [08-09-04 22:15:04.9361] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' [08-09-04 22:15:04.9397] Slim::Schema::Debug::query_start (26) 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.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.lossless, me.lyrics, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'clientplaylist://c8:a7:de:eb:71:d0' [08-09-04 22:15:04.9500] Slim::Schema::Debug::query_start (26) SELECT me.id, me.type, me.name, me.active, me.total, me.done, me.start, me.finish, me.info FROM progress me WHERE ( type = ? ): 'importer' [08-09-04 22:15:04.9538] Slim::Schema::Debug::query_start (26) DELETE FROM progress WHERE ( id = ? ): '9' [08-09-04 22:15:04.9657] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( ( me.name = ? ) ): 'isScanning' [08-09-04 22:15:04.9673] Slim::Schema::Debug::query_start (26) UPDATE metainformation SET value = ? WHERE ( name = ? ): '1', 'isScanning' [08-09-04 22:15:05.0154] Slim::Schema::Debug::query_start (26) SELECT me.name, me.value FROM metainformation me WHERE ( name = ? ): 'isScanning' [08-09-04 22:15:05.0548] Slim::Schema::Debug::query_start (26) 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.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.lossless, me.lyrics, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'clientplaylist://c8:a7:de:eb:71:d0' [08-09-04 22:15:05.0562] Slim::Schema::newTrack (846) New Playlist: [clientplaylist://c8:a7:de:eb:71:d0] [08-09-04 22:15:05.0569] Slim::Schema::_preCheckAttributes (1994) Report for clientplaylist://c8:a7:de:eb:71:d0: [08-09-04 22:15:05.0571] Slim::Schema::_preCheckAttributes (1995) * Attributes * [08-09-04 22:15:05.0573] Slim::Schema::_preCheckAttributes (1997) .. TITLE : Now Playing - SoftSqueeze [08-09-04 22:15:05.0576] Slim::Schema::_preCheckAttributes (1997) .. YEAR : 0 [08-09-04 22:15:05.0578] Slim::Schema::_preCheckAttributes (1997) .. CONTENT_TYPE : cpl [08-09-04 22:15:05.0580] Slim::Schema::_preCheckAttributes (1997) .. REMOTE : 0 [08-09-04 22:15:05.0583] Slim::Schema::_preCheckAttributes (1997) .. TITLESEARCH : NOW PLAYING SOFTSQUEEZE [08-09-04 22:15:05.0585] Slim::Schema::_preCheckAttributes (1997) .. TITLESORT : NOW PLAYING SOFTSQUEEZE [08-09-04 22:15:05.0587] Slim::Schema::_preCheckAttributes (1997) .. RATING : 0 [08-09-04 22:15:05.0589] Slim::Schema::_preCheckAttributes (2002) * Deferred Attributes * [08-09-04 22:15:05.0591] Slim::Schema::_preCheckAttributes (2011) .. COMMENT : ARRAY(0xabb86c0) [08-09-04 22:15:05.0594] Slim::Schema::newTrack (890) Creating Playlist with columns: [08-09-04 22:15:05.0596] Slim::Schema::newTrack (903) title : Now Playing - SoftSqueeze [08-09-04 22:15:05.0598] Slim::Schema::newTrack (903) content_type : cpl [08-09-04 22:15:05.0600] Slim::Schema::newTrack (903) remote : 0 [08-09-04 22:15:05.0603] Slim::Schema::newTrack (903) titlesearch : NOW PLAYING SOFTSQUEEZE [08-09-04 22:15:05.0605] Slim::Schema::newTrack (903) titlesort : NOW PLAYING SOFTSQUEEZE [08-09-04 22:15:05.0619] Slim::Schema::Debug::query_start (26) INSERT INTO tracks (content_type, remote, title, titlesearch, titlesort, url) VALUES (?, ?, ?, ?, ?, ?): 'cpl', '0', 'Now Playing - SoftSqueeze', 'NOW PLAYING SOFTSQUEEZE', 'NOW PLAYING SOFTSQUEEZE', 'clientplaylist://c8:a7:de:eb:71:d0' [08-09-04 22:15:05.1495] Slim::Utils::Misc::msg (1398) Warning: [22:15:05.1491] Use of uninitialized value in sprintf at /usr/share/perl5/Slim/Schema.pm line 940. [08-09-04 22:15:05.1498] Slim::Schema::newTrack (939) Created track 'Now Playing - SoftSqueeze' (id: [0]) [08-09-04 22:15:05.1660] Slim::Schema::Debug::query_start (26) DELETE FROM playlist_track WHERE ( playlist IS NULL ): ==> scanner.log <== [08-09-04 22:15:08.7046] Slim::Schema::throw_exception (236) Error: Can't update Slim::Schema::Progress=HASH(0xa3f19b8): row not found [08-09-04 22:15:08.7051] Slim::Schema::throw_exception (236) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema.pm line 236) frame 1: Slim::Schema::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Row.pm line 461) frame 2: DBIx::Class::Row::throw_exception (/usr/share/squeezecenter/CPAN/DBIx/Class/Row.pm line 117) frame 3: DBIx::Class::Row::update (/usr/share/squeezecenter/CPAN/DBIx/Class/Relationship/CascadeActions.pm line 30) frame 4: DBIx::Class::Relationship::CascadeActions::update (/usr/share/squeezecenter/CPAN/DBIx/Class/InflateColumn.pm line 222) frame 5: DBIx::Class::InflateColumn::update (/usr/share/perl5/Slim/Schema/DBI.pm line 35) frame 6: Slim::Schema::DBI::update (/usr/share/perl5/Slim/Utils/Progress.pm line 195) frame 7: Slim::Utils::Progress::final (/usr/share/perl5/Slim/Schema.pm line 392) frame 8: Slim::Schema::optimizeDB (/usr/share/perl5/Slim/Schema.pm line 347) frame 9: Slim::Schema::__ANON__ (/usr/share/squeezecenter/CPAN/DBIx/Class/Schema.pm line 584) frame 10: (eval) (/usr/share/squeezecenter/CPAN/DBIx/Class/Schema.pm line 572) frame 11: DBIx::Class::Schema::txn_do (/usr/share/perl5/Slim/Schema.pm line 348) frame 12: (eval) (/usr/share/perl5/Slim/Schema.pm line 339) frame 13: Slim::Schema::wipeDB (/usr/share/perl5/Slim/Schema.pm line 1469) frame 14: Slim::Schema::wipeAllData (/usr/sbin/squeezecenter-scanner line 172) frame 15: main::__ANON__ (/usr/share/squeezecenter/CPAN/DBIx/Class/Schema.pm line 584) frame 16: (eval) (/usr/share/squeezecenter/CPAN/DBIx/Class/Schema.pm line 572) frame 17: DBIx::Class::Schema::txn_do (/usr/sbin/squeezecenter-scanner line 172) frame 18: (eval) (/usr/sbin/squeezecenter-scanner line 172) frame 19: main::main (/usr/sbin/squeezecenter-scanner line 353) [08-09-04 22:15:08.8244] Slim::Utils::Scanner::__ANON__ (135) Warning: Use of uninitialized value $_ in concatenation (.) or string at /usr/share/perl5/Slim/Utils/Scanner.pm line 135. [08-09-04 22:15:08.8248] Slim::Utils::Misc::msg (1398) Warning: [22:15:08.8246] ERROR: [08-09-04 22:15:08.9742] Slim::Schema::throw_exception (236) Error: Can't update Slim::Schema::Progress=HASH(0xa3f68c0): row not found [08-09-04 22:15:08.9746] Slim::Schema::throw_exception (236) Backtrace: (continued in next post) -- morrisde ------------------------------------------------------------------------ morrisde's Profile: http://forums.slimdevices.com/member.php?userid=19766 View this thread: http://forums.slimdevices.com/showthread.php?t=51957 _______________________________________________ unix mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/unix
