MythTV and Rowridge re-tune

So with the wonders of rowridge being retuned as part of the big digital switchover I've had to retune my mythtv back end. All went well but some channels including

• Yesterday
• Film 4
• E4

Had no EPG data. I tried retuning, clearning down with no luck. Those of you who know about myth will know that it uses a mysql backend so I dove into the database and found that the networkid in the dtv_multiplex table was 0 for the multiplex that carries these channels.

Running a command to update these to 9018 (the network id for the other multiplexes on Rowridge) then kickstarted the eit scraper.

Once you're connected to the mysql database on your backend:

mysql -u mythtv -p mythconverg

(then your password)

Check to see if this is your problem:

select * from dtv_multiplex where networkid=0;

If you only have the one video source (e.g just freeview) then you can skip to the updating table section below if you also have a dvb-s tuner (for freesat channels) then you will need to identify the source id from the table (its one of the columns that come up when you ran the query above). Once you have that sourceid run this command

select * from dtv_multiplex where sourceid=3;

(where 3 is the sourceid you got from the previous query)

Make a note of the network id that you got in this query (mine was 9018)

Updating table section

Run the command

update dtv_multiplex set networkid=9018 where sourceid=3 and networkid=0;

(Where 9018 is the networkid you got above and 3 is the number you got in the first query)

Once done you should see the EPG data start populating.