Hi,
I'm using the restful_authentication plugin that I downloaded from here -- http://agilewebdevelopment.com/plugins/. I wanted to use the plugin with an existing table I have, which has a column named "user_type_id". However, when I submit the form, although the columns the plugin is expecting get populated, none of the ones I have supplied do. Here is my form:
<%= start_form_tag(:action => "userconfirm") %> <!--[form:user]--> <%= hidden_field 'user', 'user_type_id', :value=>2 %>
<p><label for="user_ship_to_first_name">First name</label><br/> <%= text_field 'user', 'ship_to_first_name' %></p> ... <p><label for="user_login">Username</label><br/> <%= text_field 'user', 'login' %></p>
<p><label for="user_password">Password</label><br/> <%= password_field 'user', 'password' %></p>
<p><label for="password_confirmation">Confirm Password</label><br/> <%= password_field 'user', 'password_confirmation' %></p> <%= submit_tag "Create" %> <% end_form_tag %>
and here is the section defined in the controller.
def userconfirm @user = User.new(params[:user]) if @user.save flash[:notice] = 'User was successfully created.' redirect_to :action => 'list' else render :action => 'userinfo' end end
The error I get is ActiveRecord::StatementInvalid in RegisterController#userconfirm
Mysql::Error: #23000Column 'user_type_id' cannot be null: INSERT INTO users (`created_on`, `last_login`, `pharmacy_id`, `provincial_tax`, `salt`, `tax`, `work_phone`, `work_phone_extension`, `cc_company`, `cc_number`, `discount`, `ship_to_city`, `ship_to_last_name`, `user_type_id`, `cc_security_code`, `comments`, `company_name`, `crypted_password`, `bill_to_attn`, `bill_to_country`, `bill_to_street2`, `demo`, `ship_to_country`, `updated_on`, `activation_code`, `dateofbirth`, `html_email_pref`, `lock_order_form_prices`, `ship_to_street`, `ship_to_zip`, `show_retail_prices`, `user_group_id`, `bill_to_city`, `enabled`, `bill_to_company`, `user_agent`, `fax`, `phone`, `ship_to_attn`, `ship_to_street2`, `shipping`, `bill_to_last_name`, `bill_to_street`, `cc_exp_date`, `reseller_id`, `user_id`, `bill_to_state`, `login`, `ship_to_first_name`, `ship_to_state`, `bill_to_first_name`, `bill_to_zip`, `email`, `po_num`, `ship_to_company`) VALUES('2008-01-22 09:03:30', NULL, NULL, 0.0, 'deb98c56f0a3f750c9d66869903ef573be1774f5', 0.0, NULL, NULL, NULL, NULL, 0.0, NULL, NULL, NULL, NULL, NULL, '', '5e9f6eb74cbb331641afe002ecce8f5f612d358b', NULL, NULL, NULL, 0, NULL, '2008-01-22 09:03:30', '399806887d510ca24311133ca86775d9946f3644', NULL, 1, 0, NULL, NULL, 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0.0, NULL, NULL, NULL, NULL, NULL, NULL, 'laredo223', NULL, NULL, NULL, NULL, 'laredotornado@gmail.au', NULL, NULL)
RAILS_ROOT: ./script/../config/.. Application Trace | Framework Trace | Full Trace
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/abstract_adapter.rb:128:in `log' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/mysql_adapter.rb:243:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/mysql_adapter.rb:253:in `insert' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/base.rb:1814:in `create_without_callbacks'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/callbacks.rb:254:in `create_without_timestamps' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/timestamp.rb:30:in `create'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/base.rb:1792:in `create_or_update_without_callbacks' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/callbacks.rb:242:in `create_or_update'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/base.rb:1548:in `save_without_validation' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/validations.rb:752:in `save_without_transactions'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/transactions.rb:129:in `save' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/connection_adapters/abstract/database_statements.rb: 59:in `transaction'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/transactions.rb:95:in `transaction' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/transactions.rb:121:in `transaction'
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.5/lib/ active_record/transactions.rb:129:in `save' /usr/local/apache2/htdocs/easyrx/app/controllers/ register_controller.rb:59:in `userconfirm'
