[mythtv-users] A few MythTV issues

Carl Fongheiser carlfongheiser at gmail.com
Tue Aug 1 12:38:11 UTC 2006

On 8/1/06, Bill Atkins <atkinw at rpi.edu> wrote:
> I'm trying to set up MythTV with my Hauppauge PVR-150, but I'm having
> a couple of problems:
> 1.  If I connect the output jack of my satellite set-top box to the
> input of my tuner card, I'd expect to be able to tune to channel 3 on
> my machine and watch TV from the satellite.  This doesn't work - every
> channel I tune to is static.  I've tried this from within MythTV and
> also by manually tuning the IVTV drivers to 3 and then mplaying
> /dev/video0 .

Are you sure your tuner was properly detected?  Check dmesg to find out.

2.  I'd like to be able to play my PlayStation2 through my tuner card
> (one of the reasons I bought the tuner card was to eliminate the space
> my TV takes up).  If I plug my playstation into the composite inputs
> and select them as an input, this works.  However, there's one fairly
> large problem - a five-second lag between pressing a button and seeing
> a reaction.  Obviously, this is no way to play a game.  Does this have
> something to do with the time it takes my card to encode MPEG's, and
> if so, how can I turn that off?

Sorry, you're stuck with it.  You can launch an external program to play the
video, but there will still be a slight delay.

3.  The mythfilldatabase command fails spectacularly for me.  It
> downloads the files without any issue, but then the terminal is
> flooded with messages like this:
> DB Error (Inserting into dd_schedule):
> Query was:
> INSERT INTO dd_schedule
> (programid,stationid,scheduletime,duration,repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtime)
> VALUES('SH7400760000','46172','2006-08-02T00:00:00','01:00:00',0,0,0,0,0,NULL,0,0,'2006-08-02T01:00:00');
> Driver error was [2/1064]:
> 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
> 'repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtim'
> at line 1

I'm guessing you're running MySQL version 5.  Known problem. You have a
couple choices here:

1) Downgrade to MySQL version 4.something
2) Upgrade MythTV to 0.19 (or even better, 0.19-fixes)

Carl Fongheiser
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060801/bd3e3f94/attachment.htm 

More information about the mythtv-users mailing list