[mythtv-users] Data Direct Error, Rogers Cable Toronto or Internal Mythtv Table Error???

R. G. Newbury newbury at mandamus.org
Fri Aug 18 18:05:52 UTC 2006


Jim O'Neill wrote:
> R. G. Newbury wrote:
>> I'm getting an error with recordings which at first glance looks like it 
>> might originate with the Data Direct data. But that makes no sense.
>> This is analog cable recorded using a PVR-500.
>> Here is the channel table data:
<SNIP>>>
>> mysql> select * from channel where channum = '17' or channum = '61';
>> +--------+---------+--------+----------+----------+------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+
>> | chanid | channum | freqid | sourceid | callsign | name | icon | 
>> finetune | videofilters | xmltvid | recpriority | contrast | brightness 
>> | colour | hue   | tvformat | commfree | visible | outputfilters | 
>> useonairguide | mplexid | serviceid | atscsrcid | tmoffset | 
>> atsc_major_chan | atsc_minor_chan |
>> +--------+---------+--------+----------+----------+------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+
>> |   1017 | 17      | 17     |        1 | WGRZ     | WGRZ | none | 
>> NULL |              | 11484   |           0 |    32768 |      32768 | 
>> 32768 | 32768 | Default  |        0 |       1 |               | 
>>      0 |    NULL |      NULL |      4352 |        0 |              17 | 
>>                0 |
>> |   1061 | 61      | 61     |        1 | WNED     | WNED |      | 
>> NULL |              | 11709   |           0 |    32768 |      32768 | 
>> 32768 | 32768 | Default  |        0 |       1 |               | 
>>      0 |   32767 |         0 |     15616 |        0 |              61 | 
>>                0 |
>> <SNIP>

>> All WAG's gratefully accepted.
>>
>> Geoff
>>   
> Geoff, i doubt i can help but could you confirm something?  Do you have 
> two capture cards configured in myth as is implied by "if I set 2 
> simultaneous recordings"?  If yes, shouldn't channel 17 at minimum have 
> shown up twice as output from your select statement?   Jim

I have 2 analog tuners in a PVR500 card.

No I would not get channel 17 listed twice. This is the channel table, 
which lists the information relating to a single channel.
Each capturecard has certain information, relating to its physical 
characteristics. One of its characteristics is the sourceid which it 
receives. Multiple cards can 'see' the same sourceid, but no card should 
'see' on a sourceid any channel which it cannot actually receive. 
Following usual relational database standards, information is only 
entered once. So I get one listing for channel 17.

SOLVED
The listing given above was from the copy of the mythconverg database on 
this computer, my desktop at work. This database was set up as a copy of 
the one at home, with only the IP address of the mysql server changed. I 
use this end to download listings and transfer them home on a usb key 
using a limited mysqldump.

The database at home became corrupted somehow and both the freqid and 
the  atsc_major_chan entry for channel 61 had '17' as their value. 
Obviously the freqid id of '17' caused myth to tune to the actual wrong 
channel, even though all of the other information correctly related to 
channel 61 and the program I wanted to record. No wonder I was dazed and 
confused!

So how this happened, I have no idea, but it is now solved.

Geoff













-- 
        R. Geoffrey Newbury			
      Barrister and Solicitor
  Suite 106, 150 Lakeshore Road West
     Mississauga, Ontario, L5H 3R2

   905-271-9600  Fax 905-271-1638
        newbury at mandamus.org


More information about the mythtv-users mailing list