[mythtv-users] Re: Frequencies ruined after tv_grab_na_dd 0.14

[Peter Sebastian Masny]

On Wednesday 26 May 2004 05:54 pm, Romain Kang wrote:
> OK, another MySQL incantation seems to be in order.  As before, the
> paranoud should save the channel table before applying this, in
> case something weird happens:
>
> UPDATE channel SET freqid=SUBSTRING_INDEX(freqid, ' ', 1);
> UPDATE channel SET channum=SUBSTRING_INDEX(channum, ' ', 1);
> UPDATE channel SET callsign=SUBSTRING_INDEX(name, ' ', -1);

Thank you, Romain, and William Powers.  The fix worked perfectly.

Peter