Opened 12 years ago

Closed 12 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";

Change History (1)

comment:1 Changed 12 years ago by xris

Resolution: fixed
Status: newclosed

(In [15488]) Apply correct playlist table name in SQL query. closes #4446

Note: See TracTickets for help on using tickets.