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

[Anthony Joint]

/usr/libexec/mysqld  Ver 3.23.56 for redhat-linux-gnu on i386

On Sat, 13 Dec 2003, Jay Camp wrote:

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