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.
<br><br>- Mark.<br><br><div><span class="gmail_quote">On 7/10/06, <b class="gmail_sendername">Harley Peters</b> <<a href="mailto:harley@hpeters.net">harley@hpeters.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Daniel Kristjansson wrote:<br>> On Mon, 2006-07-10 at 21:04 -0500, Harley Peters wrote:<br>><br>>> First i have some channels that i have turned visibility off so they<br>>> don't show up. They used to not show up when using the channel up and
<br>>> down keys now they do.<br>> Hmmm, I'll check this out.<br>><br>>> Also the order that the dvb channels show up in the program guide has<br>>> some what been scrambled.<br>>> I have my dvb channels set to what the cable company has given them. Example
<br>>> 910 911 913<br>> <snip><br>><br>> Those are not DVB channels, they are ATSC channels. They are probably<br>> being put in their proper places in the lineup according to where the<br>> Broadcaster & FCC said they should go... I can fix this, but could you
<br>> send me the:<br>> select channum, atsc_major_chan, atsc_minor_chan from channel;<br>> output first, so I can confim my suspicion without decoding the<br>> atscsrcid?<br>><br>> -- Daniel<br>><br>
> _______________________________________________<br>> mythtv-dev mailing list<br>> <a href="mailto:mythtv-dev@mythtv.org">mythtv-dev@mythtv.org</a><br>> <a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev</a><br>><br><br>Channum.txt attached<br><br>Your right they are ATSC channels and where they are now being put is<br>where the Broadcaster & FCC say they should go.
<br>(913 is 4.1) (910 is 10.1) (911 is 10.2).<br><br>Harley<br><br>--<br>This e-mail was scanned with a private,<br>non-commercial version of AntiVir MailGate.<br>See <a href="http://www.antivir.de">http://www.antivir.de</a>
for details.<br><br><br>+---------+-----------------+-----------------+<br>| channum | atsc_major_chan | atsc_minor_chan |<br>+---------+-----------------+-----------------+<br>| 55 | 55 | 0 |
<br>| 41 | 41 | 0 |<br>| 16 | 16 | 0 |<br>| 66 | 66 | 0 |<br>| 27 | 27 | 0 |<br>| 26 | 26 | 0 |
<br>| 61 | 61 | 0 |<br>| 42 | 42 | 0 |<br>| 20 | 20 | 0 |<br>| 19 | 19 | 0 |<br>| 36 | 36 | 0 |
<br>| 49 | 49 | 0 |<br>| 15 | 15 | 0 |<br>| 31 | 31 | 0 |<br>| 28 | 28 | 0 |<br>| 52 | 52 | 0 |
<br>| 64 | 64 | 0 |<br>| 37 | 37 | 0 |<br>| 22 | 22 | 0 |<br>| 21 | 21 | 0 |<br>| 44 | 44 | 0 |
<br>| 45 | 45 | 0 |<br>| 60 | 60 | 0 |<br>| 59 | 59 | 0 |<br>| 33 | 33 | 0 |<br>| 58 | 58 | 0 |
<br>| 65 | 65 | 0 |<br>| 35 | 35 | 0 |<br>| 57 | 57 | 0 |<br>| 38 | 38 | 0 |<br>| 50 | 50 | 0 |
<br>| 32 | 32 | 0 |<br>| 54 | 54 | 0 |<br>| 56 | 56 | 0 |<br>| 47 | 47 | 0 |<br>| 68 | 68 | 0 |
<br>| 34 | 34 | 0 |<br>| 51 | 51 | 0 |<br>| 69 | 69 | 0 |<br>| 67 | 67 | 0 |<br>| 39 | 39 | 0 |
<br>| 71 | 71 | 0 |<br>| 25 | 25 | 0 |<br>| 43 | 43 | 0 |<br>| 24 | 24 | 0 |<br>| 29 | 29 | 0 |
<br>| 70 | 70 | 0 |<br>| 73 | 73 | 0 |<br>| 18 | 18 | 0 |<br>| 14 | 36 | 0 |<br>| 8 | 0 | 0 |
<br>| 23 | 23 | 0 |<br>| 913 | 4 | 1 |<br>| 910 | 10 | 1 |<br>| 911 | 10 | 2 |<br>| 10500 | 0 | 0 |
<br>| 9 | 0 | 0 |<br>| 5 | 0 | 0 |<br>| 6 | 0 | 0 |<br>| 13 | 0 | 0 |<br>| 10 | 0 | 0 |
<br>| 3 | 0 | 0 |<br>| 12 | 0 | 0 |<br>| 11 | 0 | 0 |<br>| 7 | 0 | 0 |<br>| 4 | 0 | 0 |
<br>| 17 | 0 | 0 |<br>| 46 | 0 | 0 |<br>| 10501 | 0 | 0 |<br>| 10502 | 0 | 0 |<br>| 10503 | 0 | 0 |
<br>| 10504 | 0 | 0 |<br>| 10505 | 0 | 0 |<br>| 10506 | 0 | 0 |<br>| 10507 | 0 | 0 |<br>| 10508 | 0 | 0 |
<br>| 10509 | 0 | 0 |<br>+---------+-----------------+-----------------+<br><br><br><br>_______________________________________________<br>mythtv-dev mailing list<br><a href="mailto:mythtv-dev@mythtv.org">
mythtv-dev@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev</a><br><br><br></blockquote></div><br>