# SQLite 3 and Ruby Wierd errors

**URL:** <https://www.ruby-forum.com/t/sqlite-3-and-ruby-wierd-errors/113138>\
**Category:** Ruby\
**Created:** [August 28, 2007, 12:28am UTC](https://www.ruby-forum.com/t/sqlite-3-and-ruby-wierd-errors/113138 "2007-08-28T00:28:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ssyed](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/7ab992/32.png) [@ssyed](https://www.ruby-forum.com/u/ssyed)\
**Post date:** [August 28, 2007, 12:28am UTC](https://www.ruby-forum.com/t/sqlite-3-and-ruby-wierd-errors/113138/1 "2007-08-28T00:28:26Z")

</div>

Hi,  
I created a sqlite3 database and I get the wierdest error: Sometimes it  
will say that I don’t have a table named ‘account’ (Even though I do  
have this table) and other times it just loads perfectly!  
Any Idea why this would happen?

-Salik

---

<div class="post-metadata">

**Author:** ![ssyed](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/7ab992/32.png) [@ssyed](https://www.ruby-forum.com/u/ssyed)\
**Post date:** [August 28, 2007, 2:31am UTC](https://www.ruby-forum.com/t/sqlite-3-and-ruby-wierd-errors/113138/2 "2007-08-28T02:31:45Z")

</div>

Sal Syed wrote:

> I created a sqlite3 database and I get the wierdest error: Sometimes it  
> will say that I don’t have a table named ‘account’ (Even though I do  
> have this table) and other times it just loads perfectly!  
> Any Idea why this would happen?

I never hit that one, so here’s some generic tips:

- post some code, so we don’t need to stress our ESP
- post your version # to a sqlite mailing list
- make sure your sqlite3 gem is at least \_why’s version:  
[http://redhanded.hobix.com/cult/sqlite3Gem\_whySSensibilitiesRepack.html](http://redhanded.hobix.com/cult/sqlite3Gem_whySSensibilitiesRepack.html)
- use ActiveRecord, to insulate you from DB-specific issues

---

<div class="post-metadata">

**Author:** ![ssyed](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/7ab992/32.png) [@ssyed](https://www.ruby-forum.com/u/ssyed)\
**Post date:** [August 28, 2007, 4:16am UTC](https://www.ruby-forum.com/t/sqlite-3-and-ruby-wierd-errors/113138/3 "2007-08-28T04:16:52Z")

</div>

On 8/28/07, Phlip [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> - make sure your sqlite3 gem is at least \_why’s version:  
> [http://redhanded.hobix.com/cult/sqlite3Gem\_whySSensibilitiesRepack.html](http://redhanded.hobix.com/cult/sqlite3Gem_whySSensibilitiesRepack.html)

I’m not so sure about an updated version from \_why, but this is like  
from Oct 2006… Haven’t the changes been incorporated into Jamis’s  
version already (see his comment as well)

-jf

---

<div class="post-metadata">

**Author:** ![ssyed](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/7ab992/32.png) [@ssyed](https://www.ruby-forum.com/u/ssyed)\
**Post date:** [September 3, 2007, 3:46pm UTC](https://www.ruby-forum.com/t/sqlite-3-and-ruby-wierd-errors/113138/4 "2007-09-03T15:46:35Z")

</div>

Jeffrey ‘jf’ Lim wrote:

> > - make sure your sqlite3 gem is at least \_why’s version:
> > 
> > [http://redhanded.hobix.com/cult/sqlite3Gem\_whySSensibilitiesRepack.html](http://redhanded.hobix.com/cult/sqlite3Gem_whySSensibilitiesRepack.html)
> 
> I’m not so sure about an updated version from \_why, but this is like  
> from Oct 2006… Haven’t the changes been incorporated into Jamis’s  
> version already (see his comment as well)

I suspected as much - that’s why I said “at least”…