[mythtv-users] Composite1

Vaughan Famularo peppercorn at netspace.net.au
Tue Sep 16 20:23:40 EDT 2003


Hi guys,
I am a bit of a newbie to Linux and definitely to Mythtv, BUT I'm
getting there!!

I have Mythtv installed and running on an AMD 2600 using a Winfast 2000
capture card and running Mandrake 9.1. I have been able to capture
Australian TV channels using tv_grab 
BUT I hav'nt hooked my capture card up to an aerial yet.

I HAVE it hooked up to a Sat TV connection via my Composite1 connection
which shows whatever is being shown in the loungeroom. That's fine by me
so far.

My problem is, that although I can watch TV via composite1, I cannot
record!!!

everytime I try I get an error such as the following.

How do you schedule Mythtv to record from a composite1 connection when
there is no program info???  Instant record gives this following error.

Thanks in advance

Peppercorn

SELECT recordid FROM record WHERE record.title = " ncnc" AND
((record.type = 4)
 OR  ((record.chanid =  )   AND   ((record.type = 3)    OR  
(((TIME_TO_SEC(record.starttime) = TIME_TO_SEC('19:21:23'))      
AND      (TIME_TO_SEC(record.endtime) = TIME_TO_SEC('20:21:23'))    
)    AND     ((record.type = 2)      OR
((DAYOFWEEK(record.startdate) = DAYOFWEEK('2003-09-16')       AND      
((record.type = 5)        OR        ((TO_DAYS(record.startdate) =
TO_DAYS('2003-09-16'))         AND         (TO_DAYS(record.enddate) =
TO_DAYS('2003-09-16'))         )       )      )     )    )   )  ) ));
Driver error was [2/-1]:
QMYSQL3: Unable to execute query
Database error was:
You have an error in your SQL syntax.  Check the manual that corresponds
to your MySQL server version for the right syntax to use near ')   AND  
((record.type
= 3)    OR   (((TIME_TO_SEC(record.star




More information about the mythtv-users mailing list