On 5 Nov 2008, at 15:03, Heinz Strunk wrote:
>
> Hello,
>
> I'm currently trying to populate my database with fixtures and
> having a
> problem.
>
> The table USER has many GROUPS he belongs to and vice versa so it's
> m:n
> relationship.
>
> Model:
> class User < ActiveRecord::Base
> has_many :user_groups, :dependent => :nullify
> has_many :groups, :through => :user_groups
> end
>
> class Group < ActiveRecord::Base
> has_many :user_groups, :dependent => :nullify
> has_many :users, :through => :user_groups
> end
>
> class UserGroups < ActiveRecord::Base
> belongs_to :user
> belongs_to :group
> end
>
> Fixuture of UserGroups:
> one:
> user: one
> group: one
> two:
> user: two
> group: two
>
> And that's the error I get:
> rake aborted!
> Mysql::Error: #42S22Unknown column 'user' in 'field list': INSERT INTO
> `user_groups` (`user`, `group`) VALUES ('two', 'two')
>
IIRC with the foxy fixtures stuff you don't need user_groups.yml at all
your users.yml can contain stuff like
bob:
groups: one, two
Fred
> Anyone any idea how to solve it? Thanks!
> --
> Posted via http://www.ruby-forum.com/.
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
