# Can't load fixtures into db with has\_and\_belongs\_to\_many

**URL:** <https://www.ruby-forum.com/t/cant-load-fixtures-into-db-with-has-and-belongs-to-many/126831>\
**Category:** Rails\
**Created:** [January 22, 2008, 4:59pm UTC](https://www.ruby-forum.com/t/cant-load-fixtures-into-db-with-has-and-belongs-to-many/126831 "2008-01-22T16:59:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jdias](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e47c2d/32.png) [@jdias](https://www.ruby-forum.com/u/jdias)\
**Post date:** [January 22, 2008, 4:59pm UTC](https://www.ruby-forum.com/t/cant-load-fixtures-into-db-with-has-and-belongs-to-many/126831/1 "2008-01-22T16:59:28Z")

</div>

Hi, I’ve been having some problem with the new features in fixtures  
included in rails 2.0.2.

The problem I’m having is although my test run fine, i’m unable to  
import them into the db using rake db:fixtures:load

This is the error i’m getting:

rake aborted!  
PGError: ERROR: column “admin\_roles” of relation “admin\_users” does not  
exist  
LINE 1: …ERT INTO admin\_users (“salt”, “crypted\_password”,  
"admin\_rol…  
^  
: INSERT INTO admin\_users (“salt”, “crypted\_password”, “admin\_roles”,  
“login”, “email”) VALUES (E’eca03dde78af4419efb984b1c1ebce8ab9446ac0’,  
E’bc907667ec4a1d826f3c0cbda775083af9a8d328’, E’admin\_role’, E’admin’,  
E’removed\_email\_address@domain.invalid’)  
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/connection\_adapters/abstract\_adapter.rb:150:in  
`log' /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:407:in`execute’  
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:140:in  
`insert_fixture' /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:633:in`insert\_fixtures’  
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/fixtures.rb:570:in  
`each' /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:570:in`insert\_fixtures’  
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/fixtures.rb:516:in  
`create_fixtures' /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/fixtures.rb:516:in`each’  
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/fixtures.rb:516:in  
`create_fixtures' /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in`transaction’  
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/fixtures.rb:514:in  
`create_fixtures' /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:374:in`disable\_referential\_integrity’  
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/fixtures.rb:505:in  
`create_fixtures' /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1198:in`silence’  
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/fixtures.rb:504:in  
`create_fixtures' /usr/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/tasks/databases.rake:157 /usr/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/tasks/databases.rake:156:in`each’  
/usr/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/tasks/databases.rake:156  
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in`execute’  
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in`execute’  
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in  
`invoke_with_call_chain' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in`synchronize’  
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in  
`invoke_with_call_chain' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in`invoke’  
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in `invoke_task' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in`top\_level’  
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in`top\_level’  
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in  
`standard_exception_handling' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in`top\_level’  
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in`standard\_exception\_handling’  
/usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31 /usr/bin/rake:19:in`load’  
/usr/bin/rake:19

I have this two fixtures:

admin\_users.yml

admin:  
login: admin  
email: removed\_email\_address@domain.invalid  
salt: eca03dde78af4419efb984b1c1ebce8ab9446ac0  
crypted\_password: bc907667ec4a1d826f3c0cbda775083af9a8d328 # admin  
admin\_roles: admin\_role

editor:  
login: editor  
email: removed\_email\_address@domain.invalid  
salt: 50e776d5c45cadb66b8f85d7f4414d56deb1a025  
crypted\_password: b67d504587dbefa525cfd1c4e6af294a068fa095 # editor  
admin\_roles: editor\_role

moderador:  
login: moderador  
email: removed\_email\_address@domain.invalid  
salt: 90d48b947ea3b92b117c106773745cf04b2aa892  
crypted\_password: bc907667ec4a1d826f3c0cbda775083af9a8d328 # moderador

# activation\_code: adminscode # only if you’re activating new signups

admin\_roles: moderador\_role

* * *

admin\_roles.yml

admin\_role:  
name: admin  
editor\_role:  
name: editor  
moderador\_role:  
name: moderador

* * *

The user model habtm roles, like this:

class Admin::User \< ActiveRecord::Base

set\_table\_name ‘admin\_users’

# ---------------------------------------

# The following code has been generated by role\_requirement.

# You may wish to modify it to suit your need

has\_and\_belongs\_to\_many :admin\_roles, :class\_name =\> ‘Admin::Role’,  
:join\_table =\> “admin\_roles\_admin\_users”, :foreign\_key =\>  
“admin\_user\_id”, :association\_foreign\_key =\> “admin\_role\_id”

…

* * *

Does anybody know what am I doing wrong?

Using postgresql, and rails 2.0.2

---

<div class="post-metadata">

**Author:** ![jdias](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/e47c2d/32.png) [@jdias](https://www.ruby-forum.com/u/jdias)\
**Post date:** [April 25, 2008, 3:09am UTC](https://www.ruby-forum.com/t/cant-load-fixtures-into-db-with-has-and-belongs-to-many/126831/2 "2008-04-25T03:09:19Z")

</div>

Jorge,

Did you ever find out what was going on with this? I’m having the  
same error now. What’s weird is that it works fine in MySQL.

Sean

On Jan 22, 11:59 am, Jorge D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)