problem with form getting error stack level to deep

[paulus4605]

dears since I'm new to ruby I try to create a form within ruby on rails.
this is my controller

require "player"
class SpelersController < ApplicationController
 
  def index
    @speler = Speler.find(:all, :order => 'RAND()')
  end
 
  def all_sorted
  @heren=Speler.heren
  @dames=Speler.dames
  end
 
  def score_sn
  @senior=Speler.sr 
  end
 
 
  def score_jr
    @junior=Speler.junior
  end
 
  def score_p
    @pupil =Speler.pupil
  end
 
 def score_top
   @man =Speler.topm
  @vrouw=Speler.topv
  end
def list
if params[:id].nil?
  @spelers = Speler.find(:all)
else
  @spelers = Speler.find(:all,:conditions =>["id=?",params[:id]])
  params[:id] = nil
end  
end
def show
  @speler=Speler.find(params[:id])
end
def new
    @Speler = Speler.new
 
    respond_to do |format|
      format.html # new.html.erb
      format.xml  { render :xml => @Speler }
    end
  end
def create
    @speler = Speler.new(params[:speler])
 
    respond_to do |format|
      if @speler.save
        flash[:notice] = 'Speler is met succes aangemaakt.'
        format.html { redirect_to(@speler) }
        format.xml  { render :xml => @speler, :status => :created, :location => @speler }
      else
        format.html { render :action => "new" }
        format.xml  { render :xml => @speler.errors, :status => :unprocessable_entity }
      end
    end
  end
  def edit
   @speler = Speler.find(params[:id]) 
  end
  def update
    @speler =Speler.find(params[:id])
    @speler.date = Time.now
    if @speler.update_attributes(params[:speler])
      flash[:notice] = 'de gegevens met met succes aangepast.'
      redirect_to :action => 'show', :id => @speler
    else
      render :action => 'edit'
    end
    end
 def destroy
   Speler.find(params[:id]).destroy
   redirect_to :action => 'list'
 end
  end
 
 

this is my model

require "C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record"
class Speler < ActiveRecord::Base
 @@ploegen={ 'P' => 'pupil', 'J' => 'junior', 'SR' => 'senior'}
 
#  def initialize(naam, achternaam, geslacht, score, ploeg='SR')
#    @naam = naam
#    @achternaam = achternaam
#    @geslacht = geslacht if geslacht == 'V' || geslacht == 'M'
#    if @@ploegen.has_key?(ploeg)
#      @ploeg = ploeg
#    else
#      @ploeg = 'SR'
#    end
#    @score = score
#  end
  ActiveRecord::Base.establish_connection(
  :adapter  => "mysql",
  :host     => "localhost",
  :username => "root",
  :password => "",
  :database => "vspw"
  )
class CreateSpelers < ActiveRecord::Migration
    def self.up
      create_table :spelers do |t|
        t.column :naam,:string
        t.column :achternaam,:string
        t.column :score,:integer
        t.column :ploeg,:string
        t.column :geslacht,:string
 
      end
      # TODO: Hiervoor heb ik een speler.make (of iets dergelijks) aangemaakt.  Deze zorgt ervoor dat 
      # oa de ploeg correct wordt opgevuld
      Speler.create  :naam => "jan",:achternaam => "Janssens",:score =>"5",:ploeg =>"SR",:geslacht =>"M"   
      Speler.create  :naam => "Leen",:achternaam => "Leniksen",:score =>"7",:ploeg =>"",:geslacht =>"V"   
      Speler.create  :naam => "Piet",:achternaam => "Pietersen",:score =>"3",:ploeg =>"",:geslacht =>"M"   
      Speler.create  :naam => "Els",:achternaam => "Elsenbocht",:score =>"1",:ploeg =>"J",:geslacht =>"V"   
      Speler.create  :naam => "Karel",:achternaam => "Carlsen",:score =>"8",:ploeg =>"",:geslacht =>"M"   
      Speler.create  :naam => "Mieke",:achternaam => "Mieters",:score =>"9",:ploeg =>"P",:geslacht =>"V"   
      Speler.create  :naam => "John",:achternaam => "Johanssen",:score =>"5",:ploeg =>"J",:geslacht =>"M"   
      Speler.create  :naam => "Veerle",:achternaam => "Veldsen",:score =>"3",:ploeg =>"",:geslacht =>"V"   
    end
    def self.down
      drop_table :Spelers
    end
    #CreateSpelers.down
    #CreateSpelers.up
  end
  def self.iedereen()
  Speler.find(:all )
end
 
  def to_s
sprintf(" #{naam} #{achternaam} - #{score}  ")
end
def self.heren
  Speler.find(:all, :conditions =>{:geslacht =>"M"})
end
def self.dames
  Speler.find(:all, :conditions =>{:geslacht =>"V"})
end
def ploeg
  @@ploegen = :ploeg
end
def self.sr
 @senior = Speler.find_by_sql("select naam,achternaam, score,ploeg from spelers WHERE ploeg = 'SR' OR ploeg =''")
end
 def self.pupil
  Speler.find(:all, :conditions =>{:ploeg =>"P"})
end
def self.junior
  Speler.find(:all, :conditions =>{:ploeg =>"J"})
end
def self.topm
  @man = Speler.find_by_sql("select naam,achternaam, score ,ploeg from spelers where geslacht ='M' ORDER BY score DESC").first(3)
end
def self.topv
  @vrouw = Speler.find_by_sql("select naam,achternaam, score ,ploeg from spelers where geslacht ='V' ORDER BY score DESC").first(3)
end
#select naam,ploeg from Spelers where ploeg ="SR" OR ploeg =  "";
#puts "Alle senioren :"
puts Speler.topm
 
 
end
 

en this is the error message
SystemStackError in SpelersController#new

stack level too deep

RAILS_ROOT: D:/Documenten/NetBeansProjects/Speler
Application Trace | Framework Trace | Full Trace

C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/locking/optimistic.rb:55:in `attributes_from_column_definition_without_lock'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/locking/optimistic.rb:55:in `attributes_from_column_definition'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1922:in `initialize'
app/controllers/spelers_controller.rb:42:in `new'
app/controllers/spelers_controller.rb:42:in `new'

C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/locking/optimistic.rb:55:in `attributes_from_column_definition_without_lock'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/locking/optimistic.rb:55:in `attributes_from_column_definition'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1922:in `initialize'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:1158:in `send'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:1158:in `perform_action_without_filters'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:697:in `call_filters'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:689:in `perform_action_without_benchmark'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
C:/paul/ruby/lib/ruby/1.8/benchmark.rb:293:in `measure'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/rescue.rb:199:in `perform_action_without_caching'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/caching.rb:678:in `perform_action'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/query_cache.rb:33:in `cache'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/query_cache.rb:8:in `cache'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/caching.rb:677:in `perform_action'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:524:in `send'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:524:in `process_without_filters'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:685:in `process_without_session_management_support'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/session_management.rb:123:in `process'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:388:in `process'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:171:in `handle_request'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:115:in `dispatch'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:126:in `dispatch_cgi'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:9:in `dispatch'
C:/paul/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/webrick_server.rb:112:in `handle_dispatch'
C:/paul/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/webrick_server.rb:78:in `service'
C:/paul/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
C:/paul/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:95:in `start'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:92:in `each'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:92:in `start'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:23:in `start'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:82:in `start'
C:/paul/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/webrick_server.rb:62:in `dispatch'
C:/paul/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/commands/servers/webrick.rb:66
C:/paul/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
C:/paul/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:496:in `require'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:342:in `new_constants_in'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:496:in `require'
C:/paul/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/commands/server.rb:39
C:/paul/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
C:/paul/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
script/server:3

C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/locking/optimistic.rb:55:in `attributes_from_column_definition_without_lock'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/locking/optimistic.rb:55:in `attributes_from_column_definition'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1922:in `initialize'
app/controllers/spelers_controller.rb:42:in `new'
app/controllers/spelers_controller.rb:42:in `new'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:1158:in `send'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:1158:in `perform_action_without_filters'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:697:in `call_filters'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:689:in `perform_action_without_benchmark'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
C:/paul/ruby/lib/ruby/1.8/benchmark.rb:293:in `measure'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/rescue.rb:199:in `perform_action_without_caching'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/caching.rb:678:in `perform_action'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/connection_adapters/abstract/query_cache.rb:33:in `cache'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/query_cache.rb:8:in `cache'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/caching.rb:677:in `perform_action'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:524:in `send'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:524:in `process_without_filters'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/filters.rb:685:in `process_without_session_management_support'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/session_management.rb:123:in `process'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/base.rb:388:in `process'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:171:in `handle_request'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:115:in `dispatch'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:126:in `dispatch_cgi'
C:/paul/ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action_controller/dispatcher.rb:9:in `dispatch'
C:/paul/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/webrick_server.rb:112:in `handle_dispatch'
C:/paul/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/webrick_server.rb:78:in `service'
C:/paul/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
C:/paul/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:95:in `start'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:92:in `each'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:92:in `start'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:23:in `start'
C:/paul/ruby/lib/ruby/1.8/webrick/server.rb:82:in `start'
C:/paul/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/webrick_server.rb:62:in `dispatch'
C:/paul/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/commands/servers/webrick.rb:66
C:/paul/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
C:/paul/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:496:in `require'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:342:in `new_constants_in'
C:/paul/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/dependencies.rb:496:in `require'
C:/paul/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/commands/server.rb:39
C:/paul/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
C:/paul/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'
script/server:3

Request

Parameters:

None

Show session dump

---
flash: !map:ActionController::Flash::FlashHash {}


Response

Headers:

{"cookie"=>[],
"Cache-Control"=>"no-cache"}


how do I solve this problem I know it's situated arround the def new part but I'm not able to solve it
thanks for your help

[paulus4605]

an addition to this problem is whenever I put the block def new in comment I do get to see my form however nothing is transfered to my db

thanks again for your help

Paul

[improvcornartist]

I am not familiar with respond_to or your setup, but does @Speler maybe need a .to_xml in the 'new' method?

def new
    @Speler = Speler.new
 
    respond_to do |format|
      format.html # new.html.erb
      format.xml  { render :xml => @Speler.to_xml }
    end
end
 

[mylocaldentists]

The information you can put up are very informative. I am get a lot of information. Thanks