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

[Another Sillyname]

Did you back up your DB before the upgrade?

If so why not just backup the current one and restore the old
one......then run mythtv-setup (BEFORE running the backend) and let it
update the schema.

J

On 27/03/2008, Warpme <warpme at o2.pl> wrote:
> 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
>
> _______________________________________________
>  mythtv-users mailing list
>  mythtv-users at mythtv.org
>  http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
>