Getting an sqlite error when migrating after heroku deployment

Question

So I deployed my app to Heroku and installed gem 'pg' and removed sqlite. Now getting this error when I migrate locally or on Heroku

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).

How can I fix this? Thanks

Deepak Mahakale · Accepted Answer · 2016-09-15 09:32:32Z

1

Add "sqlite3" in development and "pg" in production

group :development, :test do
  gem 'sqlite3'
end

group :production do
  gem 'pg'
end

answered Sep 15, 2016 at 9:32

Deepak Mahakale

23.8k10 gold badges73 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Malek Zalfana Over a year ago

Now I got this error SQLite3::SQLException: duplicate column name: parent_id: ALTER TABLE "comments" ADD "parent_id" integer, I tried drop:all then create then migrate but sme error

Deepak Mahakale Over a year ago

try heroku run rake db:setup

Malek Zalfana Over a year ago

Just :reset my database and the migration is working fine but still getting the error but now only in the view. Which is.. ActionView::Template::Error (undefined method `bio' for #<User:0x007fe52478d2d0>):

Deepak Mahakale Over a year ago

I think I have already posted answer for this error stackoverflow.com/a/39500764/4758119

Collectives™ on Stack Overflow

Getting an sqlite error when migrating after heroku deployment

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related