[mythtvnz] Moment of insanity

[toby at np.co.nz]

>It sounds like the guide data is saying program X is on channel Y but
>channel Y doesn't actually exist. Can you do a dump of the channel table
for
>one of the channels?

Yes, I thought this for a while as well, its odd it was working pre-upgrade
and as a precaution I have blown away all my channels and started again but
still get the same thing, in case I have done something stupid though, here
is a dump of all the relevant tables....


mysql> select * from channel where channum = 11;
+--------+---------+--------+----------+----------+------+------+----------+
--------------+-------------+-------------+----------+------------+--------+
-------+----------+---------+---------------+---------------+---------+-----
------+----------+-----------------+-----------------+---------------------+
-------------------+------------+
| chanid | channum | freqid | sourceid | callsign | name | icon | finetune
| videofilters | xmltvid     | recpriority | contrast | brightness | colour
| hue   | tvformat | visible | outputfilters | useonairguide | mplexid |
serviceid | tmoffset | atsc_major_chan | atsc_minor_chan | last_record     
| default_authority | commmethod |
+--------+---------+--------+----------+----------+------+------+----------+
--------------+-------------+-------------+----------+------------+--------+
-------+----------+---------+---------------+---------------+---------+-----
------+----------+-----------------+-----------------+---------------------+
-------------------+------------+
|     11 | 11      | 11     |        1 | E!       | E!   |      |        0
|              | e.sky.co.nz |           0 |    32768 |      32768 |  32768
| 32768 |          |       1 |               |             0 |       0 |   
0 |        0 |               0 |               0 | 2010-05-12 15:45:07 |   
|         -1 |
+--------+---------+--------+----------+----------+------+------+----------+
--------------+-------------+-------------+----------+------------+--------+
-------+----------+---------+---------------+---------------+---------+-----
------+----------+-----------------+-----------------+---------------------+
-------------------+------------+




mysql> select * from videosource;
+----------+------+--------------+--------+-----------+----------+----------
+--------+------------+------------+
| sourceid | name | xmltvgrabber | userid | freqtable | lineupid | password
| useeit | configpath | dvb_nit_id |
+----------+------+--------------+--------+-----------+----------+----------
+--------+------------+------------+
|        1 | sky  | /bin/true    |        | default   | NULL     | NULL    
|      0 | NULL       |         -1 |
|        2 | dvb  | /bin/true    |        | default   | NULL     | NULL    
|      0 | NULL       |         -1 |
+----------+------+--------------+--------+-----------+----------+----------
+--------+------------+------------+




mysql> select * from cardinput where cardid=14;
+-------------+--------+----------+-----------+-----------------------------
+-----------+----------+-----------+-------------+-------------+------------
-+-----------+
| cardinputid | cardid | sourceid | inputname | externalcommand            
| shareable | tunechan | startchan | displayname | dishnet_eit |
recpriority | quicktune |
+-------------+--------+----------+-----------+-----------------------------
+-----------+----------+-----------+-------------+-------------+------------
-+-----------+
|          14 |     14 |        1 | S-Video 1 | /home/millst/change_chan.sh
| N         | NULL     | 11        | sky         |           0 |         
-1 |         0 |
+-------------+--------+----------+-----------+-----------------------------
+-----------+----------+-----------+-------------+-------------+------------
-+-----------+




mysql> select * from capturecard where cardid = 14;
+--------+-------------+-------------+-----------+----------+--------------+
----------------+----------+--------------+--------------+------------------
-----+-------------+---------------+-----------------+----------------+-----
-----------+---------------------+----------------+-----------------+-------
-----------+----------+------------+--------+-----+----------+-------------+
| cardid | videodevice | audiodevice | vbidevice | cardtype | defaultinput
| audioratelimit | hostname | dvb_swfilter | dvb_sat_type |
dvb_wait_for_seqstart | skipbtaudio | dvb_on_demand | dvb_diseqc_type |
firewire_speed | firewire_model | firewire_connection | signal_timeout |
channel_timeout | dvb_tuning_delay | contrast | brightness | colour | hue |
diseqcid | dvb_eitscan |
+--------+-------------+-------------+-----------+----------+--------------+
----------------+----------+--------------+--------------+------------------
-----+-------------+---------------+-----------------+----------------+-----
-----------+---------------------+----------------+-----------------+-------
-----------+----------+------------+--------+-----+----------+-------------+
|     14 | /dev/video0 | /dev/dsp    | /dev/vbi0 | V4L      | S-Video 1   
|              0 | mythtv   |            0 |            0 |                
1 |           0 |             0 |            NULL |              0 | NULL  
|                   0 |           1000 |            3000 |                0
|        0 |          0 |      0 |   0 |     NULL |           1 |
+--------+-------------+-------------+-----------+----------+--------------+
----------------+----------+--------------+--------------+------------------
-----+-------------+---------------+-----------------+----------------+-----
-----------+---------------------+----------------+-----------------+-------
-----------+----------+------------+--------+-----+----------+-------------+









--------------------------------------------------------------------
mail2web - Check your email from the web at
http://link.mail2web.com/mail2web