id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,mlocked 2395,Obsolete SQL breaks UPnP,Didier.Moens@…,dblain,"Browsing the UPnP services with a UPnP-capable client (Pinnacle ShowCenter 200) yields empty lists (""''No content found''"") for both '''Recordings/All''' and '''Music/*'''. This is mostly due to : 1. Recordings (trunk/mythtv/programs/mythbackend/upnpcdstv.cpp , revision 10118) : line 49 uses the Mysql reserved keyword ""KEY"" ; 2. Music (trunk/mythtv/programs/mythbackend/upnpcdsmusic.cpp , revision 10118) : all SQL queries refer to the empty table 'musicmetadata' (instead of 'music_songs'). ",defect,closed,minor,unknown,mythtv,0.20,medium,fixed,,,0