[mythtv] Ticket #2041: LiveTV tuning broken for IVTV tuner between [10390] and [10402]
Mark Buechler
mark.buechler at gmail.com
Tue Jul 11 15:00:06 UTC 2006
I don't know if this has any baring on this problem but I noticed after
trying the mythtv-diseqc branch, and then went back again to 10285, all my
channels were ordered alphabetically instead of numerically, as also
represented in the sql statement "SELECT channum FROM channel ORDER BY
channum". This breaks channel up/down along with direct keying of the
channel number. I had thought that channel.channum had changed from int to
varchar which caused the new ordering but after looking back at 10285 I see
it was varchar there as well. The only thing I can think which MAYBE
(shooting at the hip here) could have caused this was if channel.channum was
at one point int and changed to varchar but mysql didn't reorder the index
until a recent alter was introduced for the atsc stuff. My solution was to
change the column definition for channum back to int(10) which again ordered
the column numerically.
- Mark.
On 7/10/06, Harley Peters <harley at hpeters.net> wrote:
>
> Daniel Kristjansson wrote:
> > On Mon, 2006-07-10 at 21:04 -0500, Harley Peters wrote:
> >
> >> First i have some channels that i have turned visibility off so they
> >> don't show up. They used to not show up when using the channel up and
> >> down keys now they do.
> > Hmmm, I'll check this out.
> >
> >> Also the order that the dvb channels show up in the program guide has
> >> some what been scrambled.
> >> I have my dvb channels set to what the cable company has given them.
> Example
> >> 910 911 913
> > <snip>
> >
> > Those are not DVB channels, they are ATSC channels. They are probably
> > being put in their proper places in the lineup according to where the
> > Broadcaster & FCC said they should go... I can fix this, but could you
> > send me the:
> > select channum, atsc_major_chan, atsc_minor_chan from channel;
> > output first, so I can confim my suspicion without decoding the
> > atscsrcid?
> >
> > -- Daniel
> >
> > _______________________________________________
> > mythtv-dev mailing list
> > mythtv-dev at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
> >
>
> Channum.txt attached
>
> Your right they are ATSC channels and where they are now being put is
> where the Broadcaster & FCC say they should go.
> (913 is 4.1) (910 is 10.1) (911 is 10.2).
>
> Harley
>
> --
> This e-mail was scanned with a private,
> non-commercial version of AntiVir MailGate.
> See http://www.antivir.de for details.
>
>
> +---------+-----------------+-----------------+
> | channum | atsc_major_chan | atsc_minor_chan |
> +---------+-----------------+-----------------+
> | 55 | 55 | 0 |
> | 41 | 41 | 0 |
> | 16 | 16 | 0 |
> | 66 | 66 | 0 |
> | 27 | 27 | 0 |
> | 26 | 26 | 0 |
> | 61 | 61 | 0 |
> | 42 | 42 | 0 |
> | 20 | 20 | 0 |
> | 19 | 19 | 0 |
> | 36 | 36 | 0 |
> | 49 | 49 | 0 |
> | 15 | 15 | 0 |
> | 31 | 31 | 0 |
> | 28 | 28 | 0 |
> | 52 | 52 | 0 |
> | 64 | 64 | 0 |
> | 37 | 37 | 0 |
> | 22 | 22 | 0 |
> | 21 | 21 | 0 |
> | 44 | 44 | 0 |
> | 45 | 45 | 0 |
> | 60 | 60 | 0 |
> | 59 | 59 | 0 |
> | 33 | 33 | 0 |
> | 58 | 58 | 0 |
> | 65 | 65 | 0 |
> | 35 | 35 | 0 |
> | 57 | 57 | 0 |
> | 38 | 38 | 0 |
> | 50 | 50 | 0 |
> | 32 | 32 | 0 |
> | 54 | 54 | 0 |
> | 56 | 56 | 0 |
> | 47 | 47 | 0 |
> | 68 | 68 | 0 |
> | 34 | 34 | 0 |
> | 51 | 51 | 0 |
> | 69 | 69 | 0 |
> | 67 | 67 | 0 |
> | 39 | 39 | 0 |
> | 71 | 71 | 0 |
> | 25 | 25 | 0 |
> | 43 | 43 | 0 |
> | 24 | 24 | 0 |
> | 29 | 29 | 0 |
> | 70 | 70 | 0 |
> | 73 | 73 | 0 |
> | 18 | 18 | 0 |
> | 14 | 36 | 0 |
> | 8 | 0 | 0 |
> | 23 | 23 | 0 |
> | 913 | 4 | 1 |
> | 910 | 10 | 1 |
> | 911 | 10 | 2 |
> | 10500 | 0 | 0 |
> | 9 | 0 | 0 |
> | 5 | 0 | 0 |
> | 6 | 0 | 0 |
> | 13 | 0 | 0 |
> | 10 | 0 | 0 |
> | 3 | 0 | 0 |
> | 12 | 0 | 0 |
> | 11 | 0 | 0 |
> | 7 | 0 | 0 |
> | 4 | 0 | 0 |
> | 17 | 0 | 0 |
> | 46 | 0 | 0 |
> | 10501 | 0 | 0 |
> | 10502 | 0 | 0 |
> | 10503 | 0 | 0 |
> | 10504 | 0 | 0 |
> | 10505 | 0 | 0 |
> | 10506 | 0 | 0 |
> | 10507 | 0 | 0 |
> | 10508 | 0 | 0 |
> | 10509 | 0 | 0 |
> +---------+-----------------+-----------------+
>
>
>
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20060711/13d74cf2/attachment.htm
More information about the mythtv-dev
mailing list