[mythtv] Ticket #2041: LiveTV tuning broken for IVTV tuner between  and 
harley at hpeters.net
Tue Jul 11 19:52:30 UTC 2006
Michael Andersen wrote:
> Mark Buechler wrote:
>> 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.
> Yeah, I also had that odd channel sorting once I had run the latest svn
> version, and then reverting back to older revisions in order to pinpoint
> the location. (channel ordering 1,10,11 ... 19,2,20,21... etc) - and you
> may be right about the int/varchar thing. I didn't check, but it sounds
> logical to me.
> Anway, to follow up on Daniels work, I can tell that with rev 10473 the
> problem is fixed on my system. Channel up and down is working correctly
> again.Channel number ordering is also correct when channel surfing
> (up/down), also in EPG and channel browsing.
> Thank you for your help Daniel.
> PS. Harley Peters - I hope you don't feel, that I stole your thread - it
> kinda look like I did, sorry.
> I hope you got it solved too ;-)
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
No problem the more input the better.
Two of my three problems have been fixed. Daniel said he would look into
Thanks for the help Daniel !
This e-mail was scanned with a private,
non-commercial version of AntiVir MailGate.
See http://www.antivir.de for details.
More information about the mythtv-dev