Bugzilla – Bug 3863
Trying to browse albums by artwork crashes slimserver
Last modified: 2008-09-15 14:39:24 UTC
Running revision 8775 on Windows XP MCE 2005 SP2. When trying to browse albums by artwork, Slimserver crashes with following error: 2006-08-03 18:55:22.1064 DBD::mysql::st execute failed: Unknown column 'contributorme.year' in 'order clause' at C:\SlimServer6.5b1\CPAN/DBIx/Class/Storage/DBI.pm line 743. 2006-08-03 18:55:22.1090 ERROR: Error executing 'SELECT me.id, me.titlesort, me.contributor, me.compilation, me.year, me.artwork, me.disc, me.discc, me.musicmagic_mixable, me.titlesearch, me.replay_gain, me.replay_peak, me.musicbrainz_id, me.title FROM albums me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.album = me.id ) JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( contributorAlbums.role IN ( ?, ? ) ) GROUP BY me.id ORDER BY contributorme .year,concat('0', me.titlesort), me.disc LIMIT 50': DBD::mysql::st execute failed: Unknown column 'contributorme.year' in 'order clause' at C:\SlimServer6.5b1\CPAN/DBIx/Class/Storage/DBI.pm line 743. 2006-08-03 18:55:22.1167 ERROR: Backtrace follows: 2006-08-03 18:55:22.1223 Backtrace: frame 0: Slim::Schema::Storage::throw_exception (C:\SlimServer6.5b1\CPAN/DBIx/Class/Storage/DBI.pm line 745) frame 1: DBIx::Class::Storage::DBI::_execute (C:\SlimServer6.5b1\CPAN/DBIx/Class/Storage/DBI.pm line 798) frame 2: DBIx::Class::Storage::DBI::_select (C:\SlimServer6.5b1\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 79) frame 3: DBIx::Class::Storage::DBI::Cursor::next (C:\SlimServer6.5b1\CPAN/DBIx/Class/Cursor.pm line 69) frame 4: DBIx::Class::Cursor::all (C:\SlimServer6.5b1\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 115) frame 5: DBIx::Class::Storage::DBI::Cursor::all (C:\SlimServer6.5b1\CPAN/DBIx/Class/ResultSet.pm line 921) frame 6: DBIx::Class::ResultSet::all (C:\SlimServer6.5b1\CPAN/DBIx/Class/ResultSet.pm line 149) frame 7: DBIx::Class::ResultSet::search (C:\SlimServer6.5b1\CPAN/DBIx/Class/ResultSet.pm line 635) frame 8: DBIx::Class::ResultSet::slice (C:\SlimServer6.5b1/Slim/Web/Pages/BrowseDB.pm line 339) frame 9: Slim::Web::Pages::BrowseDB::browsedb (C:\SlimServer6.5b1/Slim/Web/HTTP.pm line 793) frame 10: Slim::Web::HTTP::generateHTTPResponse (C:\SlimServer6.5b1/Slim/Web/HTTP.pm line 667) frame 11: Slim::Web::HTTP::processURL (C:\SlimServer6.5b1/Slim/Web/HTTP.pm line 517) frame 12: Slim::Web::HTTP::processHTTP (C:\SlimServer6.5b1/Slim/Networking/Select.pm line 170) frame 13: Slim::Networking::Select::select (slimserver.pl line 496) frame 14: main::idle (slimserver.pl line 449) frame 15: main::main (slimserver.pl line 1046) 2006-08-03 18:55:22.1720 DBD::mysql::st fetchrow_array failed: fetch() without execute() at C:\SlimServer6.5b1\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 86. DBD::mysql::st fetchrow_array failed: fetch() without execute() at C:\SlimServer6.5b1\CPAN/DBIx/Class/Storage/DBI/Cursor.pm line 86. 2006-08-03 18:55:22.1749 Got to the END. 2006-08-03 18:55:22.1778 Got sigint. 2006-08-03 18:55:22.1812 SlimServer cleaning up. 2006-08-03 18:55:22.1869 Shutting down plugins... 2006-08-03 18:55:22.2069 Unsubscribing on 'play', 'pause', 'stop', 'power', 'mode' 2006-08-03 18:55:22.2099 Unsubscribing on 'open' 2006-08-03 18:55:22.2126 unHookScrobbler() engaged, SlimScrobbler V0.35 deactivated. 2006-08-03 18:55:22.2221 MySQLHelper: stopServer() Running shutdown. This happens with "Fishbone", "Nokia770" and "default" skins. Can't say about other skins as I haven't tried there! Regards, Alex
Hi Alex, I'm not seeing this symptom. What were you doing when this occurred? Had you just clicked on 'Albums'? Or were you browsing for a page or two before the crash? Would it be possible for you to clear and rescan your db and try again to see if it's still happening? Thanks for any info!
Chris, I can consistently reproduce this problem. I just browse to the "Albums" view (any skin), and switch to "Gallery View" - this causes SlimServer to crash. I've tried wiping the "Cache" folder, as well as my browser cache and cookies (also tried browsing from a different PC), but the same behaviour was noticed. Gallery view seems to work fine in other pages (e.g. "New Music", or when browsing by Artist or Year). Anything else I should try? Cheers Alex
change your artwork sort order pref.
In case an explanation is required, the sort order pref changed a few times after the split-scanner merge. this means artists had to be changed to contributors. The initial changes weren't 100% correct, so this resulted in odd results for some, and causes a crash with the same messages as above. for Chris, one task should be to go between a 6.3.1 install and a current 6.5b1 install to make sure each of the settings convert safely. Hopefully those should all be safe, and the current crashes are all from users who are updating 6.5 and getting odd prefs through that process.
Added to my test procedure. Alex did that fix your problem?
Sorry for the delay - was away over the weekend. Yes, this seems to have done the trick, thanks...
marking as 'wontfix' since bugzilla doesn't have an option for 'pref incompatability only affecting beta upgraders'