HABTM through Checkboxes Rails 3

Question

I have a HABTM problem. I follow the textbooks because I see them, but no luck. Here is my code:

class Country < ActiveRecord::Base
  has_and_belongs_to_many :videos
end

class Video < ActiveRecord::Base
  has_and_belongs_to_many :countries
end

Change view:

<% for country in Country.find(:all) %>
  <%= check_box_tag "video[country_ids][]", country.id, @video.countries.include?(country.id) %>
  <%= label_tag "video[country_ids][]", country.name, :for => "video[country_ids][]" %><br />
<% end %>

Show view:

  <% for country in @video.countries %>
    <%= country.name %><br />
  <% end %>

Video controller:

  def update
    @video = Video.find(params[:id])
    if @video.update_attributes(params[:video])
      flash[:notice] = "Successfully updated video."
      redirect_to video_url
    else
      render :action => 'edit'
    end
  end

And the error in the log is:

Started POST "/videos/2" for 127.0.0.1 at Tue Feb 08 15:01:33 -0600 2011
  Processing by VideosController#update as HTML
  Parameters: {"commit"=>"Update Video", "authenticity_token"=>"6y01pmKxB+TEG0pbU6ujDsfwzqQW9eqiXBJfPHQW5+w=", "utf8"=>"✓", "id"=>"2", "video"=>{"name"=>"Video number 1", "vimeo_id"=>"12341234", "country_ids"=>["2", "3", "4", "11", "12", "13"]}}
  [1m[36mVideo Load (0.4ms)[0m  [1mSELECT "videos".* FROM "videos" WHERE ("videos"."id" = 2) LIMIT 1[0m
  [1m[35mCountry Load (0.4ms)[0m  SELECT "countries".* FROM "countries" WHERE ("countries"."id" IN (2, 3, 4, 11, 12, 13))
Completed   in 35ms

ActiveRecord::StatementInvalid (Could not find table 'countries_videos'):
  app/controllers/videos_controller.rb:31:in `update'

Rendered /Library/Ruby/Gems/1.8/gems/actionpack-3.0.3/lib/action_dispatch/middleware/templates/rescues/_trace.erb (1.1ms)
Rendered /Library/Ruby/Gems/1.8/gems/actionpack-3.0.3/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (10.6ms)
Rendered /Library/Ruby/Gems/1.8/gems/actionpack-3.0.3/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb within rescues/layout (16.1ms)

The video table and country table do not join the HABTM. He says he cannot find the countries_videos table. What am I missing?

Answer 1

Woops. Ok, so I did not understand that I need to create these tables. Now everything works.

Thank!