开发者

HABTM through Checkboxes Issue Rails 3

I've been having a problem HABTM. I'm following tutorials as I see them but no luck. Here's my code:

class Country < ActiveRecord::Base
  has_and_belongs_to_many :videos
end

class Video < ActiveRecord::Base
  has_and_belongs_to_many :countries
end

Edit 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 er开发者_如何学Goror in the log:

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 Videos table and the Countries table are not joining thru the HABTM. It says it can't find the countries_videos table. What am I missing?


Woops. Ok so I didn't realize that I need to actually create those tables. Got it all working now.

Thanks!

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜