Bug 4221 - 6.5 crashes on artist breadcrumb
: 6.5 crashes on artist breadcrumb
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.5.0
: PC Windows XP
: P2 normal (vote)
: ---
Assigned To: Chris Owens
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-09-26 11:35 UTC by maditude
Modified: 2008-12-18 11:11 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description maditude 2006-09-26 11:35:41 UTC
See this thread:

 http://forums.slimdevices.com/showthread.php?t=27906

SlimServer complains:

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 C:\Program Files\SlimServer\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

And then the entire process stops running.

I suspect that is an easy fix, but I'm wondering why SlimServer would just give up and quit, just because a query failed?  Queries fail all the time (heh, or maybe it's just the buggy queries that I write!), and as a rule, shouldn't make something designed to be running as a daemon/service stop running.  I do appreciate that there are some queries which might fail, and indeed SlimServer would have no way of knowing what to do, but if we're just browsing around, that shouldn't be cause for shutdown.  (I further appreciate that I'm asking for new custom error handling, along with some sort of decision process that decides whether something was trivial or essential).
Comment 1 Dan Sully 2006-09-26 13:59:24 UTC
Fixed in change 10053