sqlite3 problem

[mikeglaz]

I just started my rails shovell application. When I point my browser to http:localhost:3000/[/url] and click on Welcome Aboard: About Your Application's Environment I get the following error instead of the version list mentioned in the book:

MissingSourceFile in Rails/infoController#properties

no such file to load -- sqlite3/database

RAILS_ROOT: /home/mike/RailsApps/shovell
Application Trace | Framework Trace | Full Trace


This error occurred while loading the following files:
sqlite3
sqlite3/database

Any ideas?

[madpilot]

Have you installed sqlite3?

Try running "sudo gem install sqlite3-ruby" and then trying again (This may only work if you have the correct development tools installed - are you on Linux, MacOSX or Windows?)

[mikeglaz]

I'm on Linux and already installed sqlite3-ruby.

[Mittineague]

While in the /home/mike/RailsApps directory, did you use the ruby command
rails shovell
to create the shovell directory?
And your
database.yml
file is OK?

[chris97]

I was having the same problem. Came across this post elsewhere in the forum:

I had the 1.2.2 version of sqlite3-ruby. I did:

sudo gem uninstall sqlite3-ruby
and then
sudo gem install sqlite3-ruby -v=1.2.1

(I use a Mac and had to preface both commands with "sudo")

Basically, he rolled sqlite3-ruby back from version 1.2.2 to 1.2.1.

That fixed it for me.

[MystaMax]

This is a permissions issue with the sqlite3 1.2.2 gem. I had the same problem today on ubuntu 8.04. To fix follow the steps below:

1. navigate to /usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.2

cd /usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.2

2. you have to change the permissions of the files in this directory, use the snippet below:

sudo find . -perm 0662 -exec chmod 664 {} \;

The above works for MacOSX as well. The gems folder is at a different location:

/usr/local/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.2

Now there is no need to unistall 1.2.2 and install 1.2.1!

Sources for fix:
Ubuntu - http://www.red91.com/2008/07/20/no-s...lite3-database
MacOSX - http://www.icoretech.org/2008/07/06/...lite3-database

Hope this saves someone some trouble, I was about to pull my hair out. I've got dreds, lol.