[mythtv] grr, DVB (uk) channels started moving around...

[Nick Craig-Wood]

On Fri, Oct 08, 2004 at 08:27:56AM +0100, Ed Wildgoose wrote:
> Yep, serviceid, and all other params staying the same as far as I can 
> see, just the pids which are changing

In case anyone is interested, this is what I changed in my DB to make
it work again.  It affected ITV1, ITV2 and CH4 only.

update dvb_pids set pid=520 where pid=512;
update dvb_pids set pid=521 where pid=650;
update dvb_pids set pid=2860 where pid=2827;
update dvb_pids set pid=2861 where pid=2828;
update dvb_pids set pid=580 where pid=2818;
update dvb_pids set pid=581 where pid=2819;

To show what you've got use

select channel.chanid,channel.name,pid,type from channel, dvb_pids where channel.chanid=dvb_pids.chanid;

I don't have all the channels in the DB though so there may be others!

Thats restored my mythtv to working order.

-- 
Nick Craig-Wood <nick at craig-wood.com> -- http://www.craig-wood.com/nick