Posted this on Stack overflow and copied my post (it’s huge) here.
I’m in Rails 3.2.6
We have a nested form that was functioning up until recently (not
entirely
certain when the error started occurring). Now the queries are passing
in
nulls.
Example output:
Started POST “/articles” for 127.0.0.1 at 2012-07-12 11:04:16 -0600
Processing by ArticlesController#create as HTML
Parameters: {“utf8”=>“✓”, “authenticity_token”=>“thing=”,
“article”=>{“asset_attributes”=>{“name”=>“asdf”,
“short_desc”=>“asdfasdfsadg”, “publish_date”=>“2012-07-12 11:4”,
“content_section_attributes”=>{“section_id”=>“1”,
“primary_section”=>“1”}, “section_ids”=>[“”], “author_id”=>“”,
“display_authorbiography”=>“1”, “last_modified_by”=>“1”, “by_line”=>“”,
“content_image_attributes”=>{“image_id”=>“”}, “keywords_string”=>“”,
“public_keywords_string”=>“”, “meta_public_keywords”=>“”,
“meta_page_title”=>“”, “meta_description”=>“”, “meta_url_name”=>“”,
“guid”=>“”, “canonical”=>“”, “partner_id”=>“”, “tagline”=>“”,
“series_id”=>“”, “display_adsense”=>“1”, “sweepstakes”=>“”},
“content”=>“
asdfasgasg
”}, “img_size”=>“i01”, “show_cap”=>“1”,“img_pos”=>“left”, “commit”=>“Create”}
User Load (0.2ms) SELECT
people.* FROM people WHEREpeople.type IN (‘User’) AND people.id = 1 LIMIT 1/application:TmnCoreCms,controller:articles,action:create/
Section Load (0.1ms) SELECT
sections.* FROM sections/application:TmnCoreCms,controller:articles,action:create/
Site Load (0.1ms) SELECT
sites.* FROM sites WHERE sites.id IN(1) /application:TmnCoreCms,controller:articles,action:create/
Site Load (0.1ms) SELECT
sites.* FROM sites/application:TmnCoreCms,controller:articles,action:create/
Section Load (0.1ms) SELECT
sections.* FROM sections WHEREsections.site_id IN (1)/application:TmnCoreCms,controller:articles,action:create/
Role Load (0.1ms) SELECT
roles.* FROM roles INNER JOINuser_roles ON roles.id = user_roles.role_id WHEREuser_roles.user_id = 1/application:TmnCoreCms,controller:articles,action:create/
(0.1ms) BEGIN
/application:TmnCoreCms,controller:articles,action:create/
(0.1ms) COMMIT
/application:TmnCoreCms,controller:articles,action:create/
(0.1ms) BEGIN
/application:TmnCoreCms,controller:articles,action:create/
(0.1ms) COMMIT
/application:TmnCoreCms,controller:articles,action:create/
(0.1ms) BEGIN
/application:TmnCoreCms,controller:articles,action:create/
SQL (0.2ms) INSERT INTO
articles (content, created_at,static_url, updated_at) VALUES (‘asdfasgasg
’, ‘2012-07-1217:04:16’, NULL, ‘2012-07-12 17:04:16’)
/application:TmnCoreCms,controller:articles,action:create/
Article Load (0.3ms) SELECT
articles.* FROM articles WHEREarticles.id = 25 LIMIT 1/application:TmnCoreCms,controller:articles,action:create/
{}
SQL (0.0ms) INSERT INTO
assets (aasm_state, author_id,by_line, canonical, content_id, content_type, created_at,creator_id, display_adsense, display_authorbiography, guid,last_modified_by, legacyid, live_date, meta_description,meta_page_title, meta_public_keywords, meta_url_name,migration_guid, name, partner_id, publish_date,publish_version, series_id, short_desc, sweepstakes, tagline,updated_at, url_name) VALUES (‘new’, NULL, NULL, NULL, 25,‘Article’, ‘2012-07-12 17:04:16’, NULL, 1, 1, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, ‘2012-07-12 17:04:16’, NULL)
/application:TmnCoreCms,controller:articles,action:create/
SQL (0.2ms) INSERT INTO
content_sections (content_id,content_type, created_at, primary_section, section_id,updated_at) VALUES (53, ‘Asset’, ‘2012-07-12 17:04:16’, 1, NULL,‘2012-07-12 17:04:16’)
/application:TmnCoreCms,controller:articles,action:create/
(33.6ms) COMMIT
/application:TmnCoreCms,controller:articles,action:create/
Redirected to http://localhost:3000/articles/53-
Completed 302 Found in 63ms (ActiveRecord: 35.3ms)
So as you can see the attributes are being sent. Our controller looks
like
this.
def new
@article = Article.new
@asset = @article.build_asset
end
def create
@article = Article.new(params[:article])
if @article.save
flash[:notice] = ‘Article was successfully created.’
redirect_to @article
else
render :action => “new”
end
end
Relevant Model information:
class ContentType < ActiveRecord::Base
self.abstract_class = true
validates_presence_of :asset, :message => “Must have an asset”
has_one :asset, :as => :content, :dependent => :destroy
delegate :name, :url_name, :author, :creator, :publish_date,
:short_desc,
:aasm_state, :live_date, :keywords,
:to => :asset, :allow_nil => true
delegate :keywords_string, :public_keywords_string,
:to => :asset,
:allow_nil => true
def initialize(*args)
super(*args)
end
def to_param
“#{asset.id}-#{url_name}”
end
end
class Asset < ActiveRecord::Base
include AASM
include Keywordable
attr_accessible :author_id,
:by_line,
:canonical,
:content_image_attributes,
:content_section_attributes,
:creator_id,
:display_adsense,
:display_authorbiography,
:guid,
:keywords,
:keywords_string,
:last_modified_by,
:meta_description,
:meta_page_title,
:meta_public_keywords,
:meta_url_name,
:name,
:partner_id,
:public_keywords_string,
:publish_date,
:related_content_attributes,
:section_ids,
:series_id,
:short_desc,
:sweepstakes,
:syndication_partner_ids,
:tagline,
:url_name
belongs_to :author, :class_name => ‘Person’
belongs_to :content, :polymorphic => true
has_many :content_sections, :as => :content, :conditions =>
{:primary_section => nil}, :dependent => :destroy
class Article < ContentType
attr_accessible :images_attributes,
:content_images_attributes,
:content_text,
:content,
:asset_attributes,
:content_attributes
I really dislike this association set up but it is what it is. What’s
happening is that the nested form
<%= f.fields_for :asset do |asset| %>
Asset Description
<%= asset.label :name, “Title ".html_safe %>
<%= asset.text_field :name, :class => ‘asset_textarea
counter’, “data-max” => 255 %>
<%= asset.label :short_desc, "Teaser”.html_safe %>
<%= asset.text_area :short_desc, :class => “span7
asset_textarea counter”, “data-max” => 255, :rows => 7 %>
<% end %>
Is somehow passing the fields and Rails is putting nulls in. I have no
attr_accessible warnings. If I do an update on the article it will save
the
asset data. So something is going wrong on the initialization I think
but
I’m not sure what.
TLDR Rails is not passing values into sql query despite
attr_accessible
having the nested attributes.