[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