sqlite3 has gone...

rubyonrails-talk
1

Hi all,

I'm struggling since hours with sqlite3. Maybe I'm wrong to post here, as I feel the problem is not directly related to rails.

After a "gem clean" this morning, mongrel doesn't want to start anymore:

/Library/Ruby/Site/1.8/rubygems/custom_require.rb:36:in `gem_original_require': no such file to load -- sqlite3 (MissingSourceFile)

But sqlite3-ruby is well installed under gem (I reinstalled to be sure, desinstalled, resinstalled, etc) but it can't be loaded: ruby - rubygems -e "require 'sqlite3'" returns the same error as above. It loads well if I cd in the sqlite directory.

Here is my gem env:

2

In case it helps someone, I removed /Library/Ruby and reinstalled everything. Strange bug...

Jej

3

Hi all

I've the same problem since this morning. Trying to uninstall/install didn't do the trick.

The only thing i've done since this yesterday (all work fine yesterday) is installing updating datamapper.

If anyone has some clues or tips to help me.

4

Some precision : launching the same command in the sqlite3 gem work. I install sqlite3 gem iin my local gem path (~/.gem/ruby/1.8/gems) but the result is the same

5

Hi,

this is closely related to datamapper and data_objects. It happened to me yesterday when installed Integrity app and it was *quite* nasty (no such file... in every Rake task etc).

Solution which has worked for me was from namelessjohn at #sinatra@freenode [1]:

namelessjon_ # karmi_: sudo rm /path/to/gems/do_sqlite-0.9.7/lib/ sqlite3.dll

Apparently do_sqlite3 gets into the path somehow.

--karmi

[1] http://irclogger.com/sinatra/2008-11-20

6

It work for me too.

Big thanks for the help.

I think I couldn't find it alone.

7

After reflecting here what iI think,

In fact when you use rubygems it add all lib folder of each gem to the load path. So when you require sqlite3 the system try loading all or the first file the file named sqlite3 exinsting in the load path and loading a dll file on a system different than windows cause an error.

8

I found this at http://www.rubyhead.com/2008/11/25/no-such-file-to-load-sqlite3-on-rails-22/ for me, it also turned out that

o_sqlite3 gem that came with Merb caused this problem. The solution is to get rid of this gem by running "sudo gem >uninstall do_sqlite3″. However, if you're running JRuby and have Merb installed, this won't work.

it also worked to add

gem 'sqlite3-ruby'

to my environment.rb file from no such file to load -- sqlite3 - RubyFlow

9

for me two different things worked. adding   gem 'sqlite3-ruby' to my environment.rb file. from post at:http://www.rubyflow.com/items/ 1252

or remove a problem with a merb gem by

sudo gem uninstall do_sqlite3

from a post at http://www.rubyhead.com/2008/11/25/no-such-file-to-load-sqlite3-on-rails-22/