Bug 4200 - Clicking artist after viewing "all songs" crashes server
: Clicking artist after viewing "all songs" crashes server
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Web Interface
: 6.5.0
: PC Fedora
: P2 normal (vote)
: ---
Assigned To: Chris Owens
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-09-23 01:44 UTC by piglith
Modified: 2009-01-29 09:47 UTC (History)
1 user (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description piglith 2006-09-23 01:44:03 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.
Comment 1 KDF 2006-09-25 13:41:37 UTC
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.
Comment 2 KDF 2006-09-28 00:41:35 UTC
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.