Forum: Ruby on Rails sqlite3/sqlite3_native (LoadError)

6def97c4b9eba29b9cdd653bcf1eae8c?d=identicon&s=25 Dani Dani (laguna53)
on 2010-09-05 00:43
Hi,
I have installed ruby 1.9.2, rubygems 1.3.7 and rails 3.0. created a
demo application. when I start 'rails server' I get:
'require': no such file to load -- sqlite3/sqlite3_native (LoadError)

any idea ?

Thank you.

Dani
6def97c4b9eba29b9cdd653bcf1eae8c?d=identicon&s=25 Dani Dani (laguna53)
on 2010-09-05 12:11
Hi,
here is some more information. I'm using windows xp, sp3.
Here is the content of the sqlite3.rb file where the error comes from:
=============================================================
# support multiple ruby version (fat binaries under windows)
begin
  RUBY_VERSION =~ /(\d+.\d+)/
  require "sqlite3/#{$1}/sqlite3_native"
rescue LoadError
  require 'sqlite3/sqlite3_native'        <------ THIS LINE CAUSES THE
ERROR
end

require 'sqlite3/database'
require 'sqlite3/version'
=============================================================

Can't go on working. Appreciat any help. Thanky.

Dani
6def97c4b9eba29b9cdd653bcf1eae8c?d=identicon&s=25 Dani Dani (laguna53)
on 2010-09-05 14:11
Hi,
the above appears when I do:
C:\Rails\first_app>rails server
C:/Ruby192/lib/ruby/gems/1.9.1/gems/sqlite3-ruby-1.3.1-x86-mingw32/lib/sqlite3.rb:6:in
`require': no such file to load -- sqlite3/sqlite3_native (LoadError)

Need hellllp. thanks.
dani
6def97c4b9eba29b9cdd653bcf1eae8c?d=identicon&s=25 Dani Dani (laguna53)
on 2010-09-05 18:54
Ok, found the problem causig this:
I had to set --> gem 'sqlite3-ruby', '1.2.5', :require => 'sqlite3'

in the Gemfile and comment out:
gem 'sqlite3-ruby', :require => 'sqlite3'
83329afdf0b2029dd65ec0c5161062e8?d=identicon&s=25 nktokyo (Guest)
on 2010-09-06 16:39
(Received via mailing list)
Does the file exist?

I can't help much on windows, but have resolved similar issues on UNIX
with a full path, not a relative path.
03633bd81040819534a3b204a39de043?d=identicon&s=25 Erling Wegger Linde (Guest)
on 2010-09-18 22:23
(Received via mailing list)
After a lot of debugging I tried to add

puts RUBY_VERSION

sqlite3.rb file. This made me realized rails was somehow running an
old jruby version. After even more debugging I realized I was actually
running rails for jruby (hint: which rails, cat the rails file and
look for #!..jruby in the top of the file). Reinstalling rails did the
trick..
03633bd81040819534a3b204a39de043?d=identicon&s=25 Erling Wegger Linde (Guest)
on 2010-09-18 22:23
(Received via mailing list)
I got a similar error when installing ruby 1.9.2 for the first time.
After a lot of frustration I finally discovered that when I added

puts RUBY_VERSION

into the sqlite3.rb file, that rails somehow was using an old jruby
version I had installed previously. After even more debugging I opened
the the rails executable (which rails) and found it was actually
declaring something like #!..jruby. So somehow I must have installed
the rails gem for jruby.. Uninstalling and reinstalling rails did the
trick... Not sure how likely it is that anyone will have the same
issue as I had though :P

Cheers,
944f085fd19cfeca28ce8693e36d5473?d=identicon&s=25 Guillaume N. (guillaume_n)
on 2011-01-27 20:48
For me, I had to download and move the
sqlite3.exe
sqlite3.dll

into a folder in my path, like C:/Windows or for me c:/Ruby 1.9.2/bin/

Hope that helps
5c087c6a1b61f6080ed2bc81787e0fbc?d=identicon&s=25 Andi Geheim (chaosbanane)
on 2011-02-12 19:26
Guillaume N. wrote in post #977959:
> For me, I had to download and move the
> sqlite3.exe
> sqlite3.dll
>
> into a folder in my path, like C:/Windows or for me c:/Ruby 1.9.2/bin/
>
> Hope that helps

Thanks! Downloading the two files and putting them in the bin folder
solved my problem, too.

http://www.sqlite.org/download.html
Please log in before posting. Registration is free and takes only a minute.
Existing account

NEW: Do you have a Google/GoogleMail, Yahoo or Facebook account? No registration required!
Log in with Google account | Log in with Yahoo account | Log in with Facebook account
No account? Register here.