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

[RAM]

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.

Roy