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

Jay Camp campjr at verizon.net
Sat Dec 13 10:06:31 EST 2003


I'm running mysql-4.0.14 with readline, tcpd, ssl, and perl as compile
options.

The update works perfectly.

Thanks Isaac.


----- Original Message ----- 
From: "matt" <matthew at imisssleep.com>
To: "Discussion about mythtv" <mythtv-users at mythtv.org>
Sent: Saturday, December 13, 2003 4:52 AM
Subject: Re: [mythtv-users] TV image gone bad on .13 (when I
reallywantNTSC...)


> ----- 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.
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>



More information about the mythtv-users mailing list