When I make model, I get error like below: jizhe@jizhe-laptop:~/ruby4rails/r4rmusic1$ ruby script/generate model work /usr/local/lib/ruby/1.8/yaml.rb:133:in `load'': syntax error on line 18, col 2: ` password: jizheair'' (ArgumentError) from /usr/local/lib/ruby/1.8/yaml.rb:133:in `load'' from /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/initializer.rb: 880:in `database_configuration'' from /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/initializer.rb: 416:in `initialize_database'' from /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/initializer.rb: 141:in `process'' from /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/initializer.rb: 113:in `send'' from /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/initializer.rb: 113:in `run'' from /home/jizhe/ruby4rails/r4rmusic1/config/environment.rb:9 from /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb: 31:in `gem_original_require'' from /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb: 31:in `require'' from /usr/local/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/commands/ generate.rb:1 from /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb: 31:in `gem_original_require'' from /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb: 31:in `require'' from script/generate:3 my database.yml : # SQLite version 3.x # gem install sqlite3-ruby (not necessary on OS X Leopard) development: adapter: mysql database: r4rmusic1_development pool: 5 timeout: 5000 username:root password: jizheair host: localhost socket: /var/run/mysqld/mysqld.sock # Warning: The database defined as "test" will be erased and # re-generated from your development database when you run "rake". # Do not set this db to the same as development or production. test: adapter: sqlite3 database: db/test.sqlite3 pool: 5 timeout: 5000 username:root password:jizheair production: adapter: sqlite3 database: db/production.sqlite3 pool: 5 timeout: 5000 username:root password:jizheair Please help me in tis regard.
> production: > adapter: sqlite3 > database: db/production.sqlite3 > pool: 5 > timeout: 5000 > username:root > password:jizheairIf i remember correctly, yaml cares about the space after the : Fred
Thank you for reply:) I have try to insert a space before my password, but the error is still there. On Oct 29, 9:24 pm, Frederick Cheung <frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > production: > > adapter: sqlite3 > > database: db/production.sqlite3 > > pool: 5 > > timeout: 5000 > > username:root > > password:jizheair > > If i remember correctly, yaml cares about the space after the : > > Fred
Ok, the problem is solved. just like you said, it''s the space problem. Thank you very much:) On Oct 29, 9:24 pm, Frederick Cheung <frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > production: > > adapter: sqlite3 > > database: db/production.sqlite3 > > pool: 5 > > timeout: 5000 > > username:root > > password:jizheair > > If i remember correctly, yaml cares about the space after the : > > Fred