Bug 3497 – Advanced search with 'artist' field causes crash

Bug 3497 - Advanced search with 'artist' field causes crash

Summary:

Advanced search with 'artist' field causes crash

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 17:25 UTC by KDF
Modified:	2008-09-15 14:39 UTC (History)
CC List:	0 users

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 KDF 2006-06-06 17:25:12 UTC

svn 7776 initiating a search from advanced search page, default and fishbone skins with anything in the 'artist' field:

2006-06-06 17:19:12.3347 DBD::mysql::st execute failed: Unknown table 'contributor' in where clause at /usr/local/sl
imserver/trunk/CPAN/DBIx/Class/Storage/DBI.pm line 525.

DBIx::Class::ResultSet::count(): Error executing 'SELECT COUNT( * ) FROM tracks me LEFT JOIN contributor_track contr
ibutorTracks ON ( contributorTracks.track = me.id ) WHERE ( ( ( ( ( contributor.namesearch LIKE ? ) OR ( contributor
.namesearch LIKE ? ) ) ) ) AND ( ( contributorTracks.role LIKE ? ) OR ( contributorTracks.role LIKE ? ) ) )' (`U2%',
 `% U2%', `1', `5'): DBD::mysql::st execute failed: Unknown table 'contributor' in where clause at /usr/local/slimse
rver/trunk/CPAN/DBIx/Class/Storage/DBI.pm line 525.

Comment 1 KDF 2006-06-08 23:06:34 UTC

fixed at change 7833