Opened 15 years ago

Closed 15 years ago

#1673 closed defect (fixed)

9668 broke db query on line 1506 of programinfo.cpp

Reported by: stuart@… Owned by: danielk
Priority: minor Milestone: unknown
Component: mythtv Version: head
Severity: medium Keywords:
Cc: Ticket locked: no


9668 added a new column to the program table, which breaks the query on line 1506 of programinfo.cpp (REPLACE INTO program SELECT * FROM recordedprogram) because the new column doesn't match up.

I've attached a patch which adds the new column to recordedprogram. Not sure if the column makes any sense there but I'm being lazy and avoiding adding the 25 column names to the query.

Attachments (1)

fix.diff (693 bytes) - added by anonymous 15 years ago.

Download all attachments as: .zip

Change History (2)

Changed 15 years ago by anonymous

Attachment: fix.diff added

comment:1 Changed 15 years ago by danielk

Resolution: fixed
Status: newclosed

(In [9686]) Fixes #1673. Adds missing DB change in [9668].

There is a new column listingsource in program which allows us to determine where a listing came from when deciding how to treat it when we get new listings data. We need to clone that column in recordedprogram so that one of the db queries works.

Note: See TracTickets for help on using tickets.