# No database data showing up no warning message

**URL:** <https://www.ruby-forum.com/t/no-database-data-showing-up-no-warning-message/130698>\
**Category:** Rails\
**Created:** [March 2, 2008, 1:03am UTC](https://www.ruby-forum.com/t/no-database-data-showing-up-no-warning-message/130698 "2008-03-02T01:03:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![drorchung](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/848f3c/32.png) [@drorchung](https://www.ruby-forum.com/u/drorchung)\
**Post date:** [March 2, 2008, 1:03am UTC](https://www.ruby-forum.com/t/no-database-data-showing-up-no-warning-message/130698/1 "2008-03-02T01:03:16Z")

</div>

After working for several days, I finally got Ruby on Rails set up on  
my Ubuntu.  
I read several tutorials and tried with them. Finally, I adopted the  
sample used in  
[http://www.oracle.com/technology/pub/articles/haefel-oracle-ruby.html](http://www.oracle.com/technology/pub/articles/haefel-oracle-ruby.html)  
with mysql because it is more up-dated.

I did a scaffold.  
I executed â€œ[http://127.0.0.1:3000/categoriesâ€](http://127.0.0.1:3000/categories%C3%A2%E2%82%AC), but no data showed up  
with the frames.

I executed â€œ[http://127.0.0.1:3000/categories/show](http://127.0.0.1:3000/categories/show) â€ or  
â€œ[http://127.0.0.1:3000/categories/listâ€](http://127.0.0.1:3000/categories/list%C3%A2%E2%82%AC), the error messages came up.  
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/base.rb:1267:in  
`find_one' /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1250:in `find\_from\_ids’  
/usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/base.rb:504:in  
`find' app/controllers/categories_controller.rb:16:in `show’  
my settings:  
Ruby version1.8.6 (i486-linux)  
RubyGems version1.0.1  
Rails version2.0.2  
Active Record version2.0.2  
Action Pack version2.0.2  
Active Resource version2.0.2  
Action Mailer version2.0.2  
Active Support version2.0.2  
Application root/var/www/ToDo  
Environment development  
Database adapter mysql

My database has been properly connected. I downloaded an API module from  
[tmtm.org](http://tmtm.org) and checked the connection with simple.rb at  
[http://www.kitebird.com/articles/ruby-mysql.html#TOC\_1](http://www.kitebird.com/articles/ruby-mysql.html#TOC_1)  
by Paul DuBois.

I tried with another project. I still could not solve the above  
problems. I googled some time but to no avail.

---

<div class="post-metadata">

**Author:** ![drorchung](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/848f3c/32.png) [@drorchung](https://www.ruby-forum.com/u/drorchung)\
**Post date:** [March 4, 2008, 3:43am UTC](https://www.ruby-forum.com/t/no-database-data-showing-up-no-warning-message/130698/2 "2008-03-04T03:43:16Z")

</div>

Tks Robin

Most of the tutorials are really out of date. Rails has moved on quite  
a bit  
since version 2.0. I read the tutorials on the Akita on Rails site.

regards,

dror

---

<div class="post-metadata">

**Author:** ![drorchung](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/848f3c/32.png) [@drorchung](https://www.ruby-forum.com/u/drorchung)\
**Post date:** [March 2, 2008, 8:12am UTC](https://www.ruby-forum.com/t/no-database-data-showing-up-no-warning-message/130698/3 "2008-03-02T08:12:30Z")

</div>

On Mar 2, 12:03 am, Dror C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> I read several tutorials and tried with them. Finally, I adopted the  
> sample used inhttp://www.oracle.com/technology/pub/articles/haefel-oracle-ruby.html  
> with mysql because it is more up-dated.

This tutorial is really out of date. Rails has moved on quite a bit  
since 2006. I would suggest looking at the tutorials on the Akita on  
Rails site.

> I executed “[http://127.0.0.1:3000/categories/show](http://127.0.0.1:3000/categories/show)” or  
> “[http://127.0.0.1:3000/categories/list](http://127.0.0.1:3000/categories/list)”, the error messages came up.  
> /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/base.rb:1267:in  
> `find_one' /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1250:in `find\_from\_ids’  
> /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/base.rb:504:in  
> `find' app/controllers/categories_controller.rb:16:in `show’

What does line 16 of your categories\_controller.rb file say as this is  
where the error is being thrown?

Regards

Robin
