I'm having a scaffolding problem

I have a model columns, and here's the table data:

class CreateComments < ActiveRecord::Migration
  def self.up
    create_table :comments do |t|
      t.column :title, :string, :limit => 100
      t.column :comment, :text
      t.column :meeting_id, :integer
      t.column :user_id, :integer
      t.column :posted_at, :datetime
      t.column :comment_id, :integer
    end
  end

  def self.down
    drop_table :comments
  end
end

Then, I did script/generate scaffold comment comment

It created all the files. However, when I try to "create new" it
throws an error:
http://rafb.net/paste/results/zaAxQb54.html

I'm totally bewildered. What could be causing this error? There are
no validations in the model.

Thanks,
Ben Lisbakken

Does this do the trick if you modify your class definition as follows:

class Comment < ActiveRecord::Base
    set_table_name "comments"

naw =/ it doesn't

-Ben

I have a model columns, and here's the table data:

class CreateComments < ActiveRecord::Migration
  def self.up
    create_table :comments do |t|
      t.column :title, :string, :limit => 100
      t.column :comment, :text
      t.column :meeting_id, :integer
      t.column :user_id, :integer
      t.column :posted_at, :datetime
      t.column :comment_id, :integer
    end
  end

  def self.down
    drop_table :comments
  end
end

Then, I did script/generate scaffold comment comment

It created all the files. However, when I try to "create new" it
throws an error:
http://rafb.net/paste/results/zaAxQb54.html

I'm totally bewildered. What could be causing this error? There are
no validations in the model.

Craig -

Thanks for letting me know about the script/destroy! I didn't know
about that hehe. What you said didn't work, but I think it all had to
do with my sql. I did rake db:migrate VERSION=0 then did rake
db:migrate, then regenerated the scaffold and it worked. Thanks for
the help, it's much appreciated!

-Ben