[mythtv-users] mythtv does not tune to channels

[Paul Koster]

For some weeks now I'm stuck with the problem that 'Watch TV' of MythTV
results in just some static noise (or fixed channel if I've set the
frequency manually first). Pressing '1' or '2' does nothing at all except
showing those numbers as overlay. ChannelUP results the following error in
Mythbackend:
Channel: '' was not found in the database.
Most likely, the default channel set for this input
(2 Tuner 0 )
in setup is wrong

For some reason it does not tune into the startchannel (therefore
channum=''), which has the consequence that the error message follows (I
executed the select query included below manually and it returns no rows,
however with the channum condition removed it returns 1 and 2 as results.
Applying this does not fix the problem however.)

The ivtv driver for the PVR250 does not include any errors in
/var/log/messages that could give a clue.

Any idea how to I fix this?

--
Paul

Output of some database tables (best shown in fixed-space font):
------------------------------------------------------------------
SQL-query: SELECT * FROM `capturecard` LIMIT 0, 30;
cardid  videodevice  audiodevice  vbidevice  cardtype  defaultinput
audioratelimit  hostname  dvb_swfilter  dvb_recordts
2       /dev/video0  /dev/dsp     /dev/vbi   MPEG Tuner 0            0
pvr       0             0

SQL-query: SELECT * FROM `cardinput` LIMIT 0, 30;
cardinputid  cardid  sourceid  inputname  externalcommand  preference
shareable  tunechan  startchan
2            2       3         Tuner 0                    NULL        N
1

SQL-query: SELECT * FROM `channel` LIMIT 0, 30;
chanid  channum  freqid  sourceid  callsign  name  icon  finetune
videofilters  xmltvid  recpriority  contrast  brightness  colour  hue
tvformat
<cut lots of channels for which i put channum at 99>
1021    1        R11     3        NED1       Nederland1            0
nederland1.omroep.nl 0 32768 32768 32768 32768
1022    2        R7      3        NED2       Nederland2            0
nederland2.omroep.nl 0 32768 32768 32768 32768
1023    3                3        Nederland3 Nederland3            0
nederland3.omroep.nl 0 32768 32768 32768 32768
1024    99               3        NET 5      NET 5                 0
net5.nl              0 32768 32768 32768 32768
1025    99               3        Nickelodeon Nickelodeon          0
nick.com             0 32768 32768 32768 32768
<etc. for some more channels)

Output of mythbackend:
------------------------
Starting up as the master server.
2004-01-28 21:18:04 mythbackend version: 0.14.20040114-1 www.mythtv.org
2004-01-28 21:18:04 Enabled verbose msgs : important general
2004-01-28 21:18:06 Found changes in the todo list.
2004-01-28 21:22:06 MainServer::HandleAnnounce Playback
2004-01-28 21:22:06 adding: pvr as a client (events: 0)
2004-01-28 21:22:06 MainServer::HandleAnnounce Playback
2004-01-28 21:22:06 adding: pvr as a client (events: 1)
2004-01-28 21:22:06 MainServer::HandleAnnounce Playback
2004-01-28 21:22:06 adding: pvr as a client (events: 0)
2004-01-28 21:22:06 MainServer::HandleAnnounce Playback
2004-01-28 21:22:06 adding: pvr as a client (events: 0)
2004-01-28 21:22:06 adding: pvr as a remote ringbuffer
2004-01-28 21:22:06 Changing from None to WatchingLiveTV
Channel: '' was not found in the database.
Most likely, the default channel set for this input
(2 Tuner 0 )
in setup is wrong
<<<added print of select statement myself in the sourcecode>>>
SELECT channum + 0(channelorder) FROM channel,capturecard,cardinput WHERE
channe
l.channum = (channum) AND channel.sourceid = cardinput.sourceid AND
cardinput.in
putname = Tuner 0(channelinput) AND cardinput.cardid = capturecard.cardid
AND ca
pturecard.cardid = 2(cardid) AND capturecard.hostname = pvr(HostName)
Error, couldn't find any available channels.
Your database is most likely setup incorrectly.
2004-01-28 21:23:09 Changing from WatchingLiveTV to None

Output of mythfrontend:
------------------------
Xlib:  extension "GLX" missing on display ":0.0".
Xlib:  extension "GLX" missing on display ":0.0".
2004-01-28 21:21:52 mythfrontend version: 0.14.20040114-1 www.mythtv.org
2004-01-28 21:21:52 Enabled verbose msgs : important general
2004-01-28 21:21:53 Registering Internal as a media playback plugin.
2004-01-28 21:22:06 Connecting to backend server: 127.0.0.1:6543 (try 1 of
5)
Input #0, mpeg, from
'rbuf://127.0.0.1:6543/home/content/myth-live/ringbuf2.nuv'
:
  Stream #0.0: Video: mpeg2video, 720x576, 25.00 fps
  Stream #0.1: Audio: mp2, 48000 Hz, stereo, 384 kb/s
2004-01-28 21:22:08 Opening OSS audio device '/dev/dsp'.
***
* Couldn't find Xv support, falling back to non-Xv mode.
* MythTV performance will be much slower since color
* conversion and scaling will be done in software.
* Consider upgrading your video card or X server if
* you would like better performance.
2004-01-28 21:22:10 Changing from None to WatchingLiveTV
QDateTime::fromString: Parameter out of range
QDateTime::fromString: Parameter out of range
QDateTime::fromString: Parameter out of range
QDateTime::fromString: Parameter out of range
QDateTime::fromString: Parameter out of range
QDateTime::fromString: Parameter out of range
QDateTime::fromString: Parameter out of range
QDateTime::fromString: Parameter out of range
***
* Your system is not capable of displaying the
* full framerate at 800x600 resolution.  Frames
* will be skipped in order to keep the audio and
* video in sync.
2004-01-28 21:23:09 Changing from WatchingLiveTV to None
2004-01-28 21:23:09 Changing from None to None