Opened 5 years ago

Closed 4 months ago

#13209 closed Bug Report - General (Trac EOL)

PlaylistM3u is incomplete from mythweb

Reported by: mourocq@… Owned by: Stuart Auchterlonie
Priority: minor Milestone: needs_triage
Component: Plugin - MythWeb Version: v29.0
Severity: medium Keywords: music playlist
Cc: Ticket locked: no

Description

Only the first song is present in the playlist.m3u.

cat playlist.m3u

EXTM3U #EXTINF:113,Manu Chao - La Primavera http://xxxx/mythweb/music/stream?i=4518 #EXTINF:0, - http://xxxx/mythweb/music/stream?i= #EXTINF:0, - .../...

Change History (3)

comment:1 Changed 3 years ago by nicolas-mrq

The tablespace is always with one ligne because of the sql query :

WHERE ms.song_id IN is ('x,y,z') instead of (x,y,z) or ('x','y','z')

to fix this bug replace line 1598 in file "mp3act_functions.php"

'WHERE ms.song_id IN ('.$db->escape($plplaylist_songs?).')'; in

'WHERE ms.song_id IN ('.$plplaylist_songs?.');';

You should report this fix in branch fixes/30 too.

bye

comment:2 Changed 3 years ago by nicolas-mrq

sorry replace whith

WHERE ms.song_id IN ('.$plplaylist_songs?.');';

thanks you

comment:3 Changed 4 months ago by Stuart Auchterlonie

Resolution: Trac EOL
Status: newclosed

We have moved all bug tracking to github [1]

If you continue to have this issue, please open a new issue at github, referencing this ticket.

[1] - https://github.com/MythTV/mythtv/issues

Note: See TracTickets for help on using tickets.