Rails Server Gem Load Error - SQlite3

Mike Clark from PragmaticStudio Solved this for me!

Ah, looks like it’s an issue with the sqlite3 v1.4.0 gem which was released on February 4. There’s a fix in the works:

https://github.com/rails/rails/issues/35153

In the meantime, you can fall back to v1.3.6 by adding that version to the “sqlite3” line in your Gemfile, like so:

gem "sqlite3", "~> 1.3.6”

Then make sure to “bundle install”.

Anyway, that solved the issue for me. I also found this helpful:

https://stackoverflow.com/questions/54527277/cant-activate-sqlite3-1-3-6-already-activated-sqlite3-1-4-0/54606137#54606137

Give that a try and see if it works for you.

There was a recent sqlite3 1.4.0 release which broke in current Rails version. The temporary workaround is to use old version of sqlite3 instead of 1.4.

For example, add this sqlite3 in your Gemfile:

gem 'sqlite3', '~> 1.3.0'

which will use version both >= 1.3 and < 1.4.