[mythtv-users] Hide encrypted dvb channels.

[Stephen Worthington]

On Wed, 11 May 2016 18:57:03 +0200, you wrote:

>"Hika van den Hoven" <hikavdh at gmail.com>:
>> > Setting visible=0 has always worked fine for me. The only thing I
>> > miss is an automatic way to test decryption and set visible=0 for
>channels not decryptable.
>> > Manually tuning channels and update the channels accordingly has kept
>me up many nights...
>>
>> You can use the channelscan_channel table, but you have to filter it
>> on the scanid. This scanid links it to the channelscan table where
>> you'll find scandate, sourceid etc. It also links to the
>> channelscan_dtv_multiplex table.
>
>I deleted all channels (via channel editor in mythtv-setup) and TRUNCATE
>the channelscan_channel in mysql before doing a new scan. I thought this
>would give me a clean start, but maybe I should have deleted the sources to
>make sure all channels where deleted completely?
>
>
>If you see my first post in this thread, you see that the thing that
>puzzled me was that I found some service_id/mplex_id that were only in
>channels table and not in channelscan_channel table...

The channelscan_* tables I believe are only the results of the most
recent scans - I think they are cleaned out at some point.  Channels
can be in the channel table from previous scans, but not be in a new
scan, which could be from a different source.