[mythtv] Bug in tv_rec.cpp (TVRec::GetStartChannel)

[Mika Orajärvi]

Hi,
I got it working. And it was after all a settings-issue. A bit strange
though,.. since I had to go to capture card setup -> DiSEqC and change
the default input to "DVBInput". I've never before touched any DiSEqC
settings since I assumed that those involve only DVB-S guys. But for
some reason the default value for the default input was "Television" not
"DVBInput". I guess it's not a bug?


br,
Mika


On Wed, 2005-11-23 at 06:29 -0800, spam wrote:
> Michael T. Dean wrote:
> 
> > Mika Orajärvi wrote:
> >
> >> I think there's some bugs in the mentioned file and function regarding
> >> the names of the mysql tables/entries. I'm using the mythtv svn.
> >>
> >> The problems appeared after I wiped the DB clean and run the setup
> >> again.
> >>
> >> In the mysql query:
> >>
> >> ----
> >> query.prepare(
> >>        "SELECT startchan "
> >>        "FROM capturecard, cardinput "
> >>        "WHERE capturecard.cardid = cardinput.cardid AND "
> >>        "      capturecard.cardid = :CARDID          AND "
> >>        "      inputname          = :INPUTNAME");
> >>
> >> ---
> >>
> >> I think the "inputname" should be "defaultinput". That's at least found
> >> in the DB. After I changed the name, mythbackend found the starting
> >> channel correctly.
> >>  
> >>
> > inputname is a valid column in the cardinput table, and, therefore, 
> > should be found by that query:
> >
> > mysql> SELECT startchan
> >    ->   FROM capturecard, cardinput
> >    ->  WHERE capturecard.cardid = cardinput.cardid AND
> >    ->        capturecard.cardid = 1 AND        ->        
> > inputname          = 'S-Video 0';
> > +-----------+
> > | startchan |
> > +-----------+
> > | 238       |
> > +-----------+
> > 1 row in set (0.00 sec)
> >
> > I'll bet you looked for it in the capturecard table...  ;)
> >
> >> But there's probably another bug somewhere (haven't found that yet)
> >> since LiveTv does not start. Backend gives the following log:
> >>
> >> ----
> >> TVRec(1) Error: Channel: '1' was not found in the database.
> >>                        Most likely, your DefaultTVChannel setting is
> >> wrong.
> >>                        Could not start livetv.
> >> ----
> >>
> >> Shall I make a ticket?
> >>  
> >>
> > No.  Fix your config.  ;)  (Or, at least, not yet.  First verify that 
> > your config is correct.)
> >
> > Make sure you provide a valid value for every input you have 
> > associated with a video source.
> >
> > Starting LiveTV channel.
> > This is updated on every successful channel change.
> >
> > Oh, and make sure you change your code back before testing.  Using 
> > defaultinput breaks the query.
> >
> > Mike
> > _______________________________________________
> > mythtv-dev mailing list
> > mythtv-dev at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
> >
> >
> >
> > !DSPAM:43840765208926491211187!
> 
> In my case I had a HD3000 card in the machine then added a air2pc card. 
> The 3000 would setup and tune ok, but the new card only received a '' 
> for the channel from the database. I then removed all cards in 
> mythtv-setup and reconfig'd them both. Now both cards have no starting 
> channel.
> 
> Starting up as the master server.
> 2005-11-23 06:13:04.293 New DB connection, total: 2
> 2005-11-23 06:13:04.300 mythbackend: MythBackend started as master server
> 2005-11-23 06:13:04.359 TVRec(1) Error: Start channel '' invalid, 
> setting to '222' on input DVBInput instead.
> 2005-11-23 06:13:04.364 DVB#0 Using DVB card 0, with frontend 'Oren 
> OR51132 VSB/QAM Frontend'.
> 2005-11-23 06:13:04.384 New DB connection, total: 3
> 2005-11-23 06:13:04.404 TVRec(2) Error: Start channel '' invalid, 
> setting to '222' on input DVBInput instead.
> 2005-11-23 06:13:04.444 DVB#1 Using DVB card 1, with frontend 'Broadcom 
> BCM3510 VSB/QAM frontend'.
> 
> 
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev