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

[matt]

----- Original Message ----- 
From: "Isaac Richards" <ijr at po.cwru.edu>
To: "Discussion about mythtv" <mythtv-users at mythtv.org>
Sent: Saturday, December 13, 2003 3:54 AM
Subject: Re: [mythtv-users] TV image gone bad on .13 (when I really
wantNTSC...)


> 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
> _______________________________________________

I am running MySQL version 4.0.11.

I applied this query. Everything works super terrific.

Thanks.