[mythtv-users] (no subject)
Jason McLeod
anakin at sdf1.net
Fri Mar 31 15:55:21 UTC 2006
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
Thanks
-Jason
Blog: http://jayslife.com
GPG Fingerprint:
anakin at sdf1.net - A6CC 40B4 99A4 1C08 55A7 BCFC ECDF ED68 115E 5993
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.chanid AND
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/69813cd4/attachment-0001.htm
More information about the mythtv-users
mailing list