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

[Brad Fuller]

On Mon, Jun 15, 2009 at 3:55 PM, RAM<ram at bca.com> wrote:
>
>
> Brad Fuller wrote:
>>
>> On Mon, Jun 15, 2009 at 2:15 PM, Brad Fuller<bradallenfuller at gmail.com>
>> wrote:
>>  (keep replying to myself.... schizoidman)
>>
>> This error
>> ERROR 1062 (23000) at line 71: Duplicate entry '68' for key 1
>> might be because there is a mplexid=68 in the dtv-multiplex table but
>> it's for sourceid=2.
>> But, I can see how there might be an error since that already exists.
>>
>> OK, so that doens't make any sense, there's always going to be more
>> mplexid's if you have other cards running. So, what gives?
>>
>>
>
> Hi Brad,
>
> Your problem is what my original reply in this thread dealt with.  I had a
> hack to move the mplexid start from 1 to beyond existing entries.
>
> mplexid is a unique key, and so you can't have more that one in the
> database.

Thanks Roy. Dennis pointed that out to me. I saw your hack. What I did
was edit the mplexid's to be unique. It merged just now, so I'm going
to check it out.

-- 
Brad Fuller