[mythtv-users] scte65scan .sql file (sourceid question)

Brad Fuller bradallenfuller at gmail.com
Mon Jun 15 21:15:22 UTC 2009


On Mon, Jun 15, 2009 at 2:10 PM, Brad Fuller<bradallenfuller at gmail.com> wrote:
> On Mon, Jun 15, 2009 at 1:49 PM, Brad Fuller<bradallenfuller at gmail.com> wrote:
>> On Mon, Jun 15, 2009 at 11:56 AM, Brad Fuller<bradallenfuller at gmail.com> wrote:
>>>>> On Mon, Jun 15, 2009 at 11:43 AM, Larry W<larry104 at pacbell.net> wrote:
>>>>> Why don't you use the -f flag to set the sourceid: E.g. -f 3,3 creates the
>>>>> sql for sourceid = 3 (-f n,m where n=format and m=sourceid)
>>>>>
>>> On Mon, Jun 15, 2009 at 11:52 AM, Brad Fuller<bradallenfuller at gmail.com> wrote:
>>>>
>>>> I did, but it never locked when I did that.
>>>> what I had to do was:
>>>>
>>>> ./scte65scan -f3 -H FFFFFFFF,1 -p -V -x0BB9 us-Cable.... > myth-svct.sql
>>>>
>>>> which worked.
>>>>
>>>> should I have done:
>>>>
>>>> ./scte65scan -f3,5 -H FFFFFFFF,1 -p -V -x0BB9 us-Cable.... > myth-svct.sql
>>>>
>>>> I don't quite understand why we need to put the sourceid in.
>>>
>>> oh... do you assume there is only one sourceid per cardid?
>>>
>>
>>
>> UPDATE:
>> I created a new video source (just pointed a new one at an existing
>> Schedules Direct Comcast Digital lineup) and scanned for channels
>> inside mythv-setup, so I would get a new sourceid. This sourceid is 5
>> (which makes sense.)
>> I then edited my myth-svct.sql substituted sourceid=5 or sourceid=1
>> and tried to merge. Unfortunately, I rcv an error right off the bat:
>>
>> ERROR 1062 (23000) at line 71: Duplicate entry '68' for key 1
>>
>> Looking in the myth-svct.sql file I don't see any duplicate entry. Has
>> anyone received this error before?
>
> I looked at the table in MySQL Query Browser and see that the merge
> into the mythconverg dB went up to 67 and stopped. That's where the
> error occurred. I haven't found anything via google that relates to
> this problem. I tried to attach the myth-svct-sqll file in hopes that
> someone knows why it stopped at line 71. But, the server wouldn't let
> me - got an error that it was too big. Bummer.
>
> In any case, I'm grateful for any help to assist me getting this .sql
> file into mythconverg.

Maybe I can put the lines of the .sql file up to (and a little past)
where I got the ERROR (which is mplexid=68. Here it is:

-- WARNING: The following line clears out dtv_multiplex table
DELETE FROM dtv_multiplex WHERE sourceid=5;
-- Frequency table from SCTE-65 CDS
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=1,frequency=75250000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=2,frequency=57000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=3,frequency=63000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=4,frequency=69000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=5,frequency=79000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=6,frequency=85000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=7,frequency=177000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=8,frequency=183000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=9,frequency=189000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=10,frequency=195000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=11,frequency=201000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=12,frequency=207000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=13,frequency=213000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=14,frequency=123000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=15,frequency=129000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=16,frequency=135000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=17,frequency=141000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=18,frequency=147000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=19,frequency=153000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=20,frequency=159000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=21,frequency=165000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=22,frequency=171000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=23,frequency=219000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=24,frequency=225000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=25,frequency=231000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=26,frequency=237000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=27,frequency=243000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=28,frequency=249000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=29,frequency=255000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=30,frequency=261000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=31,frequency=267000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=32,frequency=273000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=33,frequency=279000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=34,frequency=285000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=35,frequency=291000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=36,frequency=297000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=37,frequency=303000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=38,frequency=309000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=39,frequency=315000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=40,frequency=321000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=41,frequency=327000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=42,frequency=333000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=43,frequency=339000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=44,frequency=345000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=45,frequency=351000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=46,frequency=357000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=47,frequency=363000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=48,frequency=369000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=49,frequency=375000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=50,frequency=381000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=51,frequency=387000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=52,frequency=393000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=53,frequency=399000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=54,frequency=405000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=55,frequency=411000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=56,frequency=417000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=57,frequency=423000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=58,frequency=429000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=59,frequency=435000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=60,frequency=441000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=61,frequency=447000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=62,frequency=453000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=63,frequency=459000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=64,frequency=465000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=65,frequency=471000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=66,frequency=477000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=67,frequency=483000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=68,frequency=489000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=69,frequency=495000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=70,frequency=501000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=71,frequency=507000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=72,frequency=513000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=73,frequency=519000000,modulation='qam_256',sourceid=5;
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=74,frequency=525000000,modulation='qam_256',sourceid=5;



-- 
Brad Fuller


More information about the mythtv-users mailing list