# M:n realtions don't work with fixtures?!

**URL:** <https://www.ruby-forum.com/t/m-n-realtions-dont-work-with-fixtures/152609>\
**Category:** Rails\
**Created:** [November 5, 2008, 4:03pm UTC](https://www.ruby-forum.com/t/m-n-realtions-dont-work-with-fixtures/152609 "2008-11-05T16:03:17Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![cojones](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/9f8e36/32.png) [@cojones](https://www.ruby-forum.com/u/cojones)\
**Post date:** [November 5, 2008, 4:03pm UTC](https://www.ruby-forum.com/t/m-n-realtions-dont-work-with-fixtures/152609/1 "2008-11-05T16:03:17Z")

</div>

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’)

Anyone any idea how to solve it? Thanks!

---

<div class="post-metadata">

**Author:** ![cojones](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/9f8e36/32.png) [@cojones](https://www.ruby-forum.com/u/cojones)\
**Post date:** [November 5, 2008, 4:12pm UTC](https://www.ruby-forum.com/t/m-n-realtions-dont-work-with-fixtures/152609/2 "2008-11-05T16:12:13Z")

</div>

On 5 Nov 2008, at 15:03, Heinz S. wrote:

> 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

---

<div class="post-metadata">

**Author:** ![cojones](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/9f8e36/32.png) [@cojones](https://www.ruby-forum.com/u/cojones)\
**Post date:** [November 5, 2008, 5:01pm UTC](https://www.ruby-forum.com/t/m-n-realtions-dont-work-with-fixtures/152609/3 "2008-11-05T17:01:16Z")

</div>

Thanks!

---

<div class="post-metadata">

**Author:** ![cojones](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/9f8e36/32.png) [@cojones](https://www.ruby-forum.com/u/cojones)\
**Post date:** [November 5, 2008, 5:17pm UTC](https://www.ruby-forum.com/t/m-n-realtions-dont-work-with-fixtures/152609/4 "2008-11-05T17:17:07Z")

</div>

Well, doesn’t seem to work:

rake aborted!  
Mysql::Error: #42S22Unknown column ‘groups’ in ‘field list’: INSERT INTO  
`users` (`name`, `groups`) VALUES (‘test’, ‘one’)

Fixture of Users:  
one:  
name: test  
groups: one

---

<div class="post-metadata">

**Author:** ![cojones](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/9f8e36/32.png) [@cojones](https://www.ruby-forum.com/u/cojones)\
**Post date:** [November 5, 2008, 7:06pm UTC](https://www.ruby-forum.com/t/m-n-realtions-dont-work-with-fixtures/152609/5 "2008-11-05T19:06:29Z")

</div>

rails -v  
Rails 2.1.0

---

<div class="post-metadata">

**Author:** ![cojones](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/9f8e36/32.png) [@cojones](https://www.ruby-forum.com/u/cojones)\
**Post date:** [November 5, 2008, 10:16pm UTC](https://www.ruby-forum.com/t/m-n-realtions-dont-work-with-fixtures/152609/6 "2008-11-05T22:16:11Z")

</div>

Spelling error in the model.rb. All good, thanks a lot!

---

<div class="post-metadata">

**Author:** ![cojones](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/9f8e36/32.png) [@cojones](https://www.ruby-forum.com/u/cojones)\
**Post date:** [November 5, 2008, 6:13pm UTC](https://www.ruby-forum.com/t/m-n-realtions-dont-work-with-fixtures/152609/7 "2008-11-05T18:13:41Z")

</div>

On 5 Nov 2008, at 16:17, Heinz S. wrote:

> Well, doesn’t seem to work:

just as a sanity check, what version of rails are you using ?

Fred