Forum: Ruby on Rails Issue with scaffolding with rails 2.2 and mySQL

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Stephen M. (Guest)
on 2008-12-13 13:30
Hi guys,
I'm having problems when creating basic web applications using rails
2.2 and mySQL databases.
If I create the following table in a database named
moviecritc_development:

CREATE TABLE movies (
   id INT NOT NULL AUTO_INCREMENT PRIMARY_KEY,
   name VARCHAR(30) NOT NULL );

and then run the following ruby commands:

gem install rails
gem install mysql
rails -d mysql moviecritic (creates all the necessary files without any
issue.)

I then modify the config/database.yml to include the root password to
my database.

About your application’s environment
Ruby version  1.8.6 (i386-mswin32)
RubyGems version  1.3.1
Rails version  2.2.2
Active Record version  2.2.2
Action Pack version  2.2.2
Active Resource version  2.2.2
Action Mailer version  2.2.2
Active Support version  2.2.2
Application root  C:/Documents and Settings/Stephen/moviecritic
Environment  development
Database adapter  mysql
Database schema version  0

I then run the following command:
ruby script/generate scaffold Movie (creates usual files without error).

If i now view the db/migrate.create_movies.rb i see the following:
class CreateMovies < ActiveRecord::Migration
 def self.up
   create_table :movies do |t|

     t.timestamps
   end
 end

 def self.down
   drop_table :movies
 end
end

It doesn't make a reference to the name column i created! This is
reflected when i navigate to localhost:3000/movies/new i only see a
Back link and a Create Button, i don't see a NAME FIELD INPUT.

Has anyone any ideas why this is happening?
Thanks in advance,
Stephen
This topic is locked and can not be replied to.