Opened 11 years ago

Closed 11 years ago

#5383 closed defect (worksforme)

Schema upgrade fails to add 'watched' field to 'recorded' table in DB

Reported by: kidcharlemagne87@… Owned by: Isaac Richards
Priority: major Milestone: unknown
Component: mythtv Version: 0.21
Severity: high Keywords: watched recorded schema upgrade
Cc: Ticket locked: no

Description

I upgraded from 0.20.2 to 0.21, and mythtv-setup succeeded (apparently) in upgrading my old database to the new schema. However, the 'Watch Recordings' screen did not show any recorded programs. I analyzed the structure of the 'recorded' table in the mythconverg database and found that it did not have the 'watched' field as required in the new schema. After manually adding this field (setting all programs to have the value 0) the programs showed up in the 'Watch Recordings' list. This appears to be a problem with the schema upgrading system.

Change History (1)

comment:1 Changed 11 years ago by stuartm

Resolution: worksforme
Status: newclosed
Note: See TracTickets for help on using tickets.