Mailing List Archive: MythTV: Users

need query to remove DVB transports

Index | Next | Previous | View Threaded

mythjoe at gmail

Dec 21, 2005, 10:19 PM

Post #1 of 6 (680 views)
Permalink

need query to remove DVB transports

How do I remove DVB transports? In an effort to get my air2pc (atsc
dvb) card working, I attempted to follow the directions posted at
http://www.digitalregime.com/mythdvb/setup/. Unfortunately step 4A is
out of date and I ended up adding a bunch of bogus transports. How
can I delete them? I've changed them all to be at 0Hz, so a WHERE
clause should be easy to formulate. I just don't know which table(s)
I need to hack on.
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

knowledgejunkie at gmail

Dec 22, 2005, 1:10 AM

Post #2 of 6 (647 views)
Permalink

Re: need query to remove DVB transports [In reply to]

On 22/12/05, joe byrne <mythjoe [at] gmail> wrote:
> How do I remove DVB transports? In an effort to get my air2pc (atsc
> dvb) card working, I attempted to follow the directions posted at
> http://www.digitalregime.com/mythdvb/setup/. Unfortunately step 4A is
> out of date and I ended up adding a bunch of bogus transports. How
> can I delete them? I've changed them all to be at 0Hz, so a WHERE
> clause should be easy to formulate. I just don't know which table(s)
> I need to hack on.

The dtv_multiplex table is likely the one you're after. I'd recommend
using a visual editor like phpMyAdmin - it makes navigating the
mythconverg database very easy.

Nick
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

casey.dunn at gmail

Dec 22, 2005, 10:52 PM

Post #3 of 6 (625 views)
Permalink

Re: need query to remove DVB transports [In reply to]

On 12/22/05, Nick <knowledgejunkie [at] gmail> wrote:
>
>
> The dtv_multiplex table is likely the one you're after. I'd recommend
> using a visual editor like phpMyAdmin - it makes navigating the
> mythconverg database very easy.
>
> Nick
>

It's actualy channel, once you've copied the mplexid, serviceid, atscsrd's
to the proper channels you should be good to go deleting the scanned
channels. Scanned atsc channels should also have a NULL freqid, while the
zap2it channels will have a freqid that looks like the channum

knowledgejunkie at gmail

Dec 22, 2005, 11:08 PM

Post #4 of 6 (634 views)
Permalink

Re: need query to remove DVB transports [In reply to]

On 23/12/05, casey dunn <casey.dunn [at] gmail> wrote:
>
>
> On 12/22/05, Nick <knowledgejunkie [at] gmail> wrote:
> >
> > The dtv_multiplex table is likely the one you're after. I'd recommend
> > using a visual editor like phpMyAdmin - it makes navigating the
> > mythconverg database very easy.
> >
> > Nick
> >
>
>
> It's actualy channel, once you've copied the mplexid, serviceid, atscsrd's
> to the proper channels you should be good to go deleting the scanned
> channels. Scanned atsc channels should also have a NULL freqid, while the
> zap2it channels will have a freqid that looks like the channum

Sorry about that - thinking about DVB and not ATSC.

N
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mythjoe at gmail

Dec 24, 2005, 8:21 PM

Post #5 of 6 (627 views)
Permalink

Re: need query to remove DVB transports [In reply to]

On 12/22/05, Nick <knowledgejunkie [at] gmail> wrote:
> On 23/12/05, casey dunn <casey.dunn [at] gmail> wrote:
> >
> >
> > On 12/22/05, Nick <knowledgejunkie [at] gmail> wrote:
> > >
> > > The dtv_multiplex table is likely the one you're after. I'd recommend
> > > using a visual editor like phpMyAdmin - it makes navigating the
> > > mythconverg database very easy.
> > >
> > > Nick
> > >
> >
> >
> > It's actualy channel, once you've copied the mplexid, serviceid, atscsrd's
> > to the proper channels you should be good to go deleting the scanned
> > channels. Scanned atsc channels should also have a NULL freqid, while the
> > zap2it channels will have a freqid that looks like the channum
>
> Sorry about that - thinking about DVB and not ATSC.

Actually, it was dtv_multiplex, as far as I can tell. I just deleted
the items with "0" frequency entries. It was bogus transports, not
channels, that I was after.

JB
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

casey.dunn at gmail

Dec 24, 2005, 10:22 PM

Post #6 of 6 (635 views)
Permalink

Re: need query to remove DVB transports [In reply to]

On 12/24/05, joe byrne <mythjoe [at] gmail> wrote:
>
> Actually, it was dtv_multiplex, as far as I can tell. I just deleted
> the items with "0" frequency entries. It was bogus transports, not
> channels, that I was after.
>

That's odd. I ended up with just one odd multiplex but an extra copy of
every channel. Oh well at least you found it

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads