rails sを入力してもsqlite3のエラーがでる

Question

rails sを入力してもsqlite3のエラーが出てしまいます。
OS windows10 surface pro4 64bit
ruby 2.6.3p62 (2019-04-16 revision 67580) [x64-mingw32]
rails 5.0.7.2
sqlite3 3.28.0 2019-04-16 19:49:53 884b4b7e502b4e991677b53971277adfaf0a04a284f8e483e2553d0f83156b50

#コマンドプロンプト
C:\Users\sinta\sin_app>rails s
=> Booting Puma
=> Rails 5.0.7.2 application starting in development on http://localhost:3000
=> Run rails server -h for more startup options
*** SIGUSR2 not implemented, signal based restart unavailable!
*** SIGUSR1 not implemented, signal based restart unavailable!
*** SIGHUP not implemented, signal based logs reopening unavailable!
Puma starting in single mode...

• Version 3.12.1 (ruby 2.6.3-p62), codename: Llamas in Pajamas
• Min threads: 5, max threads: 5
• Environment: development
• Listening on tcp://localhost:3000

Use Ctrl-C to stop
Started GET "/" for ::1 at 2019-05-18 21:42:32 +0900

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

activerecord (5.0.7.2) lib/active_record/connection_adapters/connection_specification.rb:176:in rescue in spec' activerecord (5.0.7.2) lib/active_record/connection_adapters/connection_specification.rb:173:in spec'
activerecord (5.0.7.2) lib/active_record/connection_handling.rb:53:in establish_connection' activerecord (5.0.7.2) lib/active_record/railtie.rb:125:in block (2 levels) in class:Railtie'
activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:69:in instance_eval' activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:69:in block in execute_hook'
activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:60:in with_execution_control' activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:65:in execute_hook'
activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:50:in block in run_load_hooks' activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:49:in each'
activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:49:in run_load_hooks' activerecord (5.0.7.2) lib/active_record/base.rb:324:in module:ActiveRecord'
activerecord (5.0.7.2) lib/active_record/base.rb:24:in <top (required)>' activesupport (5.0.7.2) lib/active_support/dependencies.rb:293:in require'
activesupport (5.0.7.2) lib/active_support/dependencies.rb:293:in block in require' activesupport (5.0.7.2) lib/active_support/dependencies.rb:259:in load_dependency'
activesupport (5.0.7.2) lib/active_support/dependencies.rb:293:in require' activerecord (5.0.7.2) lib/active_record/migration.rb:559:in connection'
activerecord (5.0.7.2) lib/active_record/migration.rb:546:in call' actionpack (5.0.7.2) lib/action_dispatch/middleware/callbacks.rb:38:in block in call'
activesupport (5.0.7.2) lib/active_support/callbacks.rb:97:in __run_callbacks__' activesupport (5.0.7.2) lib/active_support/callbacks.rb:750:in _run_call_callbacks'
activesupport (5.0.7.2) lib/active_support/callbacks.rb:90:in run_callbacks' actionpack (5.0.7.2) lib/action_dispatch/middleware/callbacks.rb:36:in call'
actionpack (5.0.7.2) lib/action_dispatch/middleware/executor.rb:12:in call' actionpack (5.0.7.2) lib/action_dispatch/middleware/remote_ip.rb:79:in call'
actionpack (5.0.7.2) lib/action_dispatch/middleware/debug_exceptions.rb:49:in call' web-console (3.7.0) lib/web_console/middleware.rb:135:in call_app'
web-console (3.7.0) lib/web_console/middleware.rb:30:in block in call' web-console (3.7.0) lib/web_console/middleware.rb:20:in catch'
web-console (3.7.0) lib/web_console/middleware.rb:20:in call' actionpack (5.0.7.2) lib/action_dispatch/middleware/show_exceptions.rb:31:in call'
railties (5.0.7.2) lib/rails/rack/logger.rb:36:in call_app' railties (5.0.7.2) lib/rails/rack/logger.rb:24:in block in call'
activesupport (5.0.7.2) lib/active_support/tagged_logging.rb:69:in block in tagged' activesupport (5.0.7.2) lib/active_support/tagged_logging.rb:26:in tagged'
activesupport (5.0.7.2) lib/active_support/tagged_logging.rb:69:in tagged' railties (5.0.7.2) lib/rails/rack/logger.rb:24:in call'
sprockets-rails (3.2.1) lib/sprockets/rails/quiet_assets.rb:13:in call' actionpack (5.0.7.2) lib/action_dispatch/middleware/request_id.rb:24:in call'
rack (2.0.7) lib/rack/method_override.rb:22:in call' rack (2.0.7) lib/rack/runtime.rb:22:in call'
activesupport (5.0.7.2) lib/active_support/cache/strategy/local_cache_middleware.rb:28:in call' actionpack (5.0.7.2) lib/action_dispatch/middleware/executor.rb:12:in call'
actionpack (5.0.7.2) lib/action_dispatch/middleware/static.rb:136:in call' rack (2.0.7) lib/rack/sendfile.rb:111:in call'
railties (5.0.7.2) lib/rails/engine.rb:522:in call' puma (3.12.1) lib/puma/configuration.rb:227:in call'
puma (3.12.1) lib/puma/server.rb:660:in handle_request' puma (3.12.1) lib/puma/server.rb:474:in process_client'
puma (3.12.1) lib/puma/server.rb:334:in block in run' puma (3.12.1) lib/puma/thread_pool.rb:135:in block in spawn_thread'
Rendering C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/diagnostics.html.erb within rescues/layout
Rendering C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/_source.html.erb
Rendered C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/_source.html.erb (6.7ms)
Rendering C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/_trace.html.erb
Rendered C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/_trace.html.erb (5.4ms)
Rendering C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/_request_and_response.html.erb
Rendered C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/_request_and_response.html.erb (4.5ms)
Rendered C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/diagnostics.html.erb within rescues/layout (117.8ms)

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

#試したこと
sqlite3.dllとsqlite3.exeの入れ直し

Answer 1

Add gem 'sqlite3' to your Gemfile (and ensure its version is at the minimum required by ActiveRecord).):```

と記載があるので、Gemfileに```gem 'sqlite3'```を記載、その後、ターミナルで```$ bundle install```してみてはいかがでしょうか？

Comments

[s-a0202]

記載してみたのですがだめでした、、
以下gemfileです
source 'https://rubygems.org'

git_source(:github) do |repo_name|
repo_name = "#{repo_name}/#{repo_name}" unless repo_name.include?("/")
"https://github.com/#{repo_name}.git"
end

# Bundle edge Rails instead: gem 'rails', github: 'rails/rails'
gem 'rails', '~> 5.0.7', '>= 5.0.7.2'
# Use sqlite3 as the database for Active Record
gem 'sqlite3','1.3.13'
# Use Puma as the app server
gem 'puma', '~> 3.0'
# Use SCSS for stylesheets
gem 'sass-rails', '~> 5.0'
# Use Uglifier as compressor for JavaScript assets
gem 'uglifier', '>= 1.3.0'
# Use CoffeeScript for .coffee assets and views
gem 'coffee-rails', '~> 4.2'
# See https://github.com/rails/execjs#readme for more supported runtimes
# gem 'therubyracer', platforms: :ruby

# Use jquery as the JavaScript library
gem 'jquery-rails'
# Turbolinks makes navigating your web application faster. Read more: https://github.com/turbolinks/turbolinks
gem 'turbolinks', '~> 5'
# Build JSON APIs with ease. Read more: https://github.com/rails/jbuilder
gem 'jbuilder', '~> 2.5'
# Use Redis adapter to run Action Cable in production
# gem 'redis', '~> 3.0'
# Use ActiveModel has_secure_password
# gem 'bcrypt', '~> 3.1.7'

# Use Capistrano for deployment
# gem 'capistrano-rails', group: :development

group :development, :test do
# Call 'byebug' anywhere in the code to stop execution and get a debugger console
gem 'byebug', platform: :mri
end

group :development do
# Access an IRB console on exception pages or by using <%= console %> anywhere in the code.
gem 'web-console', '>= 3.3.0'
end

# Windows does not include zoneinfo files, so bundle the tzinfo-data gem
gem 'tzinfo-data', platforms: [:mingw, :mswin, :x64_mingw, :jruby]

[no1knows]

エラーの内容は、変わりましたか？

[s-a0202]

以下、rails sを実行した結果です。
Traceback (most recent call last):
17: from bin/rails:4:in `<main>'
16: from bin/rails:4:in `require'
15: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/railties-5.0.7.2/lib/rails/commands.rb:18:in `<top (required)>'
14: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/railties-5.0.7.2/lib/rails/commands/commands_tasks.rb:49:in `run_command!'
13: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/railties-5.0.7.2/lib/rails/commands/commands_tasks.rb:85:in `server'
12: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/railties-5.0.7.2/lib/rails/commands/commands_tasks.rb:85:in `tap'
11: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/railties-5.0.7.2/lib/rails/commands/commands_tasks.rb:88:in `block in server'
10: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/railties-5.0.7.2/lib/rails/commands/commands_tasks.rb:88:in `require'
9: from C:/Users/sinta/sin_app/config/application.rb:7:in `<top (required)>'
8: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler.rb:114:in `require'
7: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler/runtime.rb:65:in `require'
6: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler/runtime.rb:65:in `each'
5: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler/runtime.rb:76:in `block in require'
4: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler/runtime.rb:76:in `each'
3: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler/runtime.rb:81:in `block (2 levels) in require'
2: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler/runtime.rb:81:in `require'
1: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/sqlite3-1.3.13-x64-mingw32/lib/sqlite3.rb:4:in `<top (required)>'
C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/sqlite3-1.3.13-x64-mingw32/lib/sqlite3.rb:4:in `require': cannot load such file -- sqlite3/2.6/sqlite3_native (LoadError)
18: from bin/rails:4:in `<main>'
17: from bin/rails:4:in `require'
16: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/railties-5.0.7.2/lib/rails/commands.rb:18:in `<top (required)>'
15: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/railties-5.0.7.2/lib/rails/commands/commands_tasks.rb:49:in `run_command!'
14: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/railties-5.0.7.2/lib/rails/commands/commands_tasks.rb:85:in `server'
13: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/railties-5.0.7.2/lib/rails/commands/commands_tasks.rb:85:in `tap'
12: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/railties-5.0.7.2/lib/rails/commands/commands_tasks.rb:88:in `block in server'
11: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/railties-5.0.7.2/lib/rails/commands/commands_tasks.rb:88:in `require'
10: from C:/Users/sinta/sin_app/config/application.rb:7:in `<top (required)>'
9: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler.rb:114:in `require'
8: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler/runtime.rb:65:in `require'
7: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler/runtime.rb:65:in `each'
6: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler/runtime.rb:76:in `block in require'
5: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler/runtime.rb:76:in `each'
4: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler/runtime.rb:81:in `block (2 levels) in require'
3: from C:/Ruby26-x64/lib/ruby/2.6.0/bundler/runtime.rb:81:in `require'
2: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/sqlite3-1.3.13-x64-mingw32/lib/sqlite3.rb:2:in `<top (required)>'
1: from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/sqlite3-1.3.13-x64-mingw32/lib/sqlite3.rb:6:in `rescue in <top (required)>'
C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/sqlite3-1.3.13-x64-mingw32/lib/sqlite3.rb:6:in `require': cannot load such file -- sqlite3/sqlite3_native (LoadError)

[no1knows]

C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/sqlite3-1.3.13-x64-mingw32/lib/sqlite3.rb:4:in `require': cannot load such file -- sqlite3/2.6/sqlite3_native (LoadError)
GemfileのSQL3で指定した1.3.13のバージョンのファイルがありませんと記載されています。

Gemfileを
gem 'sqlite3','1.3.13'(1.3.13のバージョン指定)から
gem 'sqlite3'(バージョン指定なし)に変えるとどうでしょうか？

[s-a0202]

バージョン指定なしで試してみたのですが同じエラーでした、
一度sqlite3をアンインストールして、インストールした後rails sを実行したらまたエラーが出てしまいます。
C:\Users\sinta\sin_app>gem uninstall sqlite3
Successfully uninstalled sqlite3-1.3.13-x64-mingw32
Successfully uninstalled sqlite3-1.4.1

C:\Users\sinta\sin_app>gem install sqlite3
Fetching sqlite3-1.4.1.gem
Temporarily enhancing PATH for MSYS/MINGW...
Installing required msys2 packages: mingw-w64-x86_64-sqlite3
警告: mingw-w64-x86_64-sqlite3-3.23.1-1 は最新です -- スキップ
Building native extensions. This could take a while...
Successfully installed sqlite3-1.4.1
Parsing documentation for sqlite3-1.4.1
Installing ri documentation for sqlite3-1.4.1
Done installing documentation for sqlite3 after 1 seconds
1 gem installed

C:\Users\sinta\sin_app>rails s
=> Booting Puma
=> Rails 5.0.7.2 application starting in development on http://localhost:3000
=> Run `rails server -h` for more startup options
*** SIGUSR2 not implemented, signal based restart unavailable!
*** SIGUSR1 not implemented, signal based restart unavailable!
*** SIGHUP not implemented, signal based logs reopening unavailable!
Puma starting in single mode...
* Version 3.12.1 (ruby 2.6.3-p62), codename: Llamas in Pajamas
* Min threads: 5, max threads: 5
* Environment: development
* Listening on tcp://localhost:3000
Use Ctrl-C to stop
Started GET "/" for ::1 at 2019-05-21 00:25:36 +0900

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

activerecord (5.0.7.2) lib/active_record/connection_adapters/connection_specification.rb:176:in `rescue in spec'
activerecord (5.0.7.2) lib/active_record/connection_adapters/connection_specification.rb:173:in `spec'
activerecord (5.0.7.2) lib/active_record/connection_handling.rb:53:in `establish_connection'
activerecord (5.0.7.2) lib/active_record/railtie.rb:125:in `block (2 levels) in <class:Railtie>'
activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:69:in `instance_eval'
activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:69:in `block in execute_hook'
activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:60:in `with_execution_control'
activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:65:in `execute_hook'
activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:50:in `block in run_load_hooks'
activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:49:in `each'
activesupport (5.0.7.2) lib/active_support/lazy_load_hooks.rb:49:in `run_load_hooks'
activerecord (5.0.7.2) lib/active_record/base.rb:324:in `<module:ActiveRecord>'
activerecord (5.0.7.2) lib/active_record/base.rb:24:in `<top (required)>'
activesupport (5.0.7.2) lib/active_support/dependencies.rb:293:in `require'
activesupport (5.0.7.2) lib/active_support/dependencies.rb:293:in `block in require'
activesupport (5.0.7.2) lib/active_support/dependencies.rb:259:in `load_dependency'
activesupport (5.0.7.2) lib/active_support/dependencies.rb:293:in `require'
activerecord (5.0.7.2) lib/active_record/migration.rb:559:in `connection'
activerecord (5.0.7.2) lib/active_record/migration.rb:546:in `call'
actionpack (5.0.7.2) lib/action_dispatch/middleware/callbacks.rb:38:in `block in call'
activesupport (5.0.7.2) lib/active_support/callbacks.rb:97:in `__run_callbacks__'
activesupport (5.0.7.2) lib/active_support/callbacks.rb:750:in `_run_call_callbacks'
activesupport (5.0.7.2) lib/active_support/callbacks.rb:90:in `run_callbacks'
actionpack (5.0.7.2) lib/action_dispatch/middleware/callbacks.rb:36:in `call'
actionpack (5.0.7.2) lib/action_dispatch/middleware/executor.rb:12:in `call'
actionpack (5.0.7.2) lib/action_dispatch/middleware/remote_ip.rb:79:in `call'
actionpack (5.0.7.2) lib/action_dispatch/middleware/debug_exceptions.rb:49:in `call'
web-console (3.7.0) lib/web_console/middleware.rb:135:in `call_app'
web-console (3.7.0) lib/web_console/middleware.rb:30:in `block in call'
web-console (3.7.0) lib/web_console/middleware.rb:20:in `catch'
web-console (3.7.0) lib/web_console/middleware.rb:20:in `call'
actionpack (5.0.7.2) lib/action_dispatch/middleware/show_exceptions.rb:31:in `call'
railties (5.0.7.2) lib/rails/rack/logger.rb:36:in `call_app'
railties (5.0.7.2) lib/rails/rack/logger.rb:24:in `block in call'
activesupport (5.0.7.2) lib/active_support/tagged_logging.rb:69:in `block in tagged'
activesupport (5.0.7.2) lib/active_support/tagged_logging.rb:26:in `tagged'
activesupport (5.0.7.2) lib/active_support/tagged_logging.rb:69:in `tagged'
railties (5.0.7.2) lib/rails/rack/logger.rb:24:in `call'
sprockets-rails (3.2.1) lib/sprockets/rails/quiet_assets.rb:13:in `call'
actionpack (5.0.7.2) lib/action_dispatch/middleware/request_id.rb:24:in `call'
rack (2.0.7) lib/rack/method_override.rb:22:in `call'
rack (2.0.7) lib/rack/runtime.rb:22:in `call'
activesupport (5.0.7.2) lib/active_support/cache/strategy/local_cache_middleware.rb:28:in `call'
actionpack (5.0.7.2) lib/action_dispatch/middleware/executor.rb:12:in `call'
actionpack (5.0.7.2) lib/action_dispatch/middleware/static.rb:136:in `call'
rack (2.0.7) lib/rack/sendfile.rb:111:in `call'
railties (5.0.7.2) lib/rails/engine.rb:522:in `call'
puma (3.12.1) lib/puma/configuration.rb:227:in `call'
puma (3.12.1) lib/puma/server.rb:660:in `handle_request'
puma (3.12.1) lib/puma/server.rb:474:in `process_client'
puma (3.12.1) lib/puma/server.rb:334:in `block in run'
puma (3.12.1) lib/puma/thread_pool.rb:135:in `block in spawn_thread'
Rendering C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/diagnostics.html.erb within rescues/layout
Rendering C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/_source.html.erb
Rendered C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/_source.html.erb (2.5ms)
Rendering C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/_trace.html.erb
Rendered C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/_trace.html.erb (3.6ms)
Rendering C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/_request_and_response.html.erb
Rendered C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/_request_and_response.html.erb (1.6ms)
Rendered C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/actionpack-5.0.7.2/lib/action_dispatch/middleware/templates/rescues/diagnostics.html.erb within rescues/layout (105.5ms)

[odyu]

C:\Users\sinta\sin_app>gem install sqlite3

↓

C:\Users\sinta\sin_app>bundle install

ではないですか？