Hi,
When I try to run a controller that connects to my project''s sqlite
database, I get the following exception:
SQLite3::CantOpenException in PostController#index
could not open database
config/database.yml correctly points to my database, like so:
development:
adapter: sqlite3
database: db/dev.db
I''ve had Rails projects working with sqlite3 before (recently), but
starting any new projects has always lead to this error. I can''t figure
out what''s making the difference between the working and broken
projects...
Here is the full trace:
/usr/lib/ruby/1.8/sqlite3/errors.rb:94:in ''check''
/usr/lib/ruby/1.8/sqlite3/database.rb:112:in ''initialize''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/sqlite_adapter.rb:17:in
''sqlite3_connection''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:251:in
''connection_without_query_cache=''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/query_cache.rb:54:in
''connection=''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:220:in
''retrieve_connection''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in
''connection''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1046:in
''add_limit!''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:1017:in
''construct_finder_sql''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:924:in
''find_every''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/base.rb:381:in
''find''
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/deprecated_finders.rb:37:in
''find_all''
#{RAILS_ROOT}/app/controllers/post_controller.rb:4:in ''index''
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/base.rb:941:in
''perform_action_without_filters''
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/filters.rb:368:in
''perform_action_without_benchmark''
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/benchmarking.rb:69:in
''perform_action_without_rescue''
/usr/lib/ruby/1.8/benchmark.rb:293:in ''measure''
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/benchmarking.rb:69:in
''perform_action_without_rescue''
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/rescue.rb:82:in
''perform_action''
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/base.rb:408:in
''process_without_filters''
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/filters.rb:377:in
''process_without_session_management_support''
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/session_management.rb:117:in
''process''
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/dispatcher.rb:38:in
''dispatch''
/var/www/my-site/blog/dispatch.cgi:10
Other info:
Ruby 1.8.4
Rails 1.1.6
sqlite 3.3.5
sqlite3-ruby 1.1.0
Running on Apache 2.0.55, Ubuntu 6.10
Thanks,
Gavin
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
