New to rails, a little model help please

rubyonrails-talk
1

Hey guys I'm having a little trouble what I think should be a pretty simple relationship between tables.

Player.rating is a f-key to Rating.id, both fields are integers

When I try to add a new player I get this error message

ActiveRecord::AssociationTypeMismatch in PlayersController#create Rating(#38968656) expected, got String(#19165136)

In my form I have this for the rating dropdown f.select :rating, options_for_select(Rating.all.map { |r| [r.level, r.id] })

In my models I have

#player has_one :rating

#rating belongs_to :player, :foreign_key => "id"

The controller is pretty straight forward   def create     @player = Player.new(params[:player])     respond_to do |format|       if @player.save         flash[:notice] = "Registration Successful"         format.html { redirect_to root_url }       else         flash[:notice] = "Error in registration"         format.html { render :action => "new" }       end     end   end

Any guidance?

2

Also, here are the params passed to the server

"player"=> {   "first_name"=>"Alex",   "last_name"=>"Zwinge",   "email_address"=>"poolshark1172@hotmail.com",   "password"=>"[FILTERED]",   "password_confirmation"=>"[FILTERED]",   "phone_number"=>"512-492-5708",   "rating"=>"1", <---- correct value   "city"=>"1",   "gender"=>"0" }, "commit"=>"Register", "controller"=>"players", "action"=>"create"

3

Alex Smith wrote:

Hey guys I'm having a little trouble what I think should be a pretty simple relationship between tables.

Player.rating is a f-key to Rating.id, both fields are integers

When I try to add a new player I get this error message

ActiveRecord::AssociationTypeMismatch in PlayersController#create Rating(#38968656) expected, got String(#19165136)

In my form I have this for the rating dropdown f.select :rating, options_for_select(Rating.all.map { |r| [r.level, r.id] })

In my models I have

#player has_one :rating

#rating belongs_to :player, :foreign_key => "id"

You've got it backwards. foreign_key gives the name of the key on the other table, so in this case, it would be 'rating', not 'id'. But why not follow the Rails conventions, call the column Player.rating_id , and drop the foreign key clause?

Best,

4

I knew it was going to be simple! Adding _id worked like a charm. Thanks for the help.

5

Alex Smith wrote:

I knew it was going to be simple! Adding _id worked like a charm. Thanks for the help.

You're most welcome. BTW, are you the Alex Smith I used to work with?

Best,