[mythtv-users] URGENT: No TV shows after 0.21 upgrade :-(

[Warpme]

Hi *

I just upgrade form r5f27 to 0.21 via 0.21-fixes compilation on r5f27 
system.
Well - at first look thing went well - but closer examination shows 
issue with accessing existing tv shows.
FE shows my recordings groups and no shows in group OK - but entering 
particular group list shows empty list.

Going into backend log shows following error:

Code:
2008-03-27 10:04:03.228 AutoExpire: CalcParams(): Max required Free 
Space: 4.0 GB w/freq: 15 min
2008-03-27 10:04:03.235 Started recording: 1 (TVP1) "Thu Mar 27 10:04:00 
2008": channel 1001 on cardid 1, sourceid 1
2008-03-27 10:04:03.241 scheduler: Started recording: 1 (TVP1) "Thu Mar 
27 10:04:00 2008": channel 1001 on cardid 1, sourceid 1
2008-03-27 10:07:05.420 MainServer::HandleAnnounce Monitor
2008-03-27 10:07:05.422 adding: mythtv as a client (events: 0)
2008-03-27 10:07:08.471 MainServer::HandleAnnounce Monitor
2008-03-27 10:07:08.476 adding: mythtv as a client (events: 0)
2008-03-27 10:07:08.609 DB Error (ProgramList::FromRecorded):
Query was:
SELECT 
recorded.chanid,recorded.starttime,recorded.endtime,recorded.title,recorded.subtitle,recorded.description,recorded.hostname,channum,name,callsign,commflagged,cutlist,recorded.autoexpire,editing,bookmark,recorded.category,recorded.recgroup,record.dupin,record.dupmethod,recorded.recordid,channel.outputfilters,recorded.seriesid,recorded.programid,recorded.filesize, 
recorded.lastmodified, recorded.findid, recorded.originalairdate, 
recorded.playgroup, recorded.basename, recorded.progstart, 
recorded.progend, recorded.stars, recordedprogram.audioprop+0, 
recordedprogram.videoprop+0, recordedprogram.subtitletypes+0, 
transcoded, recorded.recpriority, watched, recorded.preserve, 
recorded.storagegroup FROM recorded LEFT JOIN record ON 
recorded.recordid = record.recordid LEFT JOIN channel ON recorded.chanid 
= channel.chanid LEFT JOIN recordedprogram ON  ( recorded.chanid = 
recordedprogram.chanid AND   recorded.progstart = 
recordedprogram.starttime ) WHERE ( recorded.deletepending = 0 
OR         DATE_ADD(recorded.lastmodified, INTERVAL 5 MINUTE) <= 
NOW()       ) ORDER BY recorded.starttime 
DESC,atsc_major_chan,atsc_minor_chan,channum,callsign
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'watched' in 'field list'

2008-03-27 10:07:13.654 MainServer::HandleAnnounce Monitor
2008-03-27 10:07:13.655 adding: mythtv as a client (events: 0)
2008-03-27 10:07:15.973 MainServer::HandleAnnounce Monitor
2008-03-27 10:07:15.977 adding: mythtv as a client (events: 0)
2008-03-27 10:07:16.101 DB Error (ProgramList::FromRecorded):
Query was:
SELECT 
recorded.chanid,recorded.starttime,recorded.endtime,recorded.title,recorded.subtitle,recorded.description,recorded.hostname,channum,name,callsign,commflagged,cutlist,recorded.autoexpire,editing,bookmark,recorded.category,recorded.recgroup,record.dupin,record.dupmethod,recorded.recordid,channel.outputfilters,recorded.seriesid,recorded.programid,recorded.filesize, 
recorded.lastmodified, recorded.findid, recorded.originalairdate, 
recorded.playgroup, recorded.basename, recorded.progstart, 
recorded.progend, recorded.stars, recordedprogram.audioprop+0, 
recordedprogram.videoprop+0, recordedprogram.subtitletypes+0, 
transcoded, recorded.recpriority, watched, recorded.preserve, 
recorded.storagegroup FROM recorded LEFT JOIN record ON 
recorded.recordid = record.recordid LEFT JOIN channel ON recorded.chanid 
= channel.chanid LEFT JOIN recordedprogram ON  ( recorded.chanid = 
recordedprogram.chanid AND   recorded.progstart = 
recordedprogram.starttime ) WHERE ( recorded.deletepending = 0 
OR         DATE_ADD(recorded.lastmodified, INTERVAL 5 MINUTE) <= 
NOW()       ) ORDER BY recorded.starttime 
DESC,atsc_major_chan,atsc_minor_chan,channum,callsign
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'watched' in 'field list'

2008-03-27 10:07:19.247 MainServer::HandleAnnounce Monitor
2008-03-27 10:07:19.250 adding: mythtv as a client (events: 0)


Indeed examination field list in recorded table structure shows no field 
like "watched" (or I'm looking into wrong place).
Should I simply add this field to recorded table ?
If so what field type is needed and how to do that in simply and 
error-free manner ?

Can somebody help me pls with this issue as my family will simply kill 
me when they discover missing tv shows....

br
-------------- next part --------------
A non-text attachment was scrubbed...
Name: warpme.vcf
Type: text/x-vcard
Size: 83 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20080327/03cd8731/attachment.vcf