[mythtv-users] Mythbackend error on schedule job Unknown column 'record.parentid' in 'field list'

[Jason McLeod]

I appear to be missing a column in my record table.  Any idea what the data
type for this column is?

Bellow is my mythbackend.log.

Any help is appreciated

-Jason

2006-03-31 10:22:39.536 Reschedule requested for id 0.
2006-03-31 10:22:39.561 DB Error (AddNewRecords):
Query was:
SELECT DISTINCT channel.chanid, channel.sourceid, program.starttime,
program.endtime, program.title, program.subtitle, program.description,
channel.channum, channel.callsign, channel.name, oldrecorded.endtime IS NOT
NULL AS oldrecduplicate, program.category, record.recpriority, record.dupin,
recorded.endtime IS NOT NULL AS recduplicate, oldfind.findid IS NOT NULL AS
findduplicate, record.type, record.recordid, program.starttime - INTERVAL
record.startoffset minute AS recstartts, program.endtime + INTERVAL
record.endoffset minute AS recendts, program.previouslyshown,
record.recgroup, record.dupmethod, channel.commfree, capturecard.cardid,
cardinput.cardinputid, UPPER(cardinput.shareable) = 'Y' AS shareable,
program.seriesid, program.programid, program.category_type, program.airdate,
program.stars, program.originalairdate, record.inactive, record.parentid,
(CASE record.type   WHEN 6    THEN record.findid   WHEN 9    THEN
to_days(date_sub(program.starttime, interval                 time_format(
record.findtime, '%H:%i') hour_minute))   WHEN 10    THEN
floor((to_days(date_sub(program.starttime, interval
time_format(record.findtime, '%H:%i') hour_minute)) -
record.findday)/7) * 7 + record.findday   WHEN 7    THEN record.findid
ELSE 0  END) , record.playgroup, oldrecstatus.recstatus,
oldrecstatus.reactivate, channel.recpriority + cardinput.preference FROM
recordmatch  INNER JOIN record ON (recordmatch.recordid = record.recordid)
INNER JOIN program ON (recordmatch.chanid = program.chanidAND
recordmatch.starttime = program.starttime AND
recordmatch.manualid = program.manualid)  INNER JOIN channel ON (
channel.chanid = program.chanid)  INNER JOIN cardinput ON (channel.sourceid=
cardinput.sourceid)  INNER JOIN capturecard ON (capturecard.cardid =
cardinput.cardid)  LEFT JOIN oldrecorded as oldrecstatus ON   (
oldrecstatus.station = channel.callsign AND     oldrecstatus.starttime =
program.starttime AND     oldrecstatus.title = program.title )  LEFT JOIN
oldrecorded ON   (     record.dupmethod > 1 AND     oldrecorded.duplicate <>
0 AND     program.title = oldrecorded.title      AND      (       (
program.programid <> '' AND program.generic = 0        AND program.programid=
oldrecorded.programid)       OR       (oldrecorded.findid <> 0 AND
oldrecorded.findid = (CASE record.type   WHEN 6    THEN record.findid   WHEN
9    THEN to_days(date_sub(program.starttime, interval
time_format(record.findtime, '%H:%i') hour_minute))   WHEN 10    THEN
floor((to_days(date_sub(program.starttime, interval
time_format(record.findtime, '%H:%i') hour_minute)) -
record.findday)/7) * 7 + record.findday   WHEN 7    THEN record.findid
ELSE 0  END) )       OR       (        program.generic = 0        AND
(program.programid = '' OR oldrecorded.programid = '')        AND        (((
record.dupmethod & 0x02) = 0) OR (program.subtitle <> ''           AND
program.subtitle = oldrecorded.subtitle))        AND        (((
record.dupmethod & 0x04) = 0) OR (program.description <> ''           AND
program.description = oldrecorded.description))       )      )   )  LEFT
JOIN recorded ON   (     record.dupmethod > 1 AND     recorded.duplicate <>
0 AND     program.title = recorded.title AND     recorded.recgroup <>
'LiveTV'      AND      (       (program.programid <> '' AND
program.generic= 0        AND
program.programid = recorded.programid)       OR       (recorded.findid <> 0
AND         recorded.findid = (CASE record.type   WHEN 6    THEN
record.findid   WHEN 9    THEN to_days(date_sub(program.starttime,
interval                 time_format(record.findtime, '%H:%i')
hour_minute))   WHEN 10    THEN floor((to_days(date_sub(program.starttime,
interval                time_format(record.findtime, '%H:%i') hour_minute))
-                record.findday)/7) * 7 + record.findday   WHEN 7    THEN
record.findid   ELSE 0  END) )       OR       (        program.generic =
0        AND        (program.programid = '' OR recorded.programid =
'')        AND        (((record.dupmethod & 0x02) = 0) OR
(program.subtitle<> ''           AND
program.subtitle = recorded.subtitle))        AND       
(((record.dupmethod& 0x04) = 0) OR (
program.description <> ''           AND program.description =
recorded.description))       )      )   )  LEFT JOIN oldfind ON   (
oldfind.recordid = recordmatch.recordid AND    oldfind.findid = (CASE
record.type   WHEN 6    THEN record.findid   WHEN 9    THEN
to_days(date_sub(program.starttime, interval                 time_format(
record.findtime, '%H:%i') hour_minute))   WHEN 10    THEN
floor((to_days(date_sub(program.starttime, interval
time_format(record.findtime, '%H:%i') hour_minute)) -
record.findday)/7) * 7 + record.findday   WHEN 7    THEN record.findid
ELSE 0  END) )  ORDER BY record.recordid DESC
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'record.parentid' in 'field list'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060331/31bd1902/attachment.htm