Help with Many-To-Many insert

Rails
1

I am having issues with a many-to-many table. The table relates
resources to standards, but in my resources table has one-to-many
relationships so those also appear in my many-to-many table. I am
trying to insert into the table via:

@resource.core_contents << CoreContent.find(params[:core_content_ids])

But I get this error:

Mysql::Error: Duplicate entry ‘0-0-0-0-0-0’ for key 1: INSERT INTO
core_contents_resources () VALUES ()

What is the problem?

Thanks for the help.

Seth B.

2

On 3/1/06, Buntin, Seth - KATE [email protected] wrote:

It seems that you have defined five fields of that table UNIQUE. Since
you
already have a record in that table with value 0 in each of those, no
more
records can be inserted with such values.

Thanks for the help.

3

Thanks. I took off the primary keys and it filled every row and value
with a zero. It seems to be the right number of rows for that
particular entry but the fields aren’t right. That isn’t what is
suppose to have it is suppose to fill with the ids.

Rodrigo A. wrote:

On 3/1/06, Buntin, Seth - KATE [email protected] wrote:

It seems that you have defined five fields of that table UNIQUE. Since
you
already have a record in that table with value 0 in each of those, no
more
records can be inserted with such values.

Thanks for the help.