Updating Rails 4.2 to 5.0.0 & sqlite3 gem will not load

Question

When running rails server, I load this warning:

Gem::LoadError: Specified 'sqlite3' for database adapter, but the gem is not loaded. Add `gem 'sqlite3'` to your Gemfile (and ensure its version is at the minimum required by ActiveRecord).

Yet my gemfile has the gem

 group :development do
   gem 'sqlite3'

What is causing this error?

Using instructions for rails update from here https://edgeguides.rubyonrails.org/upgrading_ruby_on_rails.html#upgrading-from-rails-4-2-to-rails-5-0

Deleted gem sqlite3 ( v 1.4.0 ) and installed it with version 1.3.13 & it worked — GMarx, Feb 10 '19 at 22:31

score 2 · Answer 1 · answered Feb 10 '19 at 22:32

2

Deleted gem sqlite3 ( v 1.4.0 ) and installed it with version 1.3.13 & it worked

answered Feb 10 '19 at 22:32

GMarx

473
3
13

score 1 · Accepted Answer · answered Feb 11 '19 at 00:22

1

gem cleanup sqlite3

And

bundle install

to let Rails choose right version of sqlite3

answered Feb 11 '19 at 00:22

William Tran

269
1
4

score 1 · Answer 3 · answered Jun 20 '19 at 10:26

1

Have the same problem in AWS cloud9 environment. You need to change your gemfile to read gem 'sqlite3', '~> 1.3.6' then run bundle update. got this from "can't activate sqlite3 (~> 1.3.6), already activated sqlite3-1.4.0"

answered Jun 20 '19 at 10:26

Zolani Matebese

11
1

Updating Rails 4.2 to 5.0.0 & sqlite3 gem will not load

3 Answers3