rake db:create uninitialized constant Mysql::Error

11155 · April 11, 2010, 11:19pm

I have yet to find a solution for this issue I have tried multiple things that I have found on google, but yet have i found a solution. If someone could help me and point me in the right direction I would be much appreciated.

Thanks.

rake aborted! uninitialized constant Mysql::Error

** 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! uninitialized constant Mysql::Error /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0.beta2/lib/active_record/railties/databases.rake:68:in `create_database' /Library/Ruby/Gems/1.8/gems/activerecord-3.0.0.beta2/lib/active_record/railties/databases.rake:33 /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain' /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run' /Library/Ruby/Gems/1.8/gems/rake-0.8.7/bin/rake:31 /usr/bin/rake:19:in `load' /usr/bin/rake:19

Con · April 12, 2010, 12:15am

I have yet to find a solution for this issue I have tried multiple

things that I have found on google, but yet have i found a solution. If

someone could help me and point me in the right direction I would be

much appreciated.

Thanks.

rake aborted!

uninitialized constant Mysql::Error

** 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!

uninitialized constant Mysql::Error

/Library/Ruby/Gems/1.8/gems/activerecord-3.0.0.beta2/lib/active_record/railties/databases.rake:68:in

`create_database’

/Library/Ruby/Gems/1.8/gems/activerecord-3.0.0.beta2/lib/active_record/railties/databases.rake:33

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in

`invoke_with_call_chain’

/System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/1.8/monitor.rb:242:in

`synchronize’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in

`invoke_with_call_chain’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in

`standard_exception_handling’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in

`standard_exception_handling’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run’

/Library/Ruby/Gems/1.8/gems/rake-0.8.7/bin/rake:31

/usr/bin/rake:19:in `load’

/usr/bin/rake:19

Michael, you’ll need to add mysql to your Gemfile.

Good luck,

-Conrad

11155 · April 12, 2010, 12:28am

my gem file already has it, any other solutions? I just decided to do the package install of mysql to see if i was manually installing it wrong, and nope same issue still.

source 'http://rubygems.org'

gem 'rails', '3.0.0.beta2'

# Bundle edge Rails instead: # gem 'rails', :git => 'git://github.com/rails/rails.git'

gem 'mysql'

# Use unicorn as the web server # gem 'unicorn'

# Deploy with Capistrano # gem 'capistrano'

# Bundle the extra gems: # gem 'bj' # gem 'nokogiri', '1.4.1' # gem 'sqlite3-ruby', :require => 'sqlite3' # gem 'aws-s3', :require => 'aws/s3'

# Bundle gems for certain environments: # gem 'rspec', :group => :test # group :test do # gem 'webrat' # end

John_Grimes · April 12, 2010, 2:17am

Post up the output of this command: gem list

Con · April 12, 2010, 2:26am

my gem file already has it, any other solutions? I just decided to do

the package install of mysql to see if i was manually installing it

wrong, and nope same issue still.

Michael, did you run the following in the root of your Rails application:

bundle install

-Conrad

11155 · April 12, 2010, 5:51am

Yes I did, I kind of gave up for now on this. I can't seem to figure it out.

If you could or anyone could help me out would be great.

Thanks again for the response.

Conrad Taylor wrote:

11155 · April 12, 2010, 6:04am

John Grimes wrote:

Post up the output of this command: gem list

*** LOCAL GEMS ***

abstract (1.0.0) actionmailer (3.0.0.beta2, 2.3.5, 2.2.2, 1.3.6) actionpack (3.0.0.beta2, 2.3.5, 2.2.2, 1.13.6) actionwebservice (1.2.6) activemodel (3.0.0.beta2) activerecord (3.0.0.beta2, 2.3.5, 2.2.2, 1.15.6) activeresource (3.0.0.beta2, 2.3.5, 2.2.2) activesupport (3.0.0.beta2, 2.3.5, 2.2.2, 1.4.4) acts_as_ferret (0.4.4, 0.4.3) arel (0.3.3) builder (2.1.2) bundler (0.9.18) capistrano (2.5.18, 2.5.2) cgi_multipart_eof_fix (2.5.0) daemons (1.0.10) dnssd (0.6.0) erubis (2.6.5) fastthread (1.0.1) fcgi (0.8.7) ferret (0.11.6) gem_plugin (0.2.3) highline (1.5.2, 1.5.0) hpricot (0.6.164) i18n (0.3.6) libxml-ruby (1.1.2) mail (2.2.0, 2.1.5.3) memcache-client (1.8.2) mime-types (1.16) mongrel (1.1.5) mysql (2.8.1) needle (1.3.0) net-scp (1.0.2, 1.0.1) net-sftp (2.0.4, 2.0.1, 1.1.1) net-ssh (2.0.21, 2.0.4, 1.1.4) net-ssh-gateway (1.0.1, 1.0.0) polyglot (0.3.1) rack (1.1.0, 1.0.1) rack-mount (0.6.1) rack-test (0.5.3) rails (3.0.0.beta2, 2.3.5, 2.2.2, 1.2.6) railties (3.0.0.beta2) rake (0.8.7, 0.8.3) RedCloth (4.1.1) ruby-openid (2.1.7, 2.1.2) ruby-yadis (0.3.4) rubygems-update (1.3.6) rubynode (0.1.5) sqlite3-ruby (1.2.4) termios (0.9.4) text-format (1.0.0) text-hyphen (1.0.0) thor (0.13.4) treetop (1.4.5) tzinfo (0.3.19) xmpp4r (0.5, 0.4)

Eric_Platon · June 1, 2010, 6:38am

Michael^2,

I have faced the same problem, and here is how I solved it, with the list of failures. Note that I have faced the problem only once on this particular configuration. Elsewhere (PPC and x86_64) the world is cloudless.

Configuration: - OS: Fedora 12 - Arch: PPC64 - Rails 3 pre - Gem 1.3.6 - Ruby 1.8.8 (I use 1.8.7 on my other machines, but I needed some extra patches to compile against openssl 1.0---yet another story )

(Fail 1) Installed the gem with Bundler (Fail 2) Installed the gem with gem, and bundle it with Bundler (Fail 3) Installed the library manually

Given that my repository assumes we use Bundler, I then did again (Fail 1). This is the configuration that will work in the following...

At this point, I started to go along the new Rails bootstrap process. Playing also with IRB (`rails c`) and Rake, I realized that the gems are all loaded but mysql. The most interesting:

$ rake db:setup --trace #=> Fail $ rake -r mysql db:setup --trace #=> Success, although all Mysql constants are flagged as already initialized...

Which confirms a weird behavior with the load process for the mysql gem, on that particular architecture.

In the Gemfile, I have then bypassed Gem to load the mysql library directly:

# Database #gem 'mysql' require 'mysql'

Doing so everything works fine now. I would like to understand what is happening but I am a bit short in time now Note that this modification of the Gemfile is not what we want on all machines. Given that this PPC64 machine is my production server, a simple conditional to choose between gem or require may be sufficient, waiting for a proper fix.

I hope this can help you, but I have a rare architecture these days... Not sure it is applicable directly.

Eric

11155 · August 10, 2010, 5:09am

I had similar problem after upgrading to Snow leopard, i had to reinstall the Mysql gem with right architecture flags.

Michael Michael wrote:

Andre_Fonseca · August 11, 2010, 8:18pm

you need reinstall mysql gems with correct flags. Try google this : mysql gems flags snow leopard

11155 · January 18, 2011, 1:22am

I faced this problem too, if you have installed MYSQL 5.5 you should uninstall and install MYSQL 5.1 . I just left a blog post about this : http://geryit.com/blog/2011/01/installing-mysql-with-rails-on-mac-os-x-snow-leopard/

Topic		Replies	Views
uninitialized constant ActiveRecord rubyonrails-talk	0	300	October 7, 2008
rake db:create --trace -->> rake aborted! uninitialized constant ActiveRecord rubyonrails-talk	1	130	February 1, 2008
unitialized constant ActiveRecord rubyonrails-talk	2	129	October 7, 2008
uninitialized constant CreateDb when using rake db:migrate rubyonrails-talk	2	97	September 12, 2007
uninitialized constant ActiveRecord::VERSION rubyonrails-talk	0	120	July 6, 2009

rake db:create uninitialized constant Mysql::Error

Related topics

More Resources