[mythtv] EIT guide fixup for comhem

Torbjörn Jansson torbjorn.jansson at mbox200.swipnet.se
Tue Jul 12 15:22:39 EDT 2005


A while back ComHem changed lots of the channels and the serivce ids changed
too.
To make the EIT guide work with subtitles again, there is a change that have
to be made to dtv_privatetypes table.

The following 2 sql commands with fix the service ids:
---
DELETE FROM dtv_privatetypes
WHERE sitype='dvb' AND networkid=40999 AND
private_type='parse_subtitle_list';

INSERT INTO dtv_privatetypes (sitype,networkid,private_type,private_value)
VALUES
('dvb',40999,'parse_subtitle_list','1070,1308,1041,1306,1307,1030,1016,1131,
1068,1069');
---

The reason i used delete first is because for some reason i got multiple
identical entries in the database, coud be some problem or just a leftover
from my testing.

For those who want to test if this works right away without waiting a few
days until the old guide data expiers can delete the program and credits
table and then rerun mythfilldatabase followed by some channel changing.

The guide data seems to only be present on one mux (is that the right term?)
so i change to/from channel TCM and then after a while the guide data is
filled in.

I haven't figured out how this auto db update thing in mythtv works yet,
otherwise i would have submitted a patch.



More information about the mythtv-dev mailing list