[mythtv] Ticket #2041: LiveTV tuning broken for IVTV tuner between [10390] and [10402]

Harley Peters 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 ;-)
> /Michael
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev

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 mailing list