Bug 3485 – Crash browsing to a genre from song info

Bug 3485 - Crash browsing to a genre from song info

Summary:

Crash browsing to a genre from song info

Status:	RESOLVED FIXED

Product:	Logitech Media Server
Classification:	Unclassified
Component:	Web Interface
Version:	6.5b1
Platform:	PC Windows XP

Importance:	P2 major (vote)
Target Milestone:	---
Assigned To:	Chris Owens

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2006-06-06 11:29 UTC by Philip Meyer
Modified:	2008-09-15 14:39 UTC (History)
CC List:	1 user (show)

See Also:
Category:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Philip Meyer 2006-06-06 11:29:43 UTC

If I drill down via song info into the genre, slimserver crashes:

2006-06-06 19:25:03.4384 DBD::mysql::st execute failed: Unknown column 'genre' in 'where clause' at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.
DBIx::Class::ResultSet::count(): Error executing 'SELECT COUNT( * ) FROM albums me LEFT JOIN contributor_album contributorAlbums ON ( contributorAlbums.album = me.id ) WHERE ( contributorAlbums.role IN ( ?, ? ) AND genre = ? AND me.compilation = ? )' (`1', `5', `15', `1'): DBD::mysql::st execute failed: Unknown column 'genre' in 'where clause' at P:\Music\SlimServer\trunk\server\CPAN/DBIx/Class/Storage/DBI.pm line 525.

This happens in both Fishbone skin and default skin.

Comment 1 KDF 2006-06-06 13:19:27 UTC

possible fix in trunk change 7773

Comment 2 KDF 2006-06-06 17:49:28 UTC

please reopen if issues remain from June 7 nightly.