SQL 3 Lite Error

Mr_Watson · September 2, 2008, 12:55pm

Hello everyone,

In my controller, I put the following code:

render :text => "Hello World!"

It popped up with this error:

" MissingSourceFile in BlogController#index

no such file to load -- sqlite3

RAILS_ROOT: C:/InstantRails/rails_apps/scblog Application Trace | Framework Trace | Full Trace

c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ dependencies.rb:509:in `require' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ dependencies.rb:354:in `new_constants_in' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ dependencies.rb:509:in `require' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ core_ext/kernel/requires.rb:7:in `require_library_or_gem' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ core_ext/kernel/reporting.rb:11:in `silence_warnings' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ core_ext/kernel/requires.rb:5:in `require_library_or_gem' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/sqlite3_adapter.rb:10:in `sqlite3_connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/connection_specification.rb:292:in `send' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/connection_specification.rb:292:in `connection=' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/connection_specification.rb:260:in `retrieve_connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/connection_specification.rb:78:in `connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ query_cache.rb:8:in `cache' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ caching/sql_cache.rb:12:in `perform_action' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ base.rb:529:in `send' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ base.rb:529:in `process_without_filters' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ filters.rb:569:in `process_without_session_management_support' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ session_management.rb:130:in `process' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ base.rb:389:in `process' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:149:in `handle_request' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:107:in `dispatch' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:104:in `synchronize' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:104:in `dispatch' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:120:in `dispatch_cgi' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:35:in `dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb: 112:in `handle_dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:78:in `service' c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' c:/ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' c:/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' c:/ruby/lib/ruby/1.8/webrick/server.rb:95:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:92:in `each' c:/ruby/lib/ruby/1.8/webrick/server.rb:92:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:23:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:82:in `start' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:62:in `dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/commands/servers/ webrick.rb:66 c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ dependencies.rb:509:in `require' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ dependencies.rb:354:in `new_constants_in' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ dependencies.rb:509:in `require' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/commands/server.rb:39 c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' script/server:3

This error occurred while loading the following files: sqlite3

Request

Parameters:

None

Show session dump

Frederick_Cheung · September 2, 2008, 1:06pm

Can anyone tell me what it means? Do I have to restart the application to fix it? Any thoughts.

It's saying that it's configured to use sqlite3 as its database but
that you don't have the sqlite3 gem (which is called sqlite3-ruby).
After installing the gem (and sqlite3 itself if you don;t have that)
you will need to restart the app

Fred

Mr_Watson · September 2, 2008, 1:39pm

I installed it using the code:

gem install sqlite-ruby

I choose option 2) sqlite-ruby 2.2.3 (mswin32)

I am running Windows Vista (horrible).

It still is not working.

Martin_Eisenhardt · September 2, 2008, 1:43pm

Hi,

I installed it using the code:

gem install sqlite-ruby

please read the advice from Fred carefully: You have to install the
gem for sqlite3 (which is called sqlite3-ruby) and not the one for
sqlite before version 3 (which is what you did).

Do

$ sudo gem install sqlite3-ruby

and maybe (if you haven't done so already)

$ sudo apt-get install sqlite3 # or whatever your distribution/OS
requires ...

and you are ready to go.

HTH.

Kind regards Martin

Mr_Watson · September 2, 2008, 2:12pm

I typed the gem:

gem install sqlite3-ruby

and it says,

"Select which gem to install for your platform (i386-mswin32)

1. sqlite3-ruby 1.2.4 (ruby) 2. sqlite3-ruby 1.2.3 (x86-mingw32) 3. sqlite3-ruby 1.2.3 (mswin32) 4. sqlite3-ruby 1.2.3 (ruby) 5. Skip this gem 6. Cancel installation

Choice 1 and 4 gave me an error saying, "Building native extensions. This could take a while... ERROR: While executing gem... (Gem::Installer::ExtensionBuildError) ERROR: Failed to build gem native extension.

Choice 3 went through but did not work.

Mr_Watson · September 2, 2008, 2:16pm

Is there any way I can switch it to mysql?

Frederick_Cheung · September 2, 2008, 2:18pm

I typed the gem:

gem install sqlite3-ruby

and it says,

"Select which gem to install for your platform (i386-mswin32)

1. sqlite3-ruby 1.2.4 (ruby) 2. sqlite3-ruby 1.2.3 (x86-mingw32) 3. sqlite3-ruby 1.2.3 (mswin32) 4. sqlite3-ruby 1.2.3 (ruby) 5. Skip this gem 6. Cancel installation

Choice 1 and 4 gave me an error saying, "Building native extensions. This could take a while... ERROR: While executing gem... (Gem::Installer::ExtensionBuildError) ERROR: Failed to build gem native extension.

Choice 3 went through but did not work.

What's "did not work" ? Choice 3 is the right one for you.

Fred

Frederick_Cheung · September 2, 2008, 2:18pm

Is there any way I can switch it to mysql?

Yup. Install the mysql gem and update your database.yml (google for
some examples or do rails -d mysql to generate a fresh rails app set
to use mysql)

Fred

Mr_Watson · September 2, 2008, 2:21pm

I see the database.yml file is where you go to switch. Does anyone know what to put into this file? I am sure this is what you edit.

Mr_Watson · September 2, 2008, 2:44pm

When I put the code in:

ruby script/server

It prompts me with a message box saying, "This application has failed to start because sqlite3.dll was not found. Re-install the application may fix this problem."

But re-installing it doesn't. Geez.

Mr_Watson · September 2, 2008, 2:57pm

I started a new app, still nothing.

I tried updating mysqlite3, still nothing.

Jeff_Miller · September 2, 2008, 3:12pm

Frederick Cheung wrote:

Frederick_Cheung · September 2, 2008, 3:28pm

When I put the code in:

ruby script/server

It prompts me with a message box saying, "This application has failed to start because sqlite3.dll was not found. Re-install the application may fix this problem."

But re-installing it doesn't. Geez.

like i said you need sqlite3 itself as well as the gem. The message is
an unhelpful generic windows message. As Jeff says you can get the
sqlite3 dll from SQLite Download Page

fred

Mr_Watson · September 2, 2008, 4:00pm

I have InstantRails and it keeps the rail_apps and mysql seperated in different folders. I connect them via InstantRails. Well, I have done what you said and now its telling me,

" Mysql::Error in BlogController#index

Incorrect database name 'db/development.mysql'

RAILS_ROOT: C:/InstantRails/rails_apps/blog Application Trace | Framework Trace | Full Trace

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/mysql_adapter.rb:505:in `real_connect' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/mysql_adapter.rb:505:in `connect' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/mysql_adapter.rb:183:in `initialize' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/mysql_adapter.rb:88:in `new' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/mysql_adapter.rb:88:in `mysql_connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/connection_specification.rb:292:in `send' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/connection_specification.rb:292:in `connection=' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/connection_specification.rb:260:in `retrieve_connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/connection_specification.rb:78:in `connection' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ query_cache.rb:8:in `cache' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ caching/sql_cache.rb:12:in `perform_action' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ base.rb:529:in `send' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ base.rb:529:in `process_without_filters' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ filters.rb:569:in `process_without_session_management_support' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ session_management.rb:130:in `process' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ base.rb:389:in `process' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:149:in `handle_request' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:107:in `dispatch' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:104:in `synchronize' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:104:in `dispatch' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:120:in `dispatch_cgi' c:/ruby/lib/ruby/gems/1.8/gems/actionpack-2.1.0/lib/action_controller/ dispatcher.rb:35:in `dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb: 112:in `handle_dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:78:in `service' c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' c:/ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' c:/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' c:/ruby/lib/ruby/1.8/webrick/server.rb:95:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:92:in `each' c:/ruby/lib/ruby/1.8/webrick/server.rb:92:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:23:in `start' c:/ruby/lib/ruby/1.8/webrick/server.rb:82:in `start' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/webrick_server.rb:62:in `dispatch' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/commands/servers/ webrick.rb:66 c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ dependencies.rb:509:in `require' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ dependencies.rb:354:in `new_constants_in' c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.1.0/lib/active_support/ dependencies.rb:509:in `require' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/commands/server.rb:39 c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require' c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require' script/server:3

Request

Parameters:

None

Show session dump

Mr_Watson · September 2, 2008, 4:48pm

I got it. It was the database.yml file. I wasn't directing it to the correct database I made.

It had blog_development.mysql

Mine was only blog_development

Thank you all!

Topic		Replies	Views
problem : no such file to load -- sqlite3 rubyonrails-talk	1	128	November 11, 2008
no such file to load -- sqlite3 rubyonrails-talk	3	100	April 30, 2008
"no such file to load -- sqlite3" Rails rubyonrails-talk	21	769	November 15, 2011
New to RoR, need help with the application in Agile Web Development.... rubyonrails-talk	4	106	April 4, 2008
script/console sqlite3 rubyonrails-talk	3	121	June 30, 2008

SQL 3 Lite Error

Related topics

More Resources