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

[Romain Kang]

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