Opened 18 years ago

Closed 17 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@… 17 years ago.
Corrects the SQL

Download all attachments as: .zip

Change History (5)

comment:1 Changed 18 years ago by Isaac Richards

Severity: high → medium
Version: 0.20.1 → 0.20

comment:2 Changed 18 years ago by dblain

Owner: changed from Isaac Richards to dblain

comment:3 Changed 17 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 17 years ago by bryan@…

Attachment: patch_use_new_db_structure.diff​ added

Corrects the SQL

comment:4 Changed 17 years ago by dblain

Resolution: → fixed
Status: new → closed

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