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
--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
edit: db/model names are plural/singular -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On Sep 7, 10:41 am, JuKuen <mario...-uiMcrn6V0Vs@public.gmane.org> wrote:> 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. >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 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
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.... :( Thanks -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
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 On Tue, Sep 7, 2010 at 8:37 AM, JuKuen <mario_r1-uiMcrn6V0Vs@public.gmane.org> wrote:> 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.... :( > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.