Bugzilla – Bug 4200
Clicking artist after viewing "all songs" crashes server
Last modified: 2009-01-29 09:47:22 UTC
I'm using Slimserver 6.50 (Public release) Fedora Core 4, MySQL 5.0.24a-standard, Default theme If you search for an artist via basic search... You get a list of songs, albums, etc... Click "All Songs" to display all tracks, albums, etc... List is displayed Clicking the artists name in the path tree (Home/Artists/XYZ) crashes the server compleatly Here is my log output after the click: 2006-09-23 01:35:12.5088 ERROR: Error executing 'SELECT LEFT(album.titlesort, 1), 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 ( ( ( contributorAlbums.role IN ( ?, ? ) AND me.id = ? ) ) ) GROUP BY LEFT(album.titlesort, 1) ORDER BY concat('0', album.titlesort),me.disc,me.tracknum,concat('0', me.titlesort)': DBD::mysql::st execute failed: Unknown column 'me.disc' in 'order clause' at /usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 771. 2006-09-23 01:35:12.5099 ERROR: Backtrace follows: 2006-09-23 01:35:12.5107 Backtrace: frame 0: Slim::Schema::Storage::throw_exception (/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 1: DBIx::Class::Storage::DBI::_execute (/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 826) frame 2: DBIx::Class::Storage::DBI::_select (/usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79) frame 3: DBIx::Class::Storage::DBI::Cursor::next (/usr/local/slimserver/CPAN/DBIx/Class/ResultSet.pm line 701) frame 4: DBIx::Class::ResultSet::next (/usr/local/slimserver/CPAN/DBIx/Class/ResultSet.pm line 990) frame 5: DBIx::Class::ResultSet::first (/usr/local/slimserver/Slim/Web/Pages.pm line 387) frame 6: Slim::Web::Pages::pageInfo (/usr/local/slimserver/Slim/Web/Pages/BrowseDB.pm line 271) frame 7: Slim::Web::Pages::BrowseDB::browsedb (/usr/local/slimserver/Slim/Web/HTTP.pm line 811) frame 8: Slim::Web::HTTP::generateHTTPResponse (/usr/local/slimserver/Slim/Web/HTTP.pm line 677) frame 9: Slim::Web::HTTP::processURL (/usr/local/slimserver/Slim/Web/HTTP.pm line 523) frame 10: Slim::Web::HTTP::processHTTP (/usr/local/slimserver/Slim/Networking/Select.pm line 238) frame 11: Slim::Networking::Select::select (/usr/local/slimserver/slimserver.pl line 487) frame 12: main::idle (/usr/local/slimserver/slimserver.pl line 440) frame 13: main::main (/usr/local/slimserver/slimserver.pl line 1039) Carp::Clan::__ANON__(): Error executing 'SELECT LEFT(album.titlesort, 1), 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 ( ( ( contributorAlbums.role IN ( ?, ? ) AND me.id = ? ) ) ) GROUP BY LEFT(album.titlesort, 1) ORDER BY concat('0', album.titlesort),me.disc,me.tracknum,concat('0', me.titlesort)': DBD::mysql::st execute failed: Unknown column 'me.disc' in 'order clause' at /usr/local/slimserver/CPAN/DBIx/Class/Storage/DBI.pm line 771.
The "all songs" item in the search results should not be clickable, as the list off all songs is exactly what follows. It is intended for allowing play/add/etc of all songs. This is probably another case of an old template left behind. Removing HTML/Default and reinstalling should get rid of this problem.
error message is a dupe of bug 4221, marked as fixed from change 10053. please update to nightly, or await next release. reopen if the issue remains.