[mythtv-users] TV image gone bad on .13 (when I really want NTSC...)

[Isaac Richards]

On Saturday 13 December 2003 12:58 am, Anthony Joint wrote:
> mysql> select * from channel;

What broken version of mysql are you all using?  The tvformat column is 
defined as not null with a default of 'Default' (correctly, as your dump of 
the channel table description shows), yet in this data dump, they're all 
null.  Should've filled it in properly when the column was added.  Weird.  Ah 
well, the following _should_ fix it:

update channel set tvformat = 'Default' where tvformat = '';

Or just wait for me to put that into CVS tomorrow sometime.

Isaac