[mythtv-users] Frequencies ruined after tv_grab_na_dd 0.14 backport attempt (remail)

[Peter Sebastian Masny]

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