Hi, Running SC7 16330, Win XP.
I did a bit of a perverse thing and searched for "Various Artists". Indeed, the search comes up with the 1 Artist as above, however clicking on it hangs Slimserver. Or rather, nothing appears and the page continues to load. I can click on something else and continue. Here is the log extract; please let me know if this is worth filing, or if it's just me. [08-01-17 20:54:00.0282] Slim::Networking::Select::select (245) Error: Select task failed: Carp::Clan::__ANON__(): Error executing 'SELECT COUNT( DISTINCT( album.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( album.compilation = ? ) AND ( me.role = ? ) ) )': DBD::mysql::st execute failed: Unknown column 'me.role' in 'where clause' at C:\Program Files\Media\SqueezeCenter\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. [08-01-17 20:58:32.2173] Slim::Schema::Storage::throw_exception (67) Error: Error executing 'SELECT COUNT( DISTINCT( album.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( album.compilation = ? ) AND ( me.role = ? ) ) )': DBD::mysql::st execute failed: Unknown column 'me.role' in 'where clause' at C:\Program Files\Media\SqueezeCenter\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. [08-01-17 20:58:32.2181] Slim::Schema::Storage::throw_exception (67) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (C:/Program Files/Media/SqueezeCenter/server/Slim/Schema/Storage.pm line 67) frame 1: Slim::Schema::Storage::throw_exception (C:\Program Files\Media\SqueezeCenter\server\CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 2: DBIx::Class::Storage::DBI::_execute (C:\Program Files\Media\SqueezeCenter\server\CPAN/DBIx/Class/Storage/DBI.pm line 826) frame 3: DBIx::Class::Storage::DBI::_select (C:\Program Files\Media\SqueezeCenter\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79) frame 4: DBIx::Class::Storage::DBI::Cursor::next (C:\Program Files\Media\SqueezeCenter\server\CPAN/DBIx/Class/ResultSet.pm line 888) frame 5: DBIx::Class::ResultSet::_count (C:\Program Files\Media\SqueezeCenter\server\CPAN/DBIx/Class/ResultSet.pm line 849) frame 6: DBIx::Class::ResultSet::count (/<C:\Program Files\Media\SqueezeCenter\server\squeezecenter.exe>Slim/Web/Pages/BrowseDB.pm line 265) frame 7: Slim::Web::Pages::BrowseDB::browsedb (/<C:\Program Files\Media\SqueezeCenter\server\squeezecenter.exe>Slim/Web/HTTP.pm line 1071) frame 8: Slim::Web::HTTP::generateHTTPResponse (/<C:\Program Files\Media\SqueezeCenter\server\squeezecenter.exe>Slim/Web/HTTP.pm line 938) frame 9: Slim::Web::HTTP::processURL (/<C:\Program Files\Media\SqueezeCenter\server\squeezecenter.exe>Slim/Web/HTTP.pm line 750) frame 10: Slim::Web::HTTP::processHTTP (/<C:\Program Files\Media\SqueezeCenter\server\squeezecenter.exe>Slim/Networking/Select.pm line 243) frame 11: (eval) (/<C:\Program Files\Media\SqueezeCenter\server\squeezecenter.exe>Slim/Networking/Select.pm line 243) frame 12: Slim::Networking::Select::select (slimserver.pl line 503) frame 13: main::idle (slimserver.pl line 43) frame 14: PerlSvc::Startup (perlsvc line 851) frame 15: PerlSvc::_startup (slimserver.pl line 0) frame 16: (eval) (slimserver.pl line 0) [08-01-17 20:58:32.2189] Slim::Networking::Select::select (245) Error: Select task failed: Carp::Clan::__ANON__(): Error executing 'SELECT COUNT( DISTINCT( album.id ) ) FROM contributors me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.contributor = me.id ) JOIN albums album ON ( album.id = contributorAlbums.album ) WHERE ( ( ( album.compilation = ? ) AND ( me.role = ? ) ) )': DBD::mysql::st execute failed: Unknown column 'me.role' in 'where clause' at C:\Program Files\Media\SqueezeCenter\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. -- Wigster ------------------------------------------------------------------------ Wigster's Profile: http://forums.slimdevices.com/member.php?userid=14899 View this thread: http://forums.slimdevices.com/showthread.php?t=42394 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/beta
