<div dir="ltr"><div>Is the transport editor available in Myth 30? I poked around some in mythtv-setup before my database modifications, and I didn't see anything but the option to do a whole new scan.</div><div><br></div><div>For others in the SF Bay Area, <a href="https://sfbayatsc.koherence.com/">https://sfbayatsc.koherence.com/</a> current lead article lists a number of stations that dropped their old frequencies on March 9.</div><div>In addition to channel 2, channel 60 and a grab bag of channels (38, 42, and 50) all associated with one mplex and freqid 39, which is now 32, changed.</div><div>I seem to have deleted that last batch (they do show up in my recent channel scan), but I did have 60, and was unable to tune to it.</div><div><br></div><div>Here's a transcript of my changes. After doing this, I get a viewable picture on 60 again.</div><div><br></div><div>-- next day I learn of other changes: <a href="https://sfbayatsc.koherence.com/">https://sfbayatsc.koherence.com/</a><br>select * from channel where atsc_major_chan = 60;<br>+--------+---------+--------+----------+----------+---------+---------------------+----------+--------------+----------------------------------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+<br>| chanid | channum | freqid | sourceid | callsign | name | icon | finetune | videofilters | xmltvid | recpriority | contrast | brightness | colour | hue | tvformat | visible | outputfilters | useonairguide | mplexid | serviceid | tmoffset | atsc_major_chan | atsc_minor_chan | last_record | default_authority | commmethod | iptvid |<br>+--------+---------+--------+----------+----------+---------+---------------------+----------+--------------+----------------------------------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+<br>| 26001 | 60_1 | 43 | 2 | KPJKHD | KPJKHD | | NULL | | <a href="http://I35545.json.schedulesdirect.org">I35545.json.schedulesdirect.org</a> | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 1 | | 1 | 12 | 3 | 0 | 60 | 1 | 2020-02-10 00:58:00 | | -1 | NULL |<br>| 26002 | 60_2 | 43 | 2 | PJKF24 | PJKF24 | s70130_ll_h3_aa.png | NULL | | <a href="http://I35547.json.schedulesdirect.org">I35547.json.schedulesdirect.org</a> | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 1 | | 1 | 12 | 4 | 0 | 60 | 2 | 0000-00-00 00:00:00 | | -1 | NULL |<br>| 26006 | 60_6 | 43 | 2 | PJKJAZZ | PJKJAZZ | | NULL | | <a href="http://I113467.json.schedulesdirect.org">I113467.json.schedulesdirect.org</a> | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 1 | | 1 | 12 | 8 | 0 | 60 | 6 | 0000-00-00 00:00:00 | | -1 | NULL |<br>+--------+---------+--------+----------+----------+---------+---------------------+----------+--------------+----------------------------------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+<br>3 rows in set (0.052 sec)<br><br>select * from dtv_multiplex where mplexid=12;<br>MariaDB [mythconverg]> +---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+-----------+---------+------------+----------------+---------------------+-------------------+<br>| mplexid | sourceid | transportid | networkid | frequency | inversion | symbolrate | fec | polarity | modulation | bandwidth | lp_code_rate | transmission_mode | guard_interval | visible | constellation | hierarchy | hp_code_rate | mod_sys | rolloff | sistandard | serviceversion | updatetimestamp | default_authority |<br>+---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+-----------+---------+------------+----------------+---------------------+-------------------+<br>| 12 | 2 | 411 | NULL | 647000000 | a | 0 | auto | v | 8vsb | a | auto | a | auto | 0 | 8vsb | a | auto | UNDEFINED | 0.35 | atsc | 33 | 2019-04-27 08:09:22 | |<br>+---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+-----------+---------+------------+----------------+---------------------+-------------------+<br>1 row in set (0.001 sec)<br><br>-- channel 60 is now SCANNING: 551000000 (us-bcast:27)<br>update channel set freqid=27 where atsc_major_chan=60; --as noted in this thread, freqid is informational only<br>MariaDB [mythconverg]> Query OK, 3 rows affected (0.002 sec)<br>Rows matched: 3 Changed: 3 Warnings: 0<br><br>update dtv_multiplex set frequency=551000000 where mplexid=12;<br>MariaDB [mythconverg]> Query OK, 1 row affected (0.001 sec)<br>Rows matched: 1 Changed: 1 Warnings: 0</div><div><br></div><div>--------------------------------------------------------------</div><div>-- various channels KCNS/KTNC/KEMO SCANNING: 581000000 (us-bcast:32)<br>select * from channel where freqid=39; --39 was old value<br>MariaDB [mythconverg]> Empty set (0.001 sec)<br><br>select * from channel where atsc_major_chan in (38, 42, 50);<br>MariaDB [mythconverg]> Empty set (0.000 sec)</div><div><br></div><div>Ross<br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Mar 11, 2020 at 2:00 AM Klaas de Waal <<a href="mailto:klaas.de.waal@gmail.com">klaas.de.waal@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, 11 Mar 2020 at 09:19, Stephen Worthington <<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Tue, 10 Mar 2020 19:27:24 -0700, you wrote:<br>
<br>
>I just ran into the same problem. I too wonder if there is some automatic<br>
>way to do a rescan; in the past I've noticed when I scan channels lots of<br>
>other stuff of I've done needs to be redone (e.g., picking the subset of<br>
>interest). FWIW, omitting the rather confused process of figuring out what<br>
>was going on, these were the steps:<br>
>1. hdhomerun_config MyTunerID scan 0<br>
>Results include<br>
>SCANNING: 575000000 (us-bcast:31)<br>
>LOCK: 8vsb (ss=100 snq=93 seq=100)<br>
>TSID: 0x0141<br>
>PROGRAM 3: 2.1 KTVU-HD<br>
>PROGRAM 4: 2.2 KTVU-SD<br>
>PROGRAM 5: 2.3 Movies!<br>
>PROGRAM 6: 2.4 Buzzr<br>
><br>
>The key items are from the line SCANNING: 575000000 (us-bcast:31)<br>
><br>
>2. In the database find the relevant entries in channels; change freqid to<br>
>31 there for atsc_major_chan = 2<br>
>Those records also have an mplexid which can be used to locate a record (I<br>
>had just one) in dtv_multiplex.<br>
><br>
>3. update dtv_multiplex set frequency=575000000 where mplexid=13;<br>
><br>
>2 alone was insufficient.<br>
><br>
>I know directly messing with the database is frowned on, but it seemed to<br>
>work for me.<br>
><br>
>Ross<br>
<br>
The channel.freqid values are not used for digital TV such as DVB-T<br>
and ATSC. What matters is that the channel.mplexid points to a<br>
dtv_multiplex entry with the correct dtv_multiplex.frequency value.<br>
Having the freqid value set correctly is only for humans looking at<br>
the database, so it should either be set correctly, or if it is not<br>
going to be kept set to the correct values, set to 0.<br>
_______________________________________________<br><br></blockquote><div>Figuring out what the problem is and modifying the database to solve your problem is great fun when it goes OK so enjoy! The flipside is of course that it can fail but that is life.</div><div><br></div><div>As Stephen says, the freqid values are not used anymore but they are still filled in when you do a scan across frequencies. If you would delete all channels and then do a "Scan of all transports" then the values are not filled in.</div><div><br></div><div>If you have figured out the old and the new frequency then you can also use the Transport Editor of mythtv-setup to change the frequency, see <a href="https://www.mythtv.org/wiki/Channel_Scanning#Transport_Editor" target="_blank">https://www.mythtv.org/wiki/Channel_Scanning#Transport_Editor</a></div><div><br></div><div>Changing the frequency only works if all the bits inside the transport stream such as the service ID stay the same which appears to be the case here.</div><div>Starting with mythtv v31, if you do a scan on the new frequency like Allen has done then the channel would have been updated, identified by the major and minor channel numbers. For older versions you first have to delete the old channels as Allen has done, or, even better, first delete the old transport with the Transport Editor which then also deletes all the channels of that transport.</div><div><br></div><div>It would have been much easier if you just can do a "Full Scan" and let mythtv-setup sort everything out. The problem, as described by Alan, is that the same transport stream can be received from different transmitters on different frequencies with as result that the scanner finds duplicate channels. To be continued...</div><div><br></div><div>Klaas.</div><div><br></div><div><br></div><div><br></div><div> </div></div></div>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote></div>