# Script/console sqlite3

**URL:** <https://www.ruby-forum.com/t/script-console-sqlite3/141832>\
**Category:** Rails\
**Created:** [June 30, 2008, 10:24pm UTC](https://www.ruby-forum.com/t/script-console-sqlite3/141832 "2008-06-30T22:24:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasonmorrison](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/47e85d/32.png) [@jasonmorrison](https://www.ruby-forum.com/u/jasonmorrison)\
**Post date:** [June 30, 2008, 10:24pm UTC](https://www.ruby-forum.com/t/script-console-sqlite3/141832/1 "2008-06-30T22:24:35Z")

</div>

I hope this is in the right place, if not just point me to the right  
place, please.

I’m running through this tutorial:  
[http://developer.apple.com/tools/developonrailsleopard.html](http://developer.apple.com/tools/developonrailsleopard.html)

and everything went swimmingly until I got to the point where I had to  
do some db stuff in script/console. I enter what the tutorial tells me  
to

vendor1 = Vendor.create(:name =\> ‘Parties R Us’)

… and I’m supposed to get back

=\> #\<Vendor id: 1, name: “Parties R Us”, …\>

… but instead I get this mess:

MissingSourceFile: no such file to load – sqlite3/database  
from  
/usr/local/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:32:in  
`gem_original_require' from /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:32:in `require’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active\_support/dependencies.rb:509:in  
`require' from /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/dependencies.rb:354:in `new\_constants\_in’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active\_support/dependencies.rb:509:in  
`require' from /usr/local/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.2/lib/sqlite3.rb:1 from /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem\_original\_require’  
from  
/usr/local/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:27:in  
`require' from /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/dependencies.rb:509:in `require’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active\_support/dependencies.rb:354:in  
`new_constants_in' from /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/dependencies.rb:509:in `require’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active\_support/core\_ext/kernel/requires.rb:7:in  
`require_library_or_gem' from /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/core_ext/kernel/reporting.rb:11:in `silence\_warnings’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active\_support/core\_ext/kernel/requires.rb:5:in  
`require_library_or_gem' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/sqlite3_adapter.rb:10:in `sqlite3\_connection’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:292:in  
`send' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/connection_specification.rb:292:in `connection=’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:260:in  
`retrieve_connection' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in `connection’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/base.rb:1145:in  
`columns' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2598:in `attributes\_from\_column\_definition\_without\_lock’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/locking/optimistic.rb:55:in  
`attributes_from_column_definition' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:2126:in `initialize’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/base.rb:638:in  
`new' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/base.rb:638:in `create’  
from (irb):7\>\>

Help!

---

<div class="post-metadata">

**Author:** ![jasonmorrison](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/47e85d/32.png) [@jasonmorrison](https://www.ruby-forum.com/u/jasonmorrison)\
**Post date:** [June 30, 2008, 10:32pm UTC](https://www.ruby-forum.com/t/script-console-sqlite3/141832/2 "2008-06-30T22:32:41Z")

</div>

On Mon, Jun 30, 2008 at 3:24 PM, Jason Mayoff  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> … but instead I get this mess:

You mean a stack trace?

> MissingSourceFile: no such file to load – sqlite3/database

[http://groups.google.com/group/rubyonrails-talk/msg/366ae75593ed8b46](http://groups.google.com/group/rubyonrails-talk/msg/366ae75593ed8b46)

–  
Greg D.  
[http://destiney.com/](http://destiney.com/)

---

<div class="post-metadata">

**Author:** ![jasonmorrison](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/47e85d/32.png) [@jasonmorrison](https://www.ruby-forum.com/u/jasonmorrison)\
**Post date:** [June 30, 2008, 10:37pm UTC](https://www.ruby-forum.com/t/script-console-sqlite3/141832/3 "2008-06-30T22:37:24Z")

</div>

> [http://groups.google.com/group/rubyonrails-talk/msg/366ae75593ed8b46](http://groups.google.com/group/rubyonrails-talk/msg/366ae75593ed8b46)

This worked, thanks.

---

<div class="post-metadata">

**Author:** ![jasonmorrison](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/47e85d/32.png) [@jasonmorrison](https://www.ruby-forum.com/u/jasonmorrison)\
**Post date:** [June 30, 2008, 10:39pm UTC](https://www.ruby-forum.com/t/script-console-sqlite3/141832/4 "2008-06-30T22:39:43Z")

</div>

Out of curiousity, is sqlite3 installed?

Also, is the ruby adapter for sqlite3 installed?

And if the answer to both of those is correct, did you remember to do  
the migration (rake db:migrate)?

Matt