[mythtv-users] MythWeb Update REcording schedule does not work

Chris Isip cmisipster at gmail.com
Sun Apr 15 17:57:09 UTC 2007


I think you're right.  I seem to have three channels of everything when I
should only have two since  I have a digital listing and an analog listing.

mysql> SELECT channum, callsign, name FROM channel where name like "%Disney
Channel%";
+---------+----------+----------------+
| channum | callsign | name           |
+---------+----------+----------------+
| 52      | DISN     | Disney Channel |
| 52      | DISN     | Disney Channel |
| 52      | DISN     | Disney Channel |
+---------+----------+----------------+
3 rows in set (0.00 sec)

Can't I simply delete the channels for a particular list. I noticed that a
particular set of channels is prefixed with a 10 or 20 or 30 in chanid? But
which one.


| chanid | channum | sourceid | callsign | name           | icon | finetune
| videofilters | xmltvid | contrast | brightness | colour | recpriority |
hue   | freqid | tvformat | commfree | visible | outputfilters |
useonairguide | mplexid | serviceid | atscsrcid | tmoffset | atsc_major_chan
| atsc_minor_chan |
+--------+---------+----------+----------+----------------+------+----------+--------------+---------+----------+------------+--------+-------------+-------+--------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+
|   1052 | 52      |        1 | DISN     | Disney Channel |      |     NULL
|              | 10171   |    32768 |      32768 |  32768 |           0 |
32768 | 52     | Default  |        0 |       1 |               |
0 |   32767 |         0 |     13312 |        0 |              52
|               0 |
|   2052 | 52      |        2 | DISN     | Disney Channel |      |     NULL
|              | 10171   |    32768 |      32768 |  32768 |           0 |
32768 | 52     | Default  |        0 |       1 |               |
0 |   32767 |         0 |     13312 |        0 |              52
|               0 |
|   3052 | 52      |        3 | DISN     | Disney Channel |      |     NULL
|              | 10171   |    32768 |      32768 |  32768 |           0 |
32768 | 52     | Default  |        0 |       1 |               |
0 |   32767 |         0 |     13312 |        0 |              52
|               0 |
+--------+---------+----------+----------+----------------+------+----------+--------------+---------+----------+------------+--------+-------------+-------+--------+------


Thanks



On 4/15/07, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>
> On 04/15/2007 01:34 PM, Chris Isip wrote:
> > Is there an sql query to list these phantom channels? I use zap2it for
> > listings by the way.
>
> Easiest approach is probably:
>
> SELECT COUNT(*) FROM channel;
>
> and compare it to the number of channels you think you have.  You could
> also just do a "SELECT channum, callsign, name FROM channel;" and look
> it over.
>
> The best way to verify what you have (for video sources, input
> connections, and channels) is correct is
> http://www.gossamer-threads.com/lists/mythtv/users/261405#261405 (only
> the "Delete All" part if you're using analog--and don't do a channel
> scan for analog--use "Fetch channels from listings provider" or whatever).
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070415/dc032294/attachment.htm 


More information about the mythtv-users mailing list