[mythtv] serviceid in channel db size bug

Kevin Lee leek at comp.lancs.ac.uk
Sun Mar 20 11:53:28 UTC 2005


I've been having problems for ages now with certain dvb-s channels from 
Astra 28.8E.
I finally figured it out today.  The "serviceid" column in "channel" 
has a max size of 32768, but a lot of channels have serviceid of 52515, 
52505 etc...

As soon as i perfomed:

"alter table channel modify column serviceid mediumint unsigned;"

and performed a dvb rescan (mythtv current cvs), all my channels worked.

So the default data type for this column should probably be changed to 
something more appropriate in cvs...



More information about the mythtv-dev mailing list