rendered paste bodyIndex: mythtv/programs/mythbackend/httpstatus.cpp
===================================================================
--- mythtv/programs/mythbackend/httpstatus.cpp (revision 12978)
+++ mythtv/programs/mythbackend/httpstatus.cpp (working copy)
@@ -1120,7 +1120,7 @@
if (query.isConnected())
{
- query.prepare("SELECT filename FROM music_songs WHERE song_id = :KEY" );
+ query.prepare("SELECT CONCAT(path, '/', filename) AS filename FROM music_songs s, music_directories d WHERE s.directory_id=d.directory_id AND song_id = :KEY" );
query.bindValue(":KEY", nTrack );
query.exec();