LinHES Forums :: View topic - How do I split one lineup across two input sources?

delete from channel where channum < 79 && sourceid = 2;
delete from channel where channum > 79 && sourceid = 1;

2006-03-25 08:30:02.695 DB Error (GetChannel(ProgInfo...)):
Query was:
SELECT channel.channum, cardinput.inputname FROM channel, capturecard, cardinput WHERE channel.chanid = '1102' AND cardinput.cardid = capturecard.cardid AND cardinput.sourceid = 1 AND capturecard.cardid = 1
No error type from QSqlError? Strange...
2006-03-25 08:30:02.726 TVRec(1) Error: Failed to set channel to . Reverting to kState_None

Author:	patman [ Sat Mar 25, 2006 7:49 pm ]
Post subject:	How do I split one lineup across two input sources?
I have a PVR350, and it is connected directly to the cable via coax, as well as to the cable box via svideo. I have seen this question before, but I haven't ever seen a good solution. If I record via the cable box, mythtv has to change the channel on the cable box using ledxmit, and that means if I happen to be watching TV at the time the recording starts, I have to watch what is being recorded. If I record via the PVR350 analog tuner, it doesn't affect the cable box, and I can watch something different via the cable box while it's recording via it's own tuner. Not all the channels come through in analog however, so I need to split the lineup between the two so I'm at least reducing the competition. I want to record the low channels (1-79) ONLY via the analog cable using the PVR350 tuner, and the high channels (80-999) ONLY via the digital cable box using the svideo input. Right now I have two sources defined with the same zap2it channel lineup. I then have a script wrapped around mythfilldatabase that runs the regular fill (which downloads a complete copy of the lineup for both sources) and then cleans up with: Code: delete from channel where channum < 79 && sourceid = 2; delete from channel where channum > 79 && sourceid = 1; This has been working...except... It downloads twice the data as is necessary, which takes time, and is wasteful. I've been getting random recording problems that produce blank recordings. Code: 2006-03-25 08:30:02.695 DB Error (GetChannel(ProgInfo...)): Query was: SELECT channel.channum, cardinput.inputname FROM channel, capturecard, cardinput WHERE channel.chanid = '1102' AND cardinput.cardid = capturecard.cardid AND cardinput.sourceid = 1 AND capturecard.cardid = 1 No error type from QSqlError? Strange... 2006-03-25 08:30:02.726 TVRec(1) Error: Failed to set channel to . Reverting to kState_None The problem seems to be that it is failing to look up the channel in the lineup at record time. I suspect this is because the scheduling was done after the mythfilldatabase, but before the delete was done...so I end up with orphaned channels. (note that 1102 is source 1, channel 102...and source 1 is only supposed to have channels 1-79 on it...) Anyone have a good solution to this? I've considered setting up a separate zap2it labs account and just limiting the lineup 1-79 in the first account and 80+ in the second account, but that is not using the zap2it info the way it was intended. Anyone got a better solution to all this?

Author:	tjc [ Sun Mar 26, 2006 12:33 am ]
Post subject:
Add this like to the end of your script after the database munging.... Code: /usr/bin/mythbackend --resched Oh, and why don''t you just dowload one source and then change the sourceid for any channels above 79? Or better still download one, and generate the two partial ones from it...

LinHES Forums http://forum.linhes.org/

How do I split one lineup across two input sources? http://forum.linhes.org/viewtopic.php?f=6&t=9266	Page 1 of 1

Page 1 of 1	All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/