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 Buntin -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060301/94fa1a5f/attachment-0001.html
On 3/1/06, Buntin, Seth - KATE <Seth.Buntin@coe.murraystate.edu> wrote:> > 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? >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.> > > > Seth Buntin > > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060301/f856da39/attachment.html
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 Alvarez wrote:> On 3/1/06, Buntin, Seth - KATE <Seth.Buntin@coe.murraystate.edu> 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.-- Posted via http://www.ruby-forum.com/.