Comcast, Schedules Direct, and MythTV

My MythTV is set up with 2 tuner cards, one is connected to my main cable box, and the other was connected straight to the basic cable. I have LIRC control the cable box. Not long ago, Comcast issued digital set top boxes (STB) for all its services, even basic cable. I then had to add the STB and have LIRC control it as well.
On Schedules Direct I had 2 listing, basic, and digital. Comcast has now added more channels on the STB that are above and beyond Basic (like SyFi and Sprout, but not BBC or movie channels if you have a digital package) so I wanted to be able to tune them as well on MythTV. I set both inputs to use the digital listing since Schedules Direct only lets you have each linup once, and deleted the unavailable channels from the STB input. On the next run of mythfilldatabase, the channels were added back. Since I don’t want Myth to try to record on a tuner / channel that doesn’t exist, I wanted a way to automaticly clear the channels. I read in a forum where somone ran a cron job to do this for over the air channels they could not receive, but I am trying something different. I found that when mythfilldatabase ran, the “finetune” field was set to “NULL” on the new channels. All I needed to do is delete any channels that matched this. In mythtv-setup there is a setting for “mythfilldatabase program” that I set to a batch file “” which contains:



mysql -u XXXX -pXXXX -e"delete from where finetune is NULL;"

XXXX are username and password
This way every time MythTV automaticly runs the command, it will clear the new channels on it’s own.
Of course, I will not have new channels that I may want added, but I can check for them on my own and run mythfilldatabase manually.

NOTE: if you use MythWeb, finetune will show as a blank (NULL) the first time making the new channels easy to find, but if you save changes, it will set it to “0″

I am going to let this run a few days and see how it goes!
One side benefit is since there is only on listing to download, mythfilldatabase runs in less time using cached data for the second tuner.

Number of View :2578

Comments are closed.