[mythtv-users] A few MythTV issues

[John Drescher]

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 .
>
> 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?

YES, it does. The encoder has to que up some frames before encoding
and the encoding process does take time so in effect the process
delays the signal by several seconds. I have seen discussions about
workarounds but I do not know the exact details.

>
> 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 am not sure but this is probably because you are using an old
version of mythtv that may be incompatible with your version of mysql.
What version of mysql do you have installed?