<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 21/10/2018 20:27, <a class="moz-txt-link-abbreviated" href="mailto:veehexx@zoho.com">veehexx@zoho.com</a>
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:1669817bac8.bfaf646954527.7631662188124999686@zoho.com">
<pre class="moz-quote-pre" wrap="">got round to doing this tonight. turns out it was just an existing transport edit so no major changes or full rescans needed. digitalspys freesat changelog gave the new details and a simple cas of editing the FEC from 2/3 to 3/4 for both the transports of BBC one and BBC four channels.</pre>
</blockquote>
<br>
A bit old I know, but most of my fecs are set to auto.....<br>
<br>
I usually hammer the database when I need to make changes...<br>
<br>
I have this text file to remind me...<br>
<br>
r<tt>oot@pxeboot:/backup/mythtv# cat fix_channel.txt</tt><tt><br>
</tt><tt>#Useful urls</tt><tt><br>
</tt><tt><a class="moz-txt-link-freetext" href="https://en.kingofsat.net/freqs.php?&pos=28.2E&standard=All&ordre=freq&filtre=no&aff=list">https://en.kingofsat.net/freqs.php?&pos=28.2E&standard=All&ordre=freq&filtre=no&aff=list</a></tt><tt><br>
</tt><tt><a class="moz-txt-link-freetext" href="https://www.lyngsat.com/Astra-2E-2F-2G.html">https://www.lyngsat.com/Astra-2E-2F-2G.html</a></tt><tt><br>
</tt><tt><br>
</tt><tt>#List chan details</tt><tt><br>
</tt><tt>select c.xmltvid, c.callsign, c.chanid, c.channum,
c.sourceid 'c.sourceid', dm.sourceid 'dm.sourceid', c.mplexid
'c.mplexid', dm.mplexid 'dm.mplexid', c.serviceid 'c.serviceid',
dm.transportid, dm.frequency, dm.inversion, dm.symbolrate, dm.fec,
dm.polarity, dm.modulation, dm.networkid from channel c,
dtv_multiplex dm where c.mplexid = dm.mplexid and name like
'%???%';</tt><tt><br>
</tt><tt><br>
</tt><tt>#if nothing returned then the multiplex is probably missing
- this is probably better</tt><tt><br>
</tt><tt>select c.xmltvid, c.callsign, c.chanid, c.channum,
c.sourceid 'c.sourceid', dm.sourceid 'dm.sourceid', c.mplexid
'c.mplexid', dm.mplexid 'dm.mplexid', c.serviceid 'c.serviceid',
dm.transportid, dm.frequency, dm.inversion, dm.symbolrate, dm.fec,
dm.polarity, dm.modulation, dm.networkid from channel c left join
dtv_multiplex dm on c.mplexid = dm.mplexid where name like
'%???%';</tt><tt><br>
</tt><tt><br>
</tt><tt>#May need to add a new row into dtv_multiplex</tt><tt><br>
</tt><tt>select
mplexid,sourceid,transportid,networkid,frequency,inversion,symbolrate,fec,polarity,modulation,sistandard
from dtv_multiplex where frequency=???;</tt><tt><br>
</tt><tt>select
mplexid,sourceid,transportid,networkid,frequency,inversion,symbolrate,fec,polarity,modulation,sistandard
from dtv_multiplex order by frequency;</tt><tt><br>
</tt><tt><br>
</tt><tt>#To insert a new frequency - needs to be done twice, for 3
and 5 sourceid's</tt><tt><br>
</tt><tt>insert into dtv_multiplex
(sourceid,transportid,networkid,frequency,symbolrate,polarity)values(5,???,2,???,???,'?');</tt><tt><br>
</tt><tt><br>
</tt><tt><br>
</tt><tt>#Then usually you need to alter the channel tables</tt><tt><br>
</tt><tt>select xmltvid, name, c.callsign, c.chanid, c.channum,
c.sourceid, c.mplexid, c.serviceid from channel c where name like
'%??%';</tt><tt><br>
</tt><tt>update channel set mplexid=??? where chanid=???;</tt><tt><br>
</tt><tt>update channel set serviceid=??? where chanid in (???,???);</tt><tt><br>
</tt><tt><br>
</tt><tt>#duplicate a channel row</tt><tt><br>
</tt><tt>CREATE table x SELECT * FROM channel where chanid=???'</tt><tt><br>
</tt><tt>select chanid from channel order by chanid limit 5;</tt><tt><br>
</tt><tt>update x set chanid=???, chanid=???;</tt><tt><br>
</tt><tt>INSERT INTO channel select * from x;</tt><tt><br>
</tt><tt>drop table x;</tt><br>
<pre class="moz-signature" cols="72">--
'ooroo
Stinga...(:)-)
---------------------------------------------------
Email: <a class="moz-txt-link-abbreviated" href="mailto:stinga+mythtv@wolf-rock.com">stinga+mythtv@wolf-rock.com</a> o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------</pre>
</body>
</html>