rails scaffolding issue

Greetings friends,

i`m experiencing an issue with scaffolding, which i`m unable to
resolve for the moment.

system used:
win7 x64: ruby -v 1.9.1, gem -v 1.3.7, rails -v 2.3.8. mysql 5.1.50,
but downgraded to 5.0.37
win xp x86: ruby -v 1.9.2, gem -v 1.3.7, rails - 3. mysql 5.1.50, but
downgraded to 5.0.37
slackware 13.1: ruby -v 1.9.2, gem -v 1.3.7, rails - 3. mysql 5.1.34

i have full mysql access, it is working, the issue persist in sqlite3
aswell

When i try to scaffold from the existing table, im not getting the
error while scaffolding, but after that the migration file is empty:

class CreatePosts < ActiveRecord::Migration
  def self.up
    create_table :posts do |t|

      t.timestamps
    end
  end

  def self.down
    drop_table :posts
  end
end

When i fill it by hand,

class CreatePosts < ActiveRecord::Migration
  def self.up
    create_table :posts do |t|
  t.column :title, :string, :limit => 100, :null => false
  t.column :body, :text, :nill => false
  t.column :author, :string, :limit => 100, :null => false
        t.column :status, :string, :limit => 20, :null => false
        t.column :created_at, :datetime
        t.column :updated_at, :datetime
    end
  end

  def self.down
    drop_table :posts
  end
end

and i try to test my app in the browser, i dont get the scaffolded
fields, just one single button, when i click it, its renders the "new
form" and there is only the create button alone, but when i click it,
im getting the next error:

ActiveRecord::StatementInvalid in PostsController#create

SQLite3::ConstraintException: posts.title may not be NULL: INSERT INTO
"posts" ("title", "body", "author", "status", "created_at",
"updated_at") VALUES(NULL, NULL, NULL, NULL, '2010-09-07 08:53:20',
'2010-09-07 08:53:20')

RAILS_ROOT: D:/sites/new

this is because sent information is empty, but there are no fields in
the application.
the problem is existing only if i use existing table in mysql, or
trying to create migrations by hand.
when i do:
ruby script/generate scaffold Post blahblah:sting
blahblah:text................................., it is working fine
with sqlite3.

Any help will be helpful

Thanks in Advance

edit:
db/model names are plural/singular

That's how scaffolding is (i think the change happened back in rails
2). If you want the old dynamic scaffolding stuff you could look at
something like active scaffold, or the old code was extracted into a
plugin (don't know if it's still maintained): http://github.com/rails/scaffolding

Fred

If i understand it right, in new scaffold need to be specified each
column from the existing db?

In my case:
ruby script/generate scaffold Post title:string body:text
author:string status:string created_at:datetime updated_at:datetime

And it will migrate the outside rails made db and will be working as
is needed to be?
Tested it and its working this way. Asking because dont want to learn
it in wrong way.
Used some outdated information.... :frowning:

Thanks

whan you scafolded you didnt spefified the field of the database , the scafold creates empty views in that case , i think you didnt pass the fields because the scaffold fills the migration with them if you do, since i see the migration is empty that mians you did this

script/generate scaffold post
and it should have been

script/generate scaffold post title:string body:text and so on