On Sep 28, 2011, at 3:28 PM, ERB wrote:
> I have two models, users and companies as indicated below. The users
> table has a foreign_key "company_id".
>
> class User < ActiveRecord::Base
> has_many :companies
> end
>
> class Company < ActiveRecord::Base
> belongs_to: user
this should be
belong_to :user
> end
>
> In my controller:
>
> @user = User.where(:id => params[:id]).includes(:companies)
>
> I get the following error:
> SQlite3::SQLException: no such column: companies.user_id: SELECT
> "companies".* FROM "companies" WHERE "companies"."user_id" IN ('8')
>
>
Did you create a migration and run rake db:migrate ?
> Why is RAILS getting the foreign key wrong and why is it trying to
> pull columns in the users table into the companies model?
>
> --
Because you used .includes it is trying to eager load the companies. If you
don't know what eager loading is, you don't need it right now. One day you will
learn what eager loading is and you will then learn to use it, but until that
day you can get by without it.
If you do know what eager loading is and your intention was to use it here,
that's a different matter.
--
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.
