Obsolete SQL breaks UPnP

[Didier.Moens@…]

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').

[bryan@…]

Here is a patch (patch_use_new_db_structure.diff) that updates the SQL to the new schema. Note it doesn't fix no. 1 above.

[bryan@…]

Corrects the SQL

[dblain]

(In [12394]) Merges the following patches:

Closes #2395 - Updated SQL for music Closes #2500 - Blocked Range requests from Syabas agents

New Features Added:

• uPnP Eventing now supported
• Connection manager Service implemented (very basic)
• XBMC( Orig XBox ) support... (must add database setting upnpSSDPBroadcast=1 to turn on)

Enhancements/Fixes?:

• Sends notifications to remove mythtv on startup (cleans up any old references).
• Notification process more uPnP compliant.