Opened 14 years ago

Closed 13 years ago

#2395 closed defect (fixed)

Obsolete SQL breaks UPnP

Reported by: Didier.Moens@… Owned by: dblain
Priority: minor Milestone: unknown
Component: mythtv Version: 0.20
Severity: medium Keywords:
Cc: Ticket locked: no

Description

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

  1. Music (trunk/mythtv/programs/mythbackend/upnpcdsmusic.cpp , revision 10118) :

all SQL queries refer to the empty table 'musicmetadata' (instead of 'music_songs').

Attachments (1)

patch_use_new_db_structure.diff (6.4 KB) - added by bryan@… 13 years ago.
Corrects the SQL

Download all attachments as: .zip

Change History (5)

comment:1 Changed 14 years ago by Isaac Richards

Severity: highmedium
Version: 0.20.10.20

comment:2 Changed 14 years ago by dblain

Owner: changed from Isaac Richards to dblain

comment:3 Changed 13 years ago by 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.

Changed 13 years ago by bryan@…

Corrects the SQL

comment:4 Changed 13 years ago by dblain

Resolution: fixed
Status: newclosed

(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.

Note: See TracTickets for help on using tickets.