Forum: Ruby on Rails rake db:migrate problem

Problem YAML at line 6 column 28

I tried the attachment but he did not appear so because I did copy /
paste.

__

mini@mini:~/Sites/music_library$ rake db:migrate
rake aborted!
couldn't parse YAML at line 28 column 6
/home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in
`database_configuration'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in
`block (2 levels) in <class:Railtie>'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`instance_eval'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`execute_hook'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in
`block in run_load_hooks'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`each'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`run_load_hooks'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in
`<top (required)>'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in
`block (2 levels) in <top (required)>'
Tasks: TOP => db:migrate => db:load_config
(See full trace by running task with --trace)
mini@mini:~/Sites/music_library$ rake db:migrate
rake aborted!
couldn't parse YAML at line 28 column 6
/home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in
`database_configuration'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in
`block (2 levels) in <class:Railtie>'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`instance_eval'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`execute_hook'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in
`block in run_load_hooks'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`each'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`run_load_hooks'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in
`<top (required)>'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in
`block (2 levels) in <top (required)>'
Tasks: TOP => db:migrate => db:load_config
(See full trace by running task with --trace)
mini@mini:~/Sites/music_library$ rake db:migrate
rake aborted!
couldn't parse YAML at line 28 column 6
/home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in
`database_configuration'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in
`block (2 levels) in <class:Railtie>'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`instance_eval'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`execute_hook'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in
`block in run_load_hooks'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`each'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`run_load_hooks'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in
`<top (required)>'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in
`block (2 levels) in <top (required)>'
Tasks: TOP => db:migrate => db:load_config
(See full trace by running task with --trace)
mini@mini:~/Sites/music_library$
mini@mini:~/Sites/music_library$ vim
mini@mini:~/Sites/music_library$ rake db:migrate
rake aborted!
syntax error on line 28, col 1: ` host: localhost'
/home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in
`database_configuration'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in
`block (2 levels) in <class:Railtie>'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`instance_eval'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`execute_hook'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in
`block in run_load_hooks'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`each'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`run_load_hooks'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in
`<top (required)>'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in
`block (2 levels) in <top (required)>'
Tasks: TOP => db:migrate => db:load_config
(See full trace by running task with --trace)
mini@mini:~/Sites/music_library$ rake db:migrate --trace
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Execute db:load_config
rake aborted!
syntax error on line 28, col 1: ` host: localhost'
/usr/lib/ruby/1.9.1/syck.rb:135:in `load'
/usr/lib/ruby/1.9.1/syck.rb:135:in `load'
/home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in
`database_configuration'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in
`block (2 levels) in <class:Railtie>'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`instance_eval'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`execute_hook'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in
`block in run_load_hooks'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`each'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`run_load_hooks'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in
`<top (required)>'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in
`block (2 levels) in <top (required)>'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:228:in `call'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:228:in `block in
execute'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:223:in `each'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:223:in `execute'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:166:in `block in
invoke_with_call_chain'
/usr/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:159:in
`invoke_with_call_chain'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:187:in `block in
invoke_prerequisites'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:185:in `each'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:185:in
`invoke_prerequisites'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:165:in `block in
invoke_with_call_chain'
/usr/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:159:in
`invoke_with_call_chain'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:152:in `invoke'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:143:in
`invoke_task'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in
`block (2 levels) in top_level'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in
`each'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in
`block in top_level'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:110:in
`run_with_threads'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:95:in
`top_level'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:73:in `block
in run'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:160:in
`standard_exception_handling'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:70:in `run'
/home/mini/my_gems/gems/rake-10.0.3/bin/rake:33:in `<top (required)>'
/home/mini/my_gems/bin/rake:19:in `load'
/home/mini/my_gems/bin/rake:19:in `<main>'
Tasks: TOP => db:migrate => db:load_config
mini@mini:~/Sites/music_library$
mini@mini:~/Sites/music_library$ quit
No command 'quit' found, did you mean:
 Command 'quilt' from package 'quilt' (main)
 Command 'luit' from package 'x11-utils' (main)
 Command 'quot' from package 'quota' (main)
 Command 'quiz' from package 'bsdgames' (universe)
 Command 'qgit' from package 'qgit' (universe)
 Command 'qwit' from package 'qwit' (universe)
quit: command not found
mini@mini:~/Sites/music_library$ cd
mini@mini:~$ irb -r irb/completion
irb(main):001:0> puts ((110.to_s * 2).to_i/2)
55055
=> nil
irb(main):002:0> quit
mini@mini:~$ cd Sites
mini@mini:~/Sites$ cd music_library/
mini@mini:~/Sites/music_library$ rake db:migrate -






mini@mini:~/Sites/music_library$ rake db:migrate --trace
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Execute db:load_config
rake aborted!
couldn't parse YAML at line 28 column 6
/usr/lib/ruby/1.9.1/psych.rb:148:in `parse'
/usr/lib/ruby/1.9.1/psych.rb:148:in `parse_stream'
/usr/lib/ruby/1.9.1/psych.rb:119:in `parse'
/usr/lib/ruby/1.9.1/psych.rb:106:in `load'
/home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in
`database_configuration'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in
`block (2 levels) in <class:Railtie>'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`instance_eval'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`execute_hook'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in
`block in run_load_hooks'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`each'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`run_load_hooks'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in
`<top (required)>'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in
`block (2 levels) in <top (required)>'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:228:in `call'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:228:in `block in
execute'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:223:in `each'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:223:in `execute'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:166:in `block in
invoke_with_call_chain'
/usr/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:159:in
`invoke_with_call_chain'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:187:in `block in
invoke_prerequisites'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:185:in `each'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:185:in
`invoke_prerequisites'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:165:in `block in
invoke_with_call_chain'
/usr/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:159:in
`invoke_with_call_chain'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:152:in `invoke'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:143:in
`invoke_task'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in
`block (2 levels) in top_level'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in
`each'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in
`block in top_level'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:110:in
`run_with_threads'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:95:in
`top_level'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:73:in `block
in run'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:160:in
`standard_exception_handling'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:70:in `run'
/home/mini/my_gems/gems/rake-10.0.3/bin/rake:33:in `<top (required)>'
/home/mini/my_gems/bin/rake:19:in `load'
/home/mini/my_gems/bin/rake:19:in `<main>'
Tasks: TOP => db:migrate => db:load_config
mini@mini:~/Sites/music_library$
mini@mini:~/Sites/music_library$ rake db:migrate --trace
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Execute db:load_config
rake aborted!
couldn't parse YAML at line 28 column 6
/usr/lib/ruby/1.9.1/psych.rb:148:in `parse'
/usr/lib/ruby/1.9.1/psych.rb:148:in `parse_stream'
/usr/lib/ruby/1.9.1/psych.rb:119:in `parse'
/usr/lib/ruby/1.9.1/psych.rb:106:in `load'
/home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in
`database_configuration'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railtie.rb:78:in
`block (2 levels) in <class:Railtie>'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`instance_eval'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:36:in
`execute_hook'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:43:in
`block in run_load_hooks'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`each'
/home/mini/my_gems/gems/activesupport-3.2.9/lib/active_support/lazy_load_hooks.rb:42:in
`run_load_hooks'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/base.rb:720:in
`<top (required)>'
/home/mini/my_gems/gems/activerecord-3.2.9/lib/active_record/railties/databases.rake:25:in
`block (2 levels) in <top (required)>'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:228:in `call'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:228:in `block in
execute'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:223:in `each'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:223:in `execute'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:166:in `block in
invoke_with_call_chain'
/usr/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:159:in
`invoke_with_call_chain'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:187:in `block in
invoke_prerequisites'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:185:in `each'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:185:in
`invoke_prerequisites'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:165:in `block in
invoke_with_call_chain'
/usr/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:159:in
`invoke_with_call_chain'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/task.rb:152:in `invoke'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:143:in
`invoke_task'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in
`block (2 levels) in top_level'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in
`each'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:101:in
`block in top_level'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:110:in
`run_with_threads'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:95:in
`top_level'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:73:in `block
in run'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:160:in
`standard_exception_handling'
/home/mini/my_gems/gems/rake-10.0.3/lib/rake/application.rb:70:in `run'
/home/mini/my_gems/gems/rake-10.0.3/bin/rake:33:in `<top (required)>'
/home/mini/my_gems/bin/rake:19:in `load'
/home/mini/my_gems/bin/rake:19:in `<main>'
Tasks: TOP => db:migrate => db:load_config
mini@mini:~/Sites/music_library$

On 2 February 2013 16:03, Haris Hajdarevic <lists@ruby-forum.com> wrote:
> mini@mini:~/Sites/music_library$ rake db:migrate
> rake aborted!
> couldn't parse YAML at line 28 column 6
> 
/home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in
> `database_configuration'

Possibly a clue there, yml and database configuration.  Likely an
error in database.yml.

Why on earth you posted so much stuff including the same information
multiple times is beyond me.

Colin

On Saturday, 2 February 2013 11:03:15 UTC-5, Ruby-Forum.com User wrote:
>
> mini@mini:~/Sites/music_library$ rake db:migrate
> rake aborted!
> couldn't parse YAML at line 28 column 6
> 
/home/mini/my_gems/gems/railties-3.2.9/lib/rails/application/configuration.rb:115:in
>
> `database_configuration'
>

This error indicates that you've got invalid syntax in your
config/database.yml file. 80% chance it's a tab - YAML does not like 
tabs.
Check the file in an editor that can show you tabs vs. spaces.

Otherwise, posting the file will make it much easier to get help.

--Matt Jones