[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