‘open’ and 'notify' not valid column names

Please describe the full problem instead of only the steps to replicate.

Though I wasn't the original submitter, I've encountered the same problem with Rails 0.8.0 ActionPack 0.9.0 and a MySQL database. Here's some more detail:

I have a bugs table with a column named "open":

mysql> describe bugs; +-------------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------------+---------------------+------+-----+---------+-------+ | id | int(11) | | | 0 | | | open | tinyint(3) unsigned | YES | | 0 | | | date_opened | datetime | YES | | NULL | | | date_resolved | datetime | YES | | NULL | | | date_closed | datetime | YES | | NULL | |

<snip>

I created a basic controller using scaffold as such:

require 'abstract_application' require 'bug_helper' require 'bug'

class BugController < AbstractApplicationController

include BugHelper

scaffold :bug

end

If I open the URL for the list action (e.g., http://sparkbugs/bug/list), then select the "New bug" link automatically generated by the scaffolding, I get the following trace in the logs:

ActionView::TemplateError (wrong number of arguments (0 for 1)) on line #3 of /usr/lib/ruby/gems/1.8/gems/actionpack-0.9.0/lib/action_controller/templates/scaffolds/new.rhtml: 1: <h1>New <%= @scaffold_singular_name %></h1> 2: 3: <%= form(@scaffold_singular_name, :action => "create" + @scaffold_suffix) %> 4: 5: <%= link_to "Back", :action => "list#{@scaffold_suffix}" %>

/gems/actionpack-0.9.0/lib/action_view/helpers/form_helper.rb:158:in `initialize' /gems/actionpack-0.9.0/lib/action_view/helpers/form_helper.rb:158:in `open' /gems/actionpack-0.9.0/lib/action_view/helpers/form_helper.rb:158:in `send' /gems/actionpack-0.9.0/lib/action_view/helpers/form_helper.rb:158:in `value' /gems/actionpack-0.9.0/lib/action_view/helpers/form_helper.rb:114:in `to_input_field_tag' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:110:in `to_tag' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:21:in `input' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:97:in `default_input_block' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:97:in `call' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:93:in `all_input_tags' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:93:in `collect' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:93:in `all_input_tags' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:58:in `form' (erb):3:in `render_template' /gems/actionpack-0.9.0/lib/action_view/base.rb:191:in `render_template' /gems/actionpack-0.9.0/lib/action_view/base.rb:166:in `render_file' /gems/actionpack-0.9.0/lib/action_controller/scaffolding.rb:159:in `render_scaffold' /gems/actionpack-0.9.0/lib/action_controller/scaffolding.rb:119:in `new' /gems/actionpack-0.9.0/lib/action_controller/base.rb:563:in `send' /gems/actionpack-0.9.0/lib/action_controller/base.rb:563:in `perform_action_without_filters' /gems/actionpack-0.9.0/lib/action_controller/filters.rb:236:in `perform_action_without_benchmark' /gems/actionpack-0.9.0/lib/action_controller/benchmarking.rb:30:in `perform_action_without_rescue' /gems/actionpack-0.9.0/lib/action_controller/benchmarking.rb:30:in `measure' /gems/actionpack-0.9.0/lib/action_controller/benchmarking.rb:30:in `perform_action_without_rescue' /gems/actionpack-0.9.0/lib/action_controller/rescue.rb:68:in `perform_action' /gems/actionpack-0.9.0/lib/action_controller/base.rb:254:in `process' /gems/actionpack-0.9.0/lib/action_controller/base.rb:235:in `process' /gems/rails-0.8.0/lib/dispatcher.rb:35:in `dispatch' /Users/santry/Development/sparkbugs/public/dispatch.cgi:10

Rendering /usr/lib/ruby/gems/1.8/gems/actionpack-0.9.0/lib/action_controller/templates/rescues/layout.rhtml (500 Internal Error)

Renaming the column from "open" to "is_open" fixes the problem.

The same issue occurs with a column named "notify". Here's the stack trace:

<pre> ActionView::TemplateError (wrong number of arguments(0 for 1)) on line #3 of /usr/lib/ruby/gems/1.8/gems/actionpack-0.9.0/lib/action_controller/templates/scaffolds/new.rhtml: 1: <h1>New <%= @scaffold_singular_name %></h1> 2: 3: <%= form(@scaffold_singular_name, :action => "create" + @scaffold_suffix) %> 4: 5: <%= link_to "Back", :action => "list#{@scaffold_suffix}" %>

/gems/actionpack-0.9.0/lib/action_view/helpers/form_helper.rb:158:in `notify' /gems/actionpack-0.9.0/lib/action_view/helpers/form_helper.rb:158:in `send' /gems/actionpack-0.9.0/lib/action_view/helpers/form_helper.rb:158:in `value' /gems/actionpack-0.9.0/lib/action_view/helpers/form_helper.rb:114:in `to_input_field_tag' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:110:in `to_tag' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:21:in `input' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:97:in `default_input_block' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:97:in `call' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:93:in `all_input_tags' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:93:in `collect' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:93:in `all_input_tags' /gems/actionpack-0.9.0/lib/action_view/helpers/active_record_helper.rb:58:in `form' (erb):3:in `render_template' /gems/actionpack-0.9.0/lib/action_view/base.rb:191:in `render_template' /gems/actionpack-0.9.0/lib/action_view/base.rb:166:in `render_file' /gems/actionpack-0.9.0/lib/action_controller/scaffolding.rb:159:in `render_scaffold' /gems/actionpack-0.9.0/lib/action_controller/scaffolding.rb:119:in `new' /gems/actionpack-0.9.0/lib/action_controller/base.rb:563:in `send' /gems/actionpack-0.9.0/lib/action_controller/base.rb:563:in `perform_action_without_filters' /gems/actionpack-0.9.0/lib/action_controller/filters.rb:236:in `perform_action_without_benchmark' /gems/actionpack-0.9.0/lib/action_controller/benchmarking.rb:30:in `perform_action_without_rescue' /gems/actionpack-0.9.0/lib/action_controller/benchmarking.rb:30:in `measure' /gems/actionpack-0.9.0/lib/action_controller/benchmarking.rb:30:in `perform_action_without_rescue' /gems/actionpack-0.9.0/lib/action_controller/rescue.rb:68:in `perform_action' /gems/actionpack-0.9.0/lib/action_controller/base.rb:254:in `process' /gems/actionpack-0.9.0/lib/action_controller/base.rb:235:in `process' /gems/rails-0.8.0/lib/dispatcher.rb:35:in `dispatch' /Users/santry/Development/sparkbugs/public/dispatch.cgi:10

Rendering /usr/lib/ruby/gems/1.8/gems/actionpack-0.9.0/lib/action_controller/templates/rescues/layout.rhtml (500 Internal Error) </pre>

Both open and notify are the names for private methods, overriding them means they won't behave correctly when called by rails itself.

I've raised two enhancement requests to replace this defect.

#751 will get these 'reserved words' documented #752 will give you a much nicer error message

If you would like to follow their development please feel free to add yourself to their CC fields.

mac personal finance software r kelly i wish little house on the prairie doll chick ebony midget corea chick the revolving door porsche 911 tuning direct education loan servicing office planning and design watch free tv show rm to mp3 converter keygen american furniture rental cable computer wholesale builder center design home j music anime manga hotel in dallas fort worth area coin lindsay lohan slot bikini boob thong sex video game download add car donation link new virgin steele unholy waterpower wheels ride on toy anime hentai links drawing free software ware nokia 3220 phone cases louisiana swamp pop music ass exam fetish definition of love poetry free hip hop desktop wallpaper guerra nude vida computer history twelve girls band spring dream vcd bonus agreement development software gaming computer cases adagio fra missa aeterna bonus apple computer dealer xenical 120 mg real estate in salisbury maryland academic discounted software reinstall norton internet security voivod quantum love quote summer soundtrack anime reflection nanase hikaru hockey night in canada song chrysler motor car santa fe community college in gainesville florida oregon lottery win business home security solution know why i love you but i do best rated anti virus cleaning house point yarrow