I just updated my SVN checkout to 7.5/trunk revision 30686. Upon restarting server, I played a couple of tracks, then in the Web UI I tried to Browse Genres > Blues > Various Artists > Blues Legends.
Clicking on Various Artists for genre Blues seemed to take quite some time (~ 10 seconds). Clicking on an album within Various Artists throws an exception (see below) - looks like it is to do with calculating the "n albums with n songs by n artists" stats at the bottom of the browse page, as this appears to be blank. If I browse to Artists > Various Artists > [any album], this doesn't throw the exception, and does report the album/songs/artists stats. [23:38:42.3257] Slim::Schema::Storage::throw_exception (82) Error: DBI Exception: DBD::mysql::st execute failed: Unknown column 'contributorTracks.role' in 'where clause' [for Statement "SELECT COUNT( * ) FROM (SELECT contributor.id FROM albums me JOIN tracks tracks ON tracks.album = me.id LEFT JOIN genre_track genreTracks ON genreTracks.track = tracks.id JOIN albums album ON album.id = tracks.album JOIN contributors contributor ON contributor.id = album.contributor WHERE ( ( contributorTracks.role IN ( ?, ?, ?, ?, ? ) AND ( genreTracks.genre = ? AND me.compilation = ? AND me.id = ? ) ) ) GROUP BY contributor.id) count_subq"] [23:38:42.3272] Slim::Schema::Storage::throw_exception (82) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (P:/Music/SlimServer/trunk/server/Slim/Schema/Storage.pm line 82) frame 1: Slim::Schema::Storage::throw_exception (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 957) frame 2: DBIx::Class::Storage::DBI::__ANON__ (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 1217) frame 3: DBIx::Class::Storage::DBI::_dbh_execute (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 532) frame 4: DBIx::Class::Storage::DBI::dbh_do (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 1227) frame 5: DBIx::Class::Storage::DBI::_execute (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 1451) frame 6: DBIx::Class::Storage::DBI::_select (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 82) frame 7: DBIx::Class::Storage::DBI::Cursor::_dbh_next (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 547) frame 8: (eval) (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 540) frame 9: DBIx::Class::Storage::DBI::dbh_do (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 101) frame 10: DBIx::Class::Storage::DBI::Cursor::next (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSetColumn.pm line 128) frame 11: DBIx::Class::ResultSetColumn::next (P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/ResultSet.pm line 1181) frame 12: DBIx::Class::ResultSet::count (P:/Music/SlimServer/trunk/server/Slim/Web/Pages/Common.pm line 162) frame 13: (eval) (P:/Music/SlimServer/trunk/server/Slim/Web/Pages/Common.pm line 159) frame 14: Slim::Web::Pages::Common::addLibraryStats (P:/Music/SlimServer/trunk/server/Slim/Web/Pages/BrowseDB.pm line 513) frame 15: Slim::Web::Pages::BrowseDB::browsedb (P:/Music/SlimServer/trunk/server/Slim/Web/HTTP.pm line 1097) frame 16: Slim::Web::HTTP::generateHTTPResponse (P:/Music/SlimServer/trunk/server/Slim/Web/HTTP.pm line 924) frame 17: Slim::Web::HTTP::processURL (P:/Music/SlimServer/trunk/server/Slim/Web/HTTP.pm line 735) frame 18: Slim::Web::HTTP::processHTTP (P:/Music/SlimServer/trunk/server/Slim/Networking/IO/Select.pm line 139) frame 19: (eval) (P:/Music/SlimServer/trunk/server/Slim/Networking/IO/Select.pm line 123) frame 20: Slim::Networking::IO::Select::__ANON__ (P:/Music/SlimServer/trunk/server/Slim/Networking/IO/Select.pm line 183) frame 21: (eval) (P:/Music/SlimServer/trunk/server/Slim/Networking/IO/Select.pm line 183) frame 22: Slim::Networking::IO::Select::loop (P:\Music\SlimServer\trunk\server\slimserver.pl line 626) frame 23: main::idle (P:\Music\SlimServer\trunk\server\slimserver.pl line 580) frame 24: main::main (P:\Music\SlimServer\trunk\server\slimserver.pl line 1072) I don't often browse various artists via a specific genre, so perhaps this has been broken for a while? I assume that it should report stats if browsed in this way, and the query is just a bit wrong? Phil _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
