[mythtv-users] Re: Frequencies ruined after tv_grab_na_dd 0.14
Peter Sebastian Masny
ps-list at masny.dk
Thu May 27 01:51:33 EDT 2004
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
More information about the mythtv-users
mailing list