# Activerecord problem..

**URL:** <https://discuss.rubyonrails.org/t/activerecord-problem/32919>\
**Category:** rubyonrails-talk\
**Created:** [August 7, 2008, 1:05am UTC](https://discuss.rubyonrails.org/t/activerecord-problem/32919 "2008-08-07T01:05:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![11175](https://avatars.discourse-cdn.com/v4/letter/1/8edcca/32.png) [@11175](https://discuss.rubyonrails.org/u/11175)\
**Post date:** [August 7, 2008, 1:05am UTC](https://discuss.rubyonrails.org/t/activerecord-problem/32919/1 "2008-08-07T01:05:03Z")

</div>

I have the following method....

def index &nbsp;&nbsp;&nbsp;&nbsp;@posts=Post.find(:all, :include =\> [:user, :comments]) &nbsp;&nbsp;&nbsp;&nbsp;for post in @posts &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;puts "Post: #{post.title}" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;puts "Written by: #{post.user.title}" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;puts "Last comment on: #{post.comments.first.created\_at}" &nbsp;&nbsp;&nbsp;&nbsp;end end

(the use model) class User \< ActiveRecord::Base &nbsp;&nbsp;has\_many:posts end

(the post model)

class Post \< ActiveRecord::Base &nbsp;&nbsp;belongs\_to:user &nbsp;&nbsp;has\_many :comments, :order =\> 'created\_at DESC' end

when i run the application I get the following errors why ? Am i missing something ???

NoMethodError in TestController#index

You have a nil object when you didn't expect it! The error occurred while evaluating nil.title

RAILS\_ROOT: D:/InstantRails-2.0-win/rails\_apps/active Application Trace | Framework Trace | Full Trace

app/controllers/test\_controller.rb:6:in `index' app/controllers/test_controller.rb:4:in `each' app/controllers/test\_controller.rb:4:in `index'

---

<div class="post-metadata">

**Author:** ![Frederick\_Cheung](https://sea2.discourse-cdn.com/rubyonrails/user_avatar/discuss.rubyonrails.org/frederick_cheung/32/3901_2.png) [@Frederick\_Cheung](https://discuss.rubyonrails.org/u/Frederick_Cheung)\
**Post date:** [August 7, 2008, 1:25am UTC](https://discuss.rubyonrails.org/t/activerecord-problem/32919/2 "2008-08-07T01:25:42Z")

</div>

Looks like you've got a post without a user. Check what is actually in the database.

Fred

---

<div class="post-metadata">

**Author:** ![11175](https://avatars.discourse-cdn.com/v4/letter/1/8edcca/32.png) [@11175](https://discuss.rubyonrails.org/u/11175)\
**Post date:** [August 7, 2008, 1:36am UTC](https://discuss.rubyonrails.org/t/activerecord-problem/32919/3 "2008-08-07T01:36:51Z")

</div>

Frederick Cheung wrote:

---

<div class="post-metadata">

**Author:** ![11175](https://avatars.discourse-cdn.com/v4/letter/1/8edcca/32.png) [@11175](https://discuss.rubyonrails.org/u/11175)\
**Post date:** [August 7, 2008, 1:38am UTC](https://discuss.rubyonrails.org/t/activerecord-problem/32919/4 "2008-08-07T01:38:32Z")

</div>

Frederick Cheung wrote:

---

<div class="post-metadata">

**Author:** ![Frederick\_Cheung](https://sea2.discourse-cdn.com/rubyonrails/user_avatar/discuss.rubyonrails.org/frederick_cheung/32/3901_2.png) [@Frederick\_Cheung](https://discuss.rubyonrails.org/u/Frederick_Cheung)\
**Post date:** [August 7, 2008, 1:42am UTC](https://discuss.rubyonrails.org/t/activerecord-problem/32919/5 "2008-08-07T01:42:40Z")

</div>

What you're seeing suggests that your data isn't quite what you think it is. Identify the post for which post.user is returning nil and workout why. unless you've got not null on user\_id, the foreign key constraint won't prevent a null user\_id.

Fred