[mythtv-users] Re: Frequencies ruined after tv_grab_na_dd 0.14
Romain Kang
romain at kzsu.stanford.edu
Wed May 26 20:54:25 EDT 2004
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);
On Wed, May 26, 2004 at 11:25:19AM -0700, Peter Sebastian Masny wrote:
> On Tuesday 25 May 2004 03:34 pm, William Powers wrote:
> > That's what the database looks like when you run tv_grab_na_dd without
> > using the '--old-chan-id' option. And it is '--old-chan-id', not
> > '--old_chan_id', so that may be the reason.
>
> I ran
> tv_grab_na_dd --output tmp --days 10 --old-chan-id
> re-emptied my tables with mythtv-setup, and
> mythfilldatabase --file 1 -1 tmp
>
> Result: Same channel table and video card unable to tune:
> +--------+---------+--------+----------+----------+------------+------+----------+--------------+-----------------------+-------------+----------+------------+--------+-------+----------+
> | chanid | channum | freqid | sourceid | callsign | name | icon | finetune | videofilters | xmltvid | recpriority | contrast | brightness | colour | hue | tvformat |
> +--------+---------+--------+----------+----------+------------+------+----------+--------------+-----------------------+-------------+----------+------------+--------+-------+----------+
> | 1002 | 2 KCB | 2 KCB | 1 | | 2 KCBS | | 0 | NULL | C2kcbs.zap2it.com | 0 | 32768 | 32768 | 32768 | 32768 | |
> | 1003 | 3 CAL | 3 CAL | 1 | | 3 CALCHAN | | 0 | NULL | C3calchan.zap2it.com | 0 | 32768 | 32768 | 32768 | 32768 | |
>
>
> > The easiest way to recover is to drop your database and restore from the
> > backup you made before you did it.
>
> Well, that is the problem. I was being a little optimistic when I started this
> endeavor. No backups. Living on the EDGE!! ;)
>
> Anyway, I have no idea why the channel table is not re-populating with
> appropriate freq values. I guess what I need is to know what the freqid
> values should look like for "us-cable" and do it by hand. Maybe a kind
> soul could send me a dump, or a link to something describing the
> appropriate values?
>
>
> Thank you for your help,
>
> Peter
> _______________________________________________
> 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