# Errors in rake db:create **URL:** \ **Category:** rubyonrails-talk\ **Created:** [March 2, 2010, 12:51pm UTC](https://discuss.rubyonrails.org/t/errors-in-rake-db-create/49815 "2010-03-02T12:51:56Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![11155](https://avatars.discourse-cdn.com/v4/letter/1/d26b3c/32.png) [@11155](https://discuss.rubyonrails.org/u/11155)\ **Post date:** [March 2, 2010, 12:51pm UTC](https://discuss.rubyonrails.org/t/errors-in-rake-db-create/49815/1 "2010-03-02T12:51:56Z")
I have a basic working knowledge about ruby and am trying to now setup ruby on rails on my personal machine which is a Windows XP machine. The versions of ruby,gems and rails are below C:\ruby\Programs\>ruby -v ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32] C:\ruby\Programs\>rails -v Rails 2.3.5 C:\ruby\Programs\>gem -v 1.3.6 After installing rails and rubygems , I was trying to setup rails for a first project reading up from > **[Getting Started with Rails — Ruby on Rails Guides](https://guides.rubyonrails.org/getting_started.html)** > > Getting Started with RailsThis guide covers getting up and running with Ruby on Rails.After reading this guide, you will know: How to install Rails, create a new Rails application, and connect your application to a database. The general layout of a... the command gem install mysql installed one gem and gave me some documentation related errors which I figured were not a major concern after reading your ticket 1598 and others. However when I try to do rake db:create I get the following errors : C:\rubygems-1.3.6\blog\>rake db:create --trace (in C:/rubygems-1.3.6/blog) \*\* Invoke db:create (first\_time) \*\* Invoke db:load\_config (first\_time) \*\* Invoke rails\_env (first\_time) \*\* Execute rails\_env \*\* Execute db:load\_config \*\* Execute db:create rake aborted! undefined method `' for nil:NilClass c:/ruby/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/tasks/databases.rake:55:in `create_database' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/tasks/databases.rake:31 c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke\_with\_call\_chain' c:/ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke\_with\_call\_chain' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke\_task' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard\_exception\_handling' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31 c:/ruby/bin/rake:19:in `load' c:/ruby/bin/rake:19 Please help me out with this , I have been trying to get it work for some time now but in vain, ---
**Author:** ![Jeremy\_Chase](https://avatars.discourse-cdn.com/v4/letter/j/47e85d/32.png) [@Jeremy\_Chase](https://discuss.rubyonrails.org/u/Jeremy_Chase)\ **Post date:** [March 2, 2010, 12:57pm UTC](https://discuss.rubyonrails.org/t/errors-in-rake-db-create/49815/2 "2010-03-02T12:57:31Z")
The gem you installed is just an interface to MySQL. You need to install MySQL as a standalone application as well. If you have installed MySQL; you need to make sure it is running. I would recommend using sqlite3 in development, unless you are doing something that requires MySQL or Postgres(trig functions, for example, are in the big RDB’s but not sqlite). -Jer ---
**Author:** ![Rajeev\_Kannav\_Sharma](https://avatars.discourse-cdn.com/v4/letter/r/8dc957/32.png) [@Rajeev\_Kannav\_Sharma](https://discuss.rubyonrails.org/u/Rajeev_Kannav_Sharma)\ **Post date:** [March 2, 2010, 12:59pm UTC](https://discuss.rubyonrails.org/t/errors-in-rake-db-create/49815/3 "2010-03-02T12:59:21Z")
did you Configure a MySQL Database ? ---
**Author:** ![11155](https://avatars.discourse-cdn.com/v4/letter/1/d26b3c/32.png) [@11155](https://discuss.rubyonrails.org/u/11155)\ **Post date:** [March 4, 2010, 11:14am UTC](https://discuss.rubyonrails.org/t/errors-in-rake-db-create/49815/4 "2010-03-04T11:14:39Z")
@Jeremy Chase I have installed a Mysql standalone application and is running when I use the command rake db:create. For reference I have attached the database.yml file that I have made for my ruby on rails application. @Kannav Rajeev I'm not sure what I need to configure in the database for the RoR application. Please help. Thanks kannav rajeev wrote: > did you Configure a MySQL Database ? > > > C:\ruby\Programs\>gem -v > > > > c:/ruby/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/tasks/databases.rake:55:in `invoke\_with\_call\_chain' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in some time now but in vain, [http://groups.google.com/group/rubyonrails-talk?hl=en](http://groups.google.com/group/rubyonrails-talk?hl=en). > > -- Thanks: Rajeev sharma Attachments: [http://www.ruby-forum.com/attachment/4534/database.yml](http://www.ruby-forum.com/attachment/4534/database.yml) ---
**Author:** ![Rajeev\_Kannav\_Sharma](https://avatars.discourse-cdn.com/v4/letter/r/8dc957/32.png) [@Rajeev\_Kannav\_Sharma](https://discuss.rubyonrails.org/u/Rajeev_Kannav_Sharma)\ **Post date:** [March 4, 2010, 11:18am UTC](https://discuss.rubyonrails.org/t/errors-in-rake-db-create/49815/5 "2010-03-04T11:18:22Z")
its fine you done try this at once without sockt development: adapter: mysql encoding: utf8 database: blog\_development pool: 5 username: root password: still you have error please copy and paste that Error here ---
**Author:** ![11155](https://avatars.discourse-cdn.com/v4/letter/1/d26b3c/32.png) [@11155](https://discuss.rubyonrails.org/u/11155)\ **Post date:** [March 4, 2010, 11:25am UTC](https://discuss.rubyonrails.org/t/errors-in-rake-db-create/49815/6 "2010-03-04T11:25:49Z")
I tried it without the socket but no luck , here is the error log C:\RUBYGE~1.6\blog\>rake db:create --trace (in C:/RUBYGE~1.6/blog) \*\* Invoke db:create (first\_time) \*\* Invoke db:load\_config (first\_time) \*\* Invoke rails\_env (first\_time) \*\* Execute rails\_env \*\* Execute db:load\_config \*\* Execute db:create rake aborted! undefined method `' for nil:NilClass c:/ruby/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/tasks/databases.rake:55:in `create_database' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.3.5/lib/tasks/databases.rake:31 c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke\_with\_call\_chain' c:/ruby/lib/ruby/1.8/monitor.rb:242:in `synchronize' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke\_with\_call\_chain' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke\_task' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard\_exception\_handling' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31 c:/ruby/bin/rake:19:in `load' c:/ruby/bin/rake:19 kannav rajeev wrote: ---
**Author:** ![Rajeev\_Kannav\_Sharma](https://avatars.discourse-cdn.com/v4/letter/r/8dc957/32.png) [@Rajeev\_Kannav\_Sharma](https://discuss.rubyonrails.org/u/Rajeev_Kannav_Sharma)\ **Post date:** [March 4, 2010, 1:20pm UTC](https://discuss.rubyonrails.org/t/errors-in-rake-db-create/49815/7 "2010-03-04T13:20:52Z")
i have three Guesses try these rake gems:install or saw in config/environment.rb is this file showing in Error console iy yes comment it out then restart servers or if more bad luck you have Please make this whole app Again this step is recommended.. better luck next time... thanks ---
**Author:** ![Rajeev\_Kannav\_Sharma](https://avatars.discourse-cdn.com/v4/letter/r/8dc957/32.png) [@Rajeev\_Kannav\_Sharma](https://discuss.rubyonrails.org/u/Rajeev_Kannav_Sharma)\ **Post date:** [March 4, 2010, 1:24pm UTC](https://discuss.rubyonrails.org/t/errors-in-rake-db-create/49815/8 "2010-03-04T13:24:02Z")
Hey sorry i think first please write yours migration code so i can help you out. First Do this then else thanks .. ---
**Author:** ![11155](https://avatars.discourse-cdn.com/v4/letter/1/d26b3c/32.png) [@11155](https://discuss.rubyonrails.org/u/11155)\ **Post date:** [March 5, 2010, 3:00pm UTC](https://discuss.rubyonrails.org/t/errors-in-rake-db-create/49815/9 "2010-03-05T15:00:27Z")
Thanks everyone , it turns out that doing the age-old trick of re-installing the app has solved this problem. Thanks, kannav rajeev wrote: ---
**Author:** ![Colin\_Law1](https://avatars.discourse-cdn.com/v4/letter/c/91b2a8/32.png) [@Colin\_Law1](https://discuss.rubyonrails.org/u/Colin_Law1)\ **Post date:** [March 5, 2010, 4:32pm UTC](https://discuss.rubyonrails.org/t/errors-in-rake-db-create/49815/10 "2010-03-05T16:32:40Z")
Which app? Colin