Hi,
Have searched and searched the group and the net with no joy on this...
I have set up users table and am trying to insert newly registered users with the following code from:
class UserController < ApplicationController
def index end
def register @title = "Register" if request.post? #raise params[:user].inspect @user = User.new(params[:user]) if @user.save render :text => "User created!" end end end end
I receive the following error:
ActiveRecord::StatementInvalid in UserController#register
Could not find table 'users' RAILS_ROOT: /Users/Will/Development/rails_space
Application Trace | Framework Trace | Full Trace /Library/Ruby/Gems/1.8/gems/activerecord-2.3.2/lib/active_record/ connection_adapters/sqlite3_adapter.rb:29:in `table_structure' /Library/Ruby/Gems/1.8/gems/activesupport-2.3.2/lib/active_support/ core_ext/object/misc.rb:39:in `returning' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.2/lib/active_record/ connection_adapters/sqlite3_adapter.rb:28:in `table_structure' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.2/lib/active_record/ connection_adapters/sqlite_adapter.rb:213:in `columns' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.2/lib/active_record/ base.rb:1276:in `columns' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.2/lib/active_record/ base.rb:3008:in `attributes_from_column_definition_without_lock' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.2/lib/active_record/ locking/optimistic.rb:66:in `attributes_from_column_definition' /Library/Ruby/Gems/1.8/gems/activerecord-2.3.2/lib/active_record/ base.rb:2435:in `initialize' /Users/Will/Development/rails_space/app/controllers/user_controller.rb: 10:in `new' /Users/Will/Development/rails_space/app/controllers/user_controller.rb: 10:in `register' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ base.rb:1322:in `send' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ base.rb:1322:in `perform_action_without_filters' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ filters.rb:617:in `call_filters' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ filters.rb:610:in `perform_action_without_benchmark' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ benchmarking.rb:68:in `perform_action_without_rescue' /Library/Ruby/Gems/1.8/gems/activesupport-2.3.2/lib/active_support/ core_ext/benchmark.rb:17:in `ms' /Library/Ruby/Gems/1.8/gems/activesupport-2.3.2/lib/active_support/ core_ext/benchmark.rb:10:in `realtime' /Library/Ruby/Gems/1.8/gems/activesupport-2.3.2/lib/active_support/ core_ext/benchmark.rb:17:in `ms' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ benchmarking.rb:68:in `perform_action_without_rescue' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ rescue.rb:160:in `perform_action_without_flash' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ flash.rb:141:in `perform_action' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ base.rb:523:in `send' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ base.rb:523:in `process_without_filters' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ filters.rb:606:in `process' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ base.rb:391:in `process' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ base.rb:386:in `call' /Library/Ruby/Gems/1.8/gems/actionpack-2.3.2/lib/action_controller/ routing/route_set.rb:433:in `call'
It looks as if Rails is trying to find that table using the sqlite3 adapter, bt my db is configured to use mysql. Here is database.yml:
# MySQL. Versions 4.1 and 5.0 are recommended.