# 2.02 problems with sqlite3 - not finding data

**URL:** <https://www.ruby-forum.com/t/2-02-problems-with-sqlite3-not-finding-data/124596>\
**Category:** Rails\
**Created:** [December 30, 2007, 9:13pm UTC](https://www.ruby-forum.com/t/2-02-problems-with-sqlite3-not-finding-data/124596 "2007-12-30T21:13:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MilesTogoe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/0ea827/32.png) [@MilesTogoe](https://www.ruby-forum.com/u/MilesTogoe)\
**Post date:** [December 30, 2007, 9:13pm UTC](https://www.ruby-forum.com/t/2-02-problems-with-sqlite3-not-finding-data/124596/1 "2007-12-30T21:13:05Z")

</div>

I upgraded to Rails 2.02 and created a new project. I created a table  
with migrations. It’s there. At sqlite3 prompt I add a record. I  
can select \* and see the data. But Mymodel.find(:all) returns  
nothing. Even in a unit test, Mymodel.count returns zero.

I thought I might need to update gem ruby-sqlite - this refuses to  
compile missing ruby.h (and yes I have ruby-dev installed).

Any ideas ? Is the problem related to needing a new sqlite gem ? If  
so, any ideas of getting it compiled (Ubuntu Gutsy). Thks.

---

<div class="post-metadata">

**Author:** ![MilesTogoe](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/0ea827/32.png) [@MilesTogoe](https://www.ruby-forum.com/u/MilesTogoe)\
**Post date:** [December 31, 2007, 5:41pm UTC](https://www.ruby-forum.com/t/2-02-problems-with-sqlite3-not-finding-data/124596/2 "2007-12-31T17:41:22Z")

</div>

Still No Go. I added libsqlite-dev and that installed the gem  
update. But even trying a new migration, etc, it still does not read  
the data - appears active record is not synching with sqlite.