| LinHES Forums http://forums.linhes.org/ |
|
| Just a few channels are mixed up. http://forums.linhes.org/viewtopic.php?f=17&t=11870 |
Page 1 of 1 |
| Author: | mcwilson [ Wed Sep 27, 2006 7:54 pm ] |
| Post subject: | Just a few channels are mixed up. |
From my guide I am getting generally the right channels. 90% or so but the rest are the wrong channel. This is a problem because it is mixing up my recorded shows. How do I tell mythtv to still get the channel guide information it is getting but map a couple channels to different places? Is this possible? |
|
| Author: | tjc [ Wed Sep 27, 2006 8:07 pm ] |
| Post subject: | |
Search for posts that mention update_database.sh by me. Remember that to swap two channels you need to use a temporary slot so that you can play "the fox, the goose, and the bag of beans" (or if you're French "le loup, la chèvre, et les choux"). |
|
| Author: | mcwilson [ Wed Sep 27, 2006 8:30 pm ] |
| Post subject: | |
for other people looking into this in the future, here is a link to the thread in question. http://mysettopbox.tv/phpBB2/viewtopic.php?t=10075 |
|
| Author: | tjc [ Wed Sep 27, 2006 9:10 pm ] |
| Post subject: | |
OBTW - In the latest MythTV version extra columns got added to one of those tables. I forget which, but mysql should complain bitterly when you try running it. OK, this looks like it... Code: insert into program
(select '$to_chanid', starttime, endtime, title, subtitle, description, category, category_type, airdate, stars, previouslyshown, title_pronounce, stereo, subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalairdate, showtype, colorcode, syndicatedepisodenumber, programid, manualid, generic, listingsource, first, last from program where chanid = '$from_chanid'); |
|
| Author: | mcwilson [ Wed Sep 27, 2006 9:36 pm ] |
| Post subject: | |
Thanks, I have done SQL work before I just wanted to see which tables I needed to modify. I should be able to handle the rest. I will post in here once I get around to doing it for people in the future. |
|
| Author: | tjc [ Wed Sep 27, 2006 10:41 pm ] |
| Post subject: | |
The function in that script should be pretty close to a complete solution. The main thing I would do is to break all the deletes out as a seperate function so you can use it at the end to get rid of your scratch pad pseudo channel. After that all you need is the mapping from channel 1 to channel 2 and so on. |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|