[mythtv] channel.freqid too short for real frequencies

J. Donavan Stanley jdonavan at jdonavan.net
Thu Aug 19 16:18:06 EDT 2004

Mark Spieth wrote:

> looking through and wanting to make a unique freq mapping to channel 
> numbers
> I noticed that the freq is only 5 chars long in the db. (channel table)
> since these numbers are in kHz this would require at least 6 chars for 
> terrestrial and
> cable and perhaps 7 for sat to reperesent numbers >= 100MHz == 100000kHz
> easy fix. whoever maintains the db consistency should do this one. 
> thus no patch is provided.
> temp fix is to use phpmyadmin or command line to change it explicitly 
> to VARCHAR(7)
> cheers mark

You're a little late:

Changes committed by ijr on Thu Aug 19 05:14:22 2004

Modified Files:
   in mythtv/libs/libmythtv:
        channel.cpp dbcheck.cpp 
Log Message:
Fix bug in initial input selection, pointed out by Andy McMullan.
Increase the size of freqid in the db.

More information about the mythtv-dev mailing list