Opened 16 years ago
Closed 16 years ago
#4446 closed defect (fixed)
music.php playlist query uses invalid table and field names.
Reported by: | I3ooI3oo | Owned by: | xris |
---|---|---|---|
Priority: | minor | Milestone: | unknown |
Component: | mythweb | Version: | 0.20.2 |
Severity: | low | Keywords: | |
Cc: | Ticket locked: | no |
Description
In file mythweb/modules/music/tmpl/default/music.php the function playListSelector has the following query.
$query="SELECT playlistid, name from musicplaylist order by name";
The table name is wrong, the fieldnames are allow incorrect. The following uses the corrected names.
$query="SELECT playlist_id,playlist_name from music_playlists order by playlist_name";
Note: See
TracTickets for help on using
tickets.
(In [15488]) Apply correct playlist table name in SQL query. closes #4446