id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
9441	UPnP Music SQL fix	otto@…	beirdo	"Current UPnP code produces following error when music albums are browsed:

{{{
2011-01-02 20:44:28.101 Error preparing query: SELECT song.song_id as intid, artist.artist_name as artist, album.album_name as album, song.name as title, genre.genre, song.year, song.track as tracknum, song.description, song.filename, song.length FROM music_songs song  join music_artists artist on artist.artist_id = song.artist_id  join music_albums album on album.album_id = song.album_id  join music_genres genre on  genre.genre_id = song.genre_id  WHERE song.album_id=:KEY ORDER BY song.album_name  LIMIT 0, 32767
2011-01-02 20:44:28.111 Driver error was [2/1054]:
QMYSQL3: Unable to prepare statement
Database error was:
Unknown column 'song.album_name' in 'order clause'
}}}

Attached patch fixes the related SQL."	Patch - Bug Fix	closed	minor	0.25	MythTV - UPnP	Master Head	medium	Fixed			0