[mythtv-users] (no subject)

[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

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