SQLite3 and ‘No Such File to Load’ errors

While I was playing with Rails 2.1 I decided to try the SQLite3 support that comes built into OS X instead of using MySQL. Upon trying to run a migrate command via rake I was created with:

	rake aborted!
	no such file to load -- sqlite3/database

After some digging around I found out that (for at least a few people) having the sqlite3-ruby-1.2.2 gem installed creates this problem… The following resolved it:

	gem uninstall sqlite3-ruby

	Select gem to uninstall:
	 1. sqlite3-ruby-1.2.1
	 2. sqlite3-ruby-1.2.2
	 3. All versions
	> 3

	daorriss$ sudo gem install sqlite3-ruby -v=1.2.1
	Building native extensions.  This could take a while...
	Successfully installed sqlite3-ruby-1.2.1
	1 gem installed
	Installing ri documentation for sqlite3-ruby-1.2.1...
	Installing RDoc documentation for sqlite3-ruby-1.2.1...

After that rake db:migrate worked without a hitch. But if anyone could tell me what could cause the problem with sqlite3-ruby-1.2.2 I’d appreciate it.. 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.