Hi, installed Squeezecenter around christmas and it worked quite well, though didn't use it for a couple of weeks but then when I should use it again it didn't work so upgraded about a week ago to the latest. It worked but couldnt load album art. Tried just to grab the latest from tonight and still have the same problem. It works just fine as long as it not is about to show album art, if that happens it just hangs.I dont get much information in the log file but if I run slimserver.pl from command-line I get several errors. I run this on a FreeBSD 6.2-RELEASE machine.
The first error I see is this one, don't know if that has anything to fo with it though since I get it when I do a rescan of my music. --- The following CPAN modules were found but cannot work with SqueezeCenter: Compress::Zlib (loaded 1.41 but missing object file, need 1.41) To fix this problem you have several options: 1. Install the latest version of the module(s) using CPAN: sudo cpan Some::Module 2. Update the module's package using apt-get, yum, etc. 3. Run the .tar.gz version of SqueezeCenter which includes all required CPAN modules. --- What is pussling is that I am using the squeezecenter distribution with all CPAN included, not the noCPAN distribution. Though I have tried that one and still get the same error. And if a launch CPAN and do "i /Zlib/" it says "Module = Compress::Zlib (PMQS/Compress-Zlib-2.008.tar.gz)" so I'm above 1.41.... Anyway, once I start to brows artist viewing album art I get the following errors. Something wrong with my database? I use an external MySQL server. [08-02-17 13:53:14.2319] Slim::Schema::Storage::throw_exception (67) Error: Error executing 'DELETE FROM tracks WHERE ( id = ? )': DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails (`slimserver`.`comments`, CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`)) at /usr/local/squeezecenter-7.0-17600/CPAN/DBIx/Class/Storage/DBI.pm line 771. [08-02-17 13:53:14.2327] Slim::Schema::Storage::throw_exception (67) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/local/squeezecenter-7.0-17600/Slim/Schema/Storage.pm line 67) frame 1: Slim::Schema::Storage::throw_exception (/usr/local/squeezecenter-7.0-17600/CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 2: DBIx::Class::Storage::DBI::_execute (/usr/local/squeezecenter-7.0-17600/CPAN/DBIx/Class/Storage/DBI.pm line 801) frame 3: DBIx::Class::Storage::DBI::delete (/usr/local/squeezecenter-7.0-17600/CPAN/DBIx/Class/Row.pm line 154) frame 4: DBIx::Class::Row::delete (/usr/local/squeezecenter-7.0-17600/CPAN/DBIx/Class/Relationship/CascadeActions.pm line 14) frame 5: DBIx::Class::Relationship::CascadeActions::delete (/usr/local/squeezecenter-7.0-17600/Slim/Schema.pm line 1579) frame 6: Slim::Schema::_hasChanged (/usr/local/squeezecenter-7.0-17600/Slim/Schema.pm line 1490) frame 7: Slim::Schema::_checkValidity (/usr/local/squeezecenter-7.0-17600/Slim/Schema.pm line 538) frame 8: Slim::Schema::find (/usr/local/squeezecenter-7.0-17600/Slim/Web/Graphics.pm line 194) frame 9: Slim::Web::Graphics::processCoverArtRequest (/usr/local/squeezecenter-7.0-17600/Slim/Web/HTTP.pm line 1068) frame 10: Slim::Web::HTTP::generateHTTPResponse (/usr/local/squeezecenter-7.0-17600/Slim/Web/HTTP.pm line 948) frame 11: Slim::Web::HTTP::processURL (/usr/local/squeezecenter-7.0-17600/Slim/Web/HTTP.pm line 755) frame 12: Slim::Web::HTTP::processHTTP (/usr/local/squeezecenter-7.0-17600/Slim/Networking/Select.pm line 243) frame 13: (eval) (/usr/local/squeezecenter-7.0-17600/Slim/Networking/Select.pm line 243) frame 14: Slim::Networking::Select::select (./slimserver.pl line 503) frame 15: main::idle (./slimserver.pl line 453) frame 16: main::main (./slimserver.pl line 1005) [08-02-17 13:53:14.2344] Slim::Networking::Select::select (245) Error: Select task failed: Carp::Clan::__ANON__(): Error executing 'DELETE FROM tracks WHERE ( id = ? )': DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails (`slimserver`.`comments`, CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`)) at /usr/local/squeezecenter-7.0-17600/CPAN/DBIx/Class/Storage/DBI.pm line 771. [08-02-17 13:53:14.2458] Slim::Schema::Storage::throw_exception (67) Error: Error executing 'DELETE FROM tracks WHERE ( id = ? )': DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails (`slimserver`.`comments`, CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`)) at /usr/local/squeezecenter-7.0-17600/CPAN/DBIx/Class/Storage/DBI.pm line 771. [08-02-17 13:53:14.2465] Slim::Schema::Storage::throw_exception (67) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (/usr/local/squeezecenter-7.0-17600/Slim/Schema/Storage.pm line 67) frame 1: Slim::Schema::Storage::throw_exception (/usr/local/squeezecenter-7.0-17600/CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 2: DBIx::Class::Storage::DBI::_execute (/usr/local/squeezecenter-7.0-17600/CPAN/DBIx/Class/Storage/DBI.pm line 801) frame 3: DBIx::Class::Storage::DBI::delete (/usr/local/squeezecenter-7.0-17600/CPAN/DBIx/Class/Row.pm line 154) frame 4: DBIx::Class::Row::delete (/usr/local/squeezecenter-7.0-17600/CPAN/DBIx/Class/Relationship/CascadeActions.pm line 14) frame 5: DBIx::Class::Relationship::CascadeActions::delete (/usr/local/squeezecenter-7.0-17600/Slim/Schema.pm line 1579) frame 6: Slim::Schema::_hasChanged (/usr/local/squeezecenter-7.0-17600/Slim/Schema.pm line 1490) frame 7: Slim::Schema::_checkValidity (/usr/local/squeezecenter-7.0-17600/Slim/Schema.pm line 538) frame 8: Slim::Schema::find (/usr/local/squeezecenter-7.0-17600/Slim/Web/Graphics.pm line 194) frame 9: Slim::Web::Graphics::processCoverArtRequest (/usr/local/squeezecenter-7.0-17600/Slim/Web/HTTP.pm line 1068) frame 10: Slim::Web::HTTP::generateHTTPResponse (/usr/local/squeezecenter-7.0-17600/Slim/Web/HTTP.pm line 948) frame 11: Slim::Web::HTTP::processURL (/usr/local/squeezecenter-7.0-17600/Slim/Web/HTTP.pm line 755) frame 12: Slim::Web::HTTP::processHTTP (/usr/local/squeezecenter-7.0-17600/Slim/Networking/Select.pm line 243) frame 13: (eval) (/usr/local/squeezecenter-7.0-17600/Slim/Networking/Select.pm line 243) frame 14: Slim::Networking::Select::select (./slimserver.pl line 503) frame 15: main::idle (./slimserver.pl line 453) frame 16: main::main (./slimserver.pl line 1005) [08-02-17 13:53:14.2482] Slim::Networking::Select::select (245) Error: Select task failed: Carp::Clan::__ANON__(): Error executing 'DELETE FROM tracks WHERE ( id = ? )': DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails (`slimserver`.`comments`, CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`)) at /usr/local/squeezecenter-7.0-17600/CPAN/DBIx/Class/Storage/DBI.pm line 771. /Kalle _______________________________________________ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/beta
