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

[spam]

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