clubs.rb

class Club < ActiveRecord::Base
def self.search(search)
		print search
		search_condition = "%" + search + "%"
		find(:all, :conditions => ['fbuid LIKE ? OR fbname LIKE ?', search_condition, search_condition])
	end
end

gistfile2.txt

controller code :-


def destroy
	@club=Club.find(:first, :conditions => [ "fbuid = ?", params[:id]]);
	@club.destroy
	redirect_to :action => 'list'
end


error:-

undefined method `eq' for nil:NilClass


Full trace:-

activesupport (3.0.0) lib/active_support/whiny_nil.rb:48:in `method_missing'
activerecord (3.0.0) lib/active_record/persistence.rb:79:in `destroy'
activerecord (3.0.0) lib/active_record/locking/optimistic.rb:110:in `destroy'
activerecord (3.0.0) lib/active_record/callbacks.rb:260:in `destroy'
activesupport (3.0.0) lib/active_support/callbacks.rb:413:in `_run_destroy_callbacks'
activerecord (3.0.0) lib/active_record/callbacks.rb:260:in `destroy'
activerecord (3.0.0) lib/active_record/transactions.rb:232:in `destroy'
activerecord (3.0.0) lib/active_record/transactions.rb:289:in `with_transaction_returning_status'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/database_statements.rb:139:in `transaction'
activerecord (3.0.0) lib/active_record/transactions.rb:204:in `transaction'
activerecord (3.0.0) lib/active_record/transactions.rb:287:in `with_transaction_returning_status'
activerecord (3.0.0) lib/active_record/transactions.rb:232:in `destroy'
app/controllers/clubs_controller.rb:21:in `destroy'
actionpack (3.0.0) lib/action_controller/metal/implicit_render.rb:4:in `send_action'
actionpack (3.0.0) lib/action_controller/metal/implicit_render.rb:4:in `send_action'
actionpack (3.0.0) lib/abstract_controller/base.rb:150:in `process_action'
actionpack (3.0.0) lib/action_controller/metal/rendering.rb:11:in `process_action'
actionpack (3.0.0) lib/abstract_controller/callbacks.rb:18:in `process_action'
activesupport (3.0.0) lib/active_support/callbacks.rb:435:in `_run__1113354289__process_action__988268021__callbacks'
activesupport (3.0.0) lib/active_support/callbacks.rb:409:in `send'
activesupport (3.0.0) lib/active_support/callbacks.rb:409:in `_run_process_action_callbacks'
activesupport (3.0.0) lib/active_support/callbacks.rb:93:in `send'
activesupport (3.0.0) lib/active_support/callbacks.rb:93:in `run_callbacks'
actionpack (3.0.0) lib/abstract_controller/callbacks.rb:17:in `process_action'
actionpack (3.0.0) lib/action_controller/metal/instrumentation.rb:30:in `process_action'
activesupport (3.0.0) lib/active_support/notifications.rb:52:in `instrument'
activesupport (3.0.0) lib/active_support/notifications/instrumenter.rb:21:in `instrument'
activesupport (3.0.0) lib/active_support/notifications.rb:52:in `instrument'
actionpack (3.0.0) lib/action_controller/metal/instrumentation.rb:29:in `process_action'
actionpack (3.0.0) lib/action_controller/metal/rescue.rb:17:in `process_action'
actionpack (3.0.0) lib/abstract_controller/base.rb:119:in `process'
actionpack (3.0.0) lib/abstract_controller/rendering.rb:40:in `process'
actionpack (3.0.0) lib/action_controller/metal.rb:133:in `dispatch'
actionpack (3.0.0) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
actionpack (3.0.0) lib/action_controller/metal.rb:173:in `action'
actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:62:in `call'
actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:62:in `dispatch'
actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:27:in `call'
rack-mount (0.6.13) lib/rack/mount/route_set.rb:148:in `call'
rack-mount (0.6.13) lib/rack/mount/code_generation.rb:93:in `recognize'
rack-mount (0.6.13) lib/rack/mount/code_generation.rb:103:in `optimized_each'
rack-mount (0.6.13) lib/rack/mount/code_generation.rb:92:in `recognize'
rack-mount (0.6.13) lib/rack/mount/route_set.rb:139:in `call'
actionpack (3.0.0) lib/action_dispatch/routing/route_set.rb:492:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/head.rb:14:in `call'
rack (1.2.1) lib/rack/methodoverride.rb:24:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/params_parser.rb:21:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/flash.rb:182:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/session/abstract_store.rb:149:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/cookies.rb:287:in `call'
activerecord (3.0.0) lib/active_record/query_cache.rb:32:in `call'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/query_cache.rb:28:in `cache'
activerecord (3.0.0) lib/active_record/query_cache.rb:12:in `cache'
activerecord (3.0.0) lib/active_record/query_cache.rb:31:in `call'
activerecord (3.0.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/callbacks.rb:46:in `call'
activesupport (3.0.0) lib/active_support/callbacks.rb:415:in `_run_call_callbacks'
actionpack (3.0.0) lib/action_dispatch/middleware/callbacks.rb:44:in `call'
rack (1.2.1) lib/rack/sendfile.rb:107:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/remote_ip.rb:48:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/show_exceptions.rb:46:in `call'
railties (3.0.0) lib/rails/rack/logger.rb:13:in `call'
rack (1.2.1) lib/rack/runtime.rb:17:in `call'
activesupport (3.0.0) lib/active_support/cache/strategy/local_cache.rb:72:in `call'
rack (1.2.1) lib/rack/lock.rb:11:in `call'
rack (1.2.1) lib/rack/lock.rb:11:in `synchronize'
rack (1.2.1) lib/rack/lock.rb:11:in `call'
actionpack (3.0.0) lib/action_dispatch/middleware/static.rb:30:in `call'
railties (3.0.0) lib/rails/application.rb:168:in `call'
railties (3.0.0) lib/rails/application.rb:77:in `send'
railties (3.0.0) lib/rails/application.rb:77:in `method_missing'
railties (3.0.0) lib/rails/rack/log_tailer.rb:14:in `call'
rack (1.2.1) lib/rack/content_length.rb:13:in `call'
rack (1.2.1) lib/rack/handler/webrick.rb:52:in `service'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/webrick/server.rb:82:in `start'
rack (1.2.1) lib/rack/handler/webrick.rb:13:in `run'
rack (1.2.1) lib/rack/server.rb:213:in `start'
railties (3.0.0) lib/rails/commands/server.rb:65:in `start'
railties (3.0.0) lib/rails/commands.rb:30
railties (3.0.0) lib/rails/commands.rb:27:in `tap'
railties (3.0.0) lib/rails/commands.rb:27
script/rails:6:in `require'
script/rails:6


console :-

Loading development environment (Rails 3.0.0)
>> @club = Club.find(:first,:condition => ["fbuid=?",1])
ArgumentError: Unknown key(s): condition
	from /Library/Ruby/Gems/1.8/gems/activesupport-3.0.0/lib/active_support/core_ext/hash/keys.rb:43:in `assert_valid_keys'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/relation/spawn_methods.rb:89:in `apply_finder_options'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/relation/finder_methods.rb:101:in `find'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/base.rb:439:in `__send__'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/base.rb:439:in `find'
	from (irb):1
>> 

no method error

>> @club = Club.find(:first,:conditions => ["fbuid=?",1])
=> #<Club fbuid: 1, cbname: "dango1", fbname: "fbdango1", str_name: "11231ad", cty_name: "Mumbai", cou_name: "india", pin: 400444, cb_tel: 12313, hst_name: "abc", hst_tel: 1231, lati: 3213123>
>> @club.destroy
NoMethodError: undefined method `eq' for nil:NilClass
	from /Library/Ruby/Gems/1.8/gems/activesupport-3.0.0/lib/active_support/whiny_nil.rb:48:in `method_missing'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/persistence.rb:79:in `destroy'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/locking/optimistic.rb:110:in `destroy'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/callbacks.rb:260:in `destroy'
	from /Library/Ruby/Gems/1.8/gems/activesupport-3.0.0/lib/active_support/callbacks.rb:413:in `_run_destroy_callbacks'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/callbacks.rb:260:in `destroy'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/transactions.rb:232:in `destroy'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/transactions.rb:289:in `with_transaction_returning_status'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/connection_adapters/abstract/database_statements.rb:139:in `transaction'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/transactions.rb:204:in `transaction'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/transactions.rb:287:in `with_transaction_returning_status'
	from /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0/lib/active_record/transactions.rb:232:in `destroy'
	from (irb):3
>> 

table structure

 create_table "clubs", :primary_key => "fbuid", :force => true do |t|
    t.string  "cbname",   :limit => 100
    t.string  "fbname",   :limit => 100
    t.string  "str_name", :limit => 100
    t.string  "cty_name", :limit => 100
    t.string  "cou_name", :limit => 100
    t.integer "pin"
    t.integer "cb_tel"
    t.string  "hst_name", :limit => 100
    t.integer "hst_tel"
    t.integer "lati"
  end