Opened 9 years ago

Closed 8 years ago

Last modified 8 years ago

#9441 closed Patch - Bug Fix (Fixed)

UPnP Music SQL fix

Reported by: otto@… Owned by: beirdo
Priority: minor Milestone: 0.25
Component: MythTV - UPnP Version: Master Head
Severity: medium Keywords:
Cc: Ticket locked: no

Description

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.

Attachments (1)

be-upnp-music.patch (574 bytes) - added by otto@… 9 years ago.

Download all attachments as: .zip

Change History (4)

Changed 9 years ago by otto@…

Attachment: be-upnp-music.patch added

comment:1 Changed 9 years ago by beirdo

Owner: changed from dblain to beirdo
Status: newassigned

comment:2 Changed 8 years ago by greg

Resolution: Fixed
Status: assignedclosed

This change has been applied, closing this one :)

comment:3 Changed 8 years ago by stuartm

Milestone: unknown0.25
Note: See TracTickets for help on using tickets.