On Apr 28, 1:18 pm, Frederick Cheung <[email protected]> wrote: > On 28 Apr 2011, at 13:13, Owain <[email protected]> wrote: > > > > > > > On Apr 28, 12:57 pm, Frederick Cheung <[email protected]> > > wrote: > > >>> mysql> insert into confirmations (quote_id) values(188); > >>> Query OK, 1 row affected (0.01 sec) > > >>> mysql> select * from confirmations where quote_id = 188; > > >> Why are you filtering by quote_id here? > > > Fred, > > > Just to show that the mysql CLI client allowed me to manually add > > another row with the same quote_id of 188. So it is not mysql server > > that is reporting the Duplicate Entry/Statement invalid. It is being > > reported by the mysql adapter of ActiveRecord. > > On closer inspection it may be that the duplicate entry error is coming from > the primary key (your insert was explicitly setting the id to 185) > > Fred >
Fred, You are absolutely correct. It should be auto_increment but I have set it explicitly in my code. Thank you very much for your help. You do a grand job on this list. O. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
