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

Brad Fuller bradallenfuller at gmail.com
Mon Jun 15 23:10:06 UTC 2009

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

More information about the mythtv-users mailing list