Steve Bernard, Jr;336386 Wrote:
> I've set up a new server on an MSI Wind barebones PC, and the only
> version of Debian I could get to work with the NIC was Debian Testing
> ("Lenny"). I've installed SqueezeCenter using the apt repository, and
> I've downloaded the latest nightly myself, and I've used the built-in
> MySQL as well as pointed it at an existing MySQL database, and no
> matter what I do, I can't scan my library. I keep getting this
> output:
>
> [08-09-03 19:55:52.4968] Slim::Schema::throw_exception (236) Error:
> Can't update Slim::Schema::Progress=HASH(0xaecfc08): row not found
> [08-09-03 19:55:52.4982] Slim::Schema::throw_exception (236)
> Backtrace:
>
> frame 0: Slim::Utils::Log::logBacktrace
> (/opt/squeezecenter/Slim/Schema.pm line 236)
> frame 1: Slim::Schema::throw_exception
> (/opt/squeezecenter/CPAN/DBIx/Class/Row.pm line 461)
> frame 2: DBIx::Class::Row::throw_exception
> (/opt/squeezecenter/CPAN/DBIx/Class/Row.pm line 117)
> frame 3: DBIx::Class::Row::update
> (/opt/squeezecenter/CPAN/DBIx/Class/Relationship/CascadeActions.pm
> line 30)
> frame 4: DBIx::Class::Relationship::CascadeActions::update
> (/opt/squeezecenter/CPAN/DBIx/Class/InflateColumn.pm line 222)
> frame 5: DBIx::Class::InflateColumn::update
> (/opt/squeezecenter/Slim/Schema/DBI.pm line 35)
> frame 6: Slim::Schema::DBI::update
> (/opt/squeezecenter/Slim/Utils/Progress.pm line 195)
> frame 7: Slim::Utils::Progress::final
> (/opt/squeezecenter/Slim/Schema.pm line 392)
> frame 8: Slim::Schema::optimizeDB
> (/opt/squeezecenter/Slim/Schema.pm line 347)
> frame 9: Slim::Schema::__ANON__
> (/opt/squeezecenter/CPAN/DBIx/Class/Schema.pm line 584)
> frame 10: (eval) (/opt/squeezecenter/CPAN/DBIx/Class/Schema.pm line
> 572)
> frame 11: DBIx::Class::Schema::txn_do
> (/opt/squeezecenter/Slim/Schema.pm line 348)
> frame 12: (eval) (/opt/squeezecenter/Slim/Schema.pm line 339)
> frame 13: Slim::Schema::wipeDB (/opt/squeezecenter/Slim/Schema.pm
> line 1469)
> frame 14: Slim::Schema::wipeAllData (/opt/squeezecenter/scanner.pl
> line 172)
> frame 15: main::__ANON__
> (/opt/squeezecenter/CPAN/DBIx/Class/Schema.pm line 584)
> frame 16: (eval) (/opt/squeezecenter/CPAN/DBIx/Class/Schema.pm line
> 572)
> frame 17: DBIx::Class::Schema::txn_do
> (/opt/squeezecenter/scanner.pl line 172)
> frame 18: (eval) (/opt/squeezecenter/scanner.pl line 172)
> frame 19: main::main (/opt/squeezecenter/scanner.pl line 353)
>
> [08-09-03 19:56:07.6705] Slim::Schema::throw_exception (236) Error:
> Can't update Slim::Schema::Progress=HASH(0xaedfbf0): row not found
> [08-09-03 19:56:07.6724] Slim::Schema::throw_exception (236)
> Backtrace:
>
> frame 0: Slim::Utils::Log::logBacktrace
> (/opt/squeezecenter/Slim/Schema.pm line 236)
> frame 1: Slim::Schema::throw_exception
> (/opt/squeezecenter/CPAN/DBIx/Class/Row.pm line 461)
> frame 2: DBIx::Class::Row::throw_exception
> (/opt/squeezecenter/CPAN/DBIx/Class/Row.pm line 117)
> frame 3: DBIx::Class::Row::update
> (/opt/squeezecenter/CPAN/DBIx/Class/Relationship/CascadeActions.pm
> line 30)
> frame 4: DBIx::Class::Relationship::CascadeActions::update
> (/opt/squeezecenter/CPAN/DBIx/Class/InflateColumn.pm line 222)
> frame 5: DBIx::Class::InflateColumn::update
> (/opt/squeezecenter/Slim/Schema/DBI.pm line 35)
> frame 6: Slim::Schema::DBI::update
> (/opt/squeezecenter/Slim/Utils/Progress.pm line 115)
> frame 7: Slim::Utils::Progress::total
> (/opt/squeezecenter/Slim/Utils/Scanner.pm line 324)
> frame 8: Slim::Utils::Scanner::scanDirectory
> (/opt/squeezecenter/Slim/Music/MusicFolderScan.pm line 79)
> frame 9: Slim::Music::MusicFolderScan::startScan
> (/opt/squeezecenter/Slim/Music/Import.pm line 491)
> frame 10: Slim::Music::Import::runImporter
> (/opt/squeezecenter/Slim/Music/Import.pm line 335)
> frame 11: Slim::Music::Import::runScan
> (/opt/squeezecenter/scanner.pl line 213)
> frame 12: (eval) (/opt/squeezecenter/scanner.pl line 207)
> frame 13: main::main (/opt/squeezecenter/scanner.pl line 353)
>
> [08-09-03 19:56:07.6766] Slim::Schema::throw_exception (236) Error:
> Can't update Slim::Schema::Progress=HASH(0xaedfbf0): row not found
> [08-09-03 19:56:07.6783] Slim::Schema::throw_exception (236)
> Backtrace:
>
> frame 0: Slim::Utils::Log::logBacktrace
> (/opt/squeezecenter/Slim/Schema.pm line 236)
> frame 1: Slim::Schema::throw_exception
> (/opt/squeezecenter/CPAN/DBIx/Class/Row.pm line 461)
> frame 2: DBIx::Class::Row::throw_exception
> (/opt/squeezecenter/CPAN/DBIx/Class/Row.pm line 117)
> frame 3: DBIx::Class::Row::update
> (/opt/squeezecenter/CPAN/DBIx/Class/Relationship/CascadeActions.pm
> line 30)
> frame 4: DBIx::Class::Relationship::CascadeActions::update
> (/opt/squeezecenter/CPAN/DBIx/Class/InflateColumn.pm line 222)
> frame 5: DBIx::Class::InflateColumn::update
> (/opt/squeezecenter/Slim/Schema/DBI.pm line 35)
> frame 6: Slim::Schema::DBI::update
> (/opt/squeezecenter/Slim/Utils/Progress.pm line 164)
> frame 7: Slim::Utils::Progress::update
> (/opt/squeezecenter/Slim/Utils/Scanner.pm line 331)
> frame 8: Slim::Utils::Scanner::scanDirectory
> (/opt/squeezecenter/Slim/Music/MusicFolderScan.pm line 79)
> frame 9: Slim::Music::MusicFolderScan::startScan
> (/opt/squeezecenter/Slim/Music/Import.pm line 491)
> frame 10: Slim::Music::Import::runImporter
> (/opt/squeezecenter/Slim/Music/Import.pm line 335)
> frame 11: Slim::Music::Import::runScan
> (/opt/squeezecenter/scanner.pl line 213)
> frame 12: (eval) (/opt/squeezecenter/scanner.pl line 207)
> frame 13: main::main (/opt/squeezecenter/scanner.pl line 353)
>
> [08-09-03 19:56:07.7724] Slim::Schema::newTrack (939) Warning: Use of
> uninitialized value in sprintf at /opt/squeezecenter/Slim/Schema.pm
> line 940.
> [08-09-03 19:56:07.7948] Slim::Schema::Storage::throw_exception (70)
> Error: Error executing 'INSERT INTO genre_track (genre, track) VALUES
> (?, ?)': DBD::mysql::st execute failed: Column 'genre' cannot be null
> at /opt/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771.
> [08-09-03 19:56:07.7966] Slim::Schema::Storage::throw_exception (70)
> Backtrace:
>
> frame 0: Slim::Utils::Log::logBacktrace
> (/opt/squeezecenter/Slim/Schema/Storage.pm line 70)
> frame 1: Slim::Schema::Storage::throw_exception
> (/opt/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 773)
> frame 2: DBIx::Class::Storage::DBI::_execute
> (/opt/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 788)
> frame 3: DBIx::Class::Storage::DBI::insert
> (/opt/squeezecenter/CPAN/DBIx/Class/Row.pm line 75)
> frame 4: DBIx::Class::Row::insert
> (/opt/squeezecenter/CPAN/DBIx/Class/ResultSet.pm line 1335)
> frame 5: DBIx::Class::ResultSet::create
> (/opt/squeezecenter/CPAN/DBIx/Class/ResultSet.pm line 1381)
> frame 6: DBIx::Class::ResultSet::find_or_create
> (/opt/squeezecenter/Slim/Schema/Genre.pm line 83)
> frame 7: Slim::Schema::Genre::add
> (/opt/squeezecenter/Slim/Schema.pm line 2104)
> frame 8: Slim::Schema::_postCheckAttributes
> (/opt/squeezecenter/Slim/Schema.pm line 985)
> frame 9: Slim::Schema::newTrack
> (/opt/squeezecenter/Slim/Utils/Scanner.pm line 339)
> frame 10: Slim::Utils::Scanner::scanDirectory
> (/opt/squeezecenter/Slim/Music/MusicFolderScan.pm line 79)
> frame 11: Slim::Music::MusicFolderScan::startScan
> (/opt/squeezecenter/Slim/Music/Import.pm line 491)
> frame 12: Slim::Music::Import::runImporter
> (/opt/squeezecenter/Slim/Music/Import.pm line 335)
> frame 13: Slim::Music::Import::runScan
> (/opt/squeezecenter/scanner.pl line 213)
> frame 14: (eval) (/opt/squeezecenter/scanner.pl line 207)
> frame 15: main::main (/opt/squeezecenter/scanner.pl line 353)
>
> [08-09-03 19:56:07.8060] main::main (219) Error: Failed when running
> main scan: [Carp::Clan::__ANON__(): Error executing 'INSERT INTO
> genre_track (genre, track) VALUES (?, ?)': DBD::mysql::st execute
> failed: Column 'genre' cannot be null at
> /opt/squeezecenter/CPAN/DBIx/Class/Storage/DBI.pm line 771.
> ]
> [08-09-03 19:56:07.8072] main::main (220) Error: Skipping post-process
> & Not updating lastRescanTime!
> [08-09-03 19:56:07.8453] Carp::carp (46) Warning: cannot remove
> directory for /opt/squeezecenter/Cache/templates/opt/squeezecenter:
> Directory not empty at /opt/squeezecenter/scanner.pl line 244
> [08-09-03 19:56:07.8474] Carp::carp (46) Warning: cannot remove
> directory for /opt/squeezecenter/Cache/templates/opt: Directory not
> empty at /opt/squeezecenter/scanner.pl line 244
> [08-09-03 19:56:07.8493] Carp::carp (46) Warning: cannot remove
> directory for /opt/squeezecenter/Cache/templates: Directory not empty
> at /opt/squeezecenter/scanner.pl line 244
>
> Can anyone decipher what might be the problem? This is the entire
> output of "scanner.pl -wipe"
>
> Any help would be much appreciated.
>
> -Steve Bernard
Hi, i have had som epeoblem running squeezecenter debian package my
self. I have two cmputers and one of them refused to run squeezecenter
because of some sql problems.
Someone told me to try out the tar ball instad of the debian package
and that solved my problem.
It's quite easy just extract the tar ball and run ./slimserver -d and
you should be up.
--
goxboxlive
------------------------------------------------------------------------
goxboxlive's Profile: http://forums.slimdevices.com/member.php?userid=19654
View this thread: http://forums.slimdevices.com/showthread.php?t=51957
_______________________________________________
unix mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/unix
