Is it failing while running one of your tests (possibly an error in the
test) or while preparing for the test (possibly a problem with your
fixtures)?

Colin

2009/5/8 Lee <lee.longm...@googlemail.com>

>
> I have some model code that runs fine in development environment but
> fails in the test environment.
>
> In test, the code always fails at the same point with:
>
> Mysql::Error: Duplicate entry '5-17' for key 'PRIMARY': INSERT INTO
> `accessibilities_namespaces` (`accessibility_id`, `namespace_id`)
> VALUES (17, 5) [0m
>
> accessibilities_namespaces is a join table for HABTM relationships.
>
> My logging suggests that ActiveRecord tries to insert the same record
> twice when run in test (but only in test!) which would explain the
> above error. I am sure that the code does not try to create the same
> record twice and in any case it runs fine in development mode.
>
> I have tried running the code using 'script/console test' and it fails
> here also. Though it does not fail when run in 'script/console
> [development]'.
>
> I suspect the problem does not lie with MySQL or ActiveRecord, but
> something to do with the differences between running in development vs
> test.
>
> Any thoughts appreciated. I'm baffled by this.
> >
>

--~--~---------~--~----~------------~-------~--~----~
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 rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to 
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to