My problem is solved. I reinstall and upgrade mysql and it is working good now.
Yudi Soesanto On Mon, Mar 15, 2010 at 7:00 PM, Yudi Soesanto <soesa...@gmail.com> wrote: > I have installed current mysql gem 2.8 I tried these combination but I > still get the error > > * > sudo gem install mysql -v 2.7 --no-rdoc --no-ri mysql -- > --with-mysql-dir=/usr/local > --with-mysql-config=/usr/local/mysql/bin/mysql_config > > macbooks-computer:~/desktop/work/myproject/basketball macbook$ > script/console > Loading development environment (Rails 2.3.5) > >> Stat.find(:all) > > NameError: uninitialized constant MysqlCompat::MysqlRes > from > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:440:in > `load_missing_constant' > from > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:80:in > `const_missing' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/mysql_adapter.rb:9:in > `define_all_hashes_method!' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/mysql_adapter.rb:68:in > `mysql_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in > `send' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in > `new_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in > `checkout_new_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in > `checkout' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in > `loop' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in > `checkout' > > from /usr/local/lib/ruby/1.8/monitor.rb:238:in `synchronize' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in > `checkout' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in > `connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in > `retrieve_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in > `retrieve_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in > `connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:3113:in > `quoted_table_name' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:1684:in > `construct_finder_sql' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:1548:in > `find_every' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:615:in > `find' > from (irb):1>> > > > > sudo gem install mysql --no-rdoc --no-ri mysql -- > --with-mysql-dir=/usr/local > --with-mysql-config=/usr/local/mysql/bin/mysql_config > > macbooks-computer:~/desktop/work/myproject/basketball macbook$ > script/console > Loading development environment (Rails 2.3.5) > >> Stat.find(:all) > > NameError: uninitialized constant MysqlCompat::MysqlRes > from > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:440:in > `load_missing_constant' > from > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:80:in > `const_missing' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/mysql_adapter.rb:9:in > `define_all_hashes_method!' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/mysql_adapter.rb:68:in > `mysql_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in > `send' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in > `new_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in > `checkout_new_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in > `checkout' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in > `loop' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in > `checkout' > > from /usr/local/lib/ruby/1.8/monitor.rb:238:in `synchronize' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in > `checkout' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in > `connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in > `retrieve_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in > `retrieve_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in > `connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:3113:in > `quoted_table_name' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:1684:in > `construct_finder_sql' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:1548:in > `find_every' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:615:in > `find' > from (irb):1>> > > > sudo gem install mysql --no-rdoc --no-ri mysql -- > --with-mysql-dir=/usr/local > --with-mysql-config=/usr/local/mysql/bin/mysql_config > --with-mysql-lib=/usr/local/mysql/bin/mysql > > * > macbooks-computer:~/desktop/work/myproject/basketball macbook$ > script/console > Loading development environment (Rails 2.3.5) > >> Stat.find(:all) > > NameError: uninitialized constant MysqlCompat::MysqlRes > from > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:440:in > `load_missing_constant' > from > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:80:in > `const_missing' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/mysql_adapter.rb:9:in > `define_all_hashes_method!' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/mysql_adapter.rb:68:in > `mysql_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in > `send' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in > `new_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in > `checkout_new_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in > `checkout' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in > `loop' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in > `checkout' > > from /usr/local/lib/ruby/1.8/monitor.rb:238:in `synchronize' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in > `checkout' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in > `connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in > `retrieve_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in > `retrieve_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in > `connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:3113:in > `quoted_table_name' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:1684:in > `construct_finder_sql' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:1548:in > `find_every' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:615:in > `find' > from (irb):1>> > > *sudo gem install mysql -v 2.7 --no-rdoc --no-ri mysql -- > --with-mysql-dir=/usr/local > --with-mysql-config=/usr/local/mysql/bin/mysql_config > --with-mysql-lib=/usr/local/mysql/bin/mysql* > > > macbooks-computer:~/desktop/work/myproject/basketball macbook$ > script/console > Loading development environment (Rails 2.3.5) > >> Stat.find(:all) > !!! The bundled mysql.rb driver has been removed from Rails 2.2. Please > install the mysql gem and try again: gem install mysql. > LoadError: Failed to lookup Init function > /usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle > from /usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle > from > /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:36:in `require' > from > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:156:in > `require' > from > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:521:in > `new_constants_in' > from > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/dependencies.rb:156:in > `require' > from > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/core_ext/kernel/requires.rb:7:in > `require_library_or_gem' > from > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/core_ext/kernel/reporting.rb:11:in > `silence_warnings' > from > /usr/local/lib/ruby/gems/1.8/gems/activesupport-2.3.5/lib/active_support/core_ext/kernel/requires.rb:5:in > `require_library_or_gem' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/mysql_adapter.rb:61:in > `mysql_connection' > > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in > `send' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in > `new_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:in > `checkout_new_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in > `checkout' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in > `loop' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in > `checkout' > > from /usr/local/lib/ruby/1.8/monitor.rb:238:in `synchronize' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in > `checkout' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:in > `connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in > `retrieve_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:in > `retrieve_connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in > `connection' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:3113:in > `quoted_table_name' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:1684:in > `construct_finder_sql' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:1548:in > `find_every' > from > /usr/local/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/base.rb:615:in > `find' > from (irb):1>> > > > > *here are my gems:* > abstract (1.0.0) > actionmailer (2.3.5, 2.0.2, 1.3.3) > actionpack (2.3.5, 2.0.2, 1.13.3) > actionwebservice (1.2.3) > active_form (0.0.6) > activemerchant (1.3.2) > activerecord (2.3.5, 2.0.2, 1.15.3) > activeresource (2.3.5, 2.0.2) > activesupport (2.3.5, 2.0.2, 1.4.2) > builder (2.1.2) > bundler (0.9.11) > camping (1.5.180) > capistrano (2.5.14, 2.1.0, 1.4.1) > cgi_multipart_eof_fix (2.5.0, 2.2, 2.1) > color (1.4.1) > contacts (1.0.12, 1.0.11) > crack (0.1.6) > curb (0.1.4) > daemons (1.0.9, 1.0.7, 1.0.6) > erubis (2.6.5) > facebooker (1.0.64) > fastercsv (1.5.0) > fastthread (1.0.1, 1.0) > gem_plugin (0.2.3, 0.2.2) > gemcutter (0.5.0) > git (1.2.5) > google-geocode (1.2.1) > googlecharts (1.5.1) > hashie (0.1.8) > highline (1.4.0, 1.2.9) > hobo (0.7.5) > hobofields (0.7.5) > hobosupport (0.7.5) > hoe (1.12.2, 1.8.2, 1.8.1, 1.5.0) > hpricot (0.8.1) > httparty (0.5.2) > jeweler (1.4.0) > json (1.1.2) > json_pure (1.2.0) > linkedin (0.1.7) > login_generator (1.2.2) > markaby (0.5) > mechanize (0.9.2) > metaid (1.0) > mime-types (1.15) > mini_magick (1.2.3) > mongrel (1.1.3, 1.0.1) > mongrel_cluster (1.0.5, 1.0.2, 0.2.1) > mysql (2.8.1) > needle (1.3.0) > net-scp (1.0.2) > net-sftp (2.0.4, 1.1.0) > net-ssh (2.0.19, 1.1.2, 1.1.1) > net-ssh-gateway (1.0.1) > nokogiri (1.4.1, 1.3.0) > oauth (0.3.6) > pdf-writer (1.1.8) > racc (1.4.6) > rack (1.0.1) > rails (2.3.5, 2.0.2, 1.2.3) > railsmachine (1.0.6, 1.0.0, 0.1.2) > rake (0.8.7, 0.8.3, 0.8.1, 0.7.3) > rake-compiler (0.5.0) > rc-rest (2.2.1) > RedCloth (4.2.2, 3.0.4) > rflickr (2006.02.01) > rmagick (1.15.7) > roxml (3.1.5) > rspec (1.1.11) > ruby-debug (0.10.0) > ruby-debug-base (0.10.0) > ruby-hmac (0.4.0) > ruby-ole (1.2.10) > ruby-openid (2.0.2, 1.1.4) > ruby-yadis (0.3.4) > ruby_parser (2.0.4) > rubyforge (2.0.3, 1.0.3, 1.0.1, 0.4.4) > rubygems-update (1.3.6) > rufus-cloche (0.1.13) > rufus-dollar (1.0.2) > rufus-json (0.1.0) > rufus-lru (1.0.2) > rufus-mnemo (1.1.1) > rufus-scheduler (2.0.3) > rufus-treechecker (1.0.3) > ruote (2.1.1) > scrubyt (0.4.06) > sexp_processor (3.0.3) > sinatra (0.9.4) > sources (0.0.1) > spreadsheet-excel (0.3.5.1) > tenderlove-frex (1.0.1.20090313144615) > termios (0.9.4) > test-spec (0.10.0) > transaction-simple (1.4.0) > twitter (0.8.6) > tzinfo (0.3.3) > validatable (1.6.7) > will_paginate (2.2.2) > xml-simple (1.0.11) > ym4r (0.6.0) > youtube-g (0.4.9.9) > ZenTest (4.2.1, 3.9.1) > > Do you guys have any suggestion? > > Yudi Soesanto > > > > On Mon, Mar 15, 2010 at 7:32 AM, Yudi Soesanto <soesa...@gmail.com> wrote: > >> I removed mysql 2.8 gem and reinstall mysql 2.7 with this command: >> >> *sudo gem install mysql -v 2.7 --no-rdoc --no-ri mysql -- >> --with-mysql-dir=/usr/local >> --with-mysql-config=/usr/local/mysql/bin/mysql_config* >> >> Now, when I run rake db:create, it will give me this error: >> !!! The bundled mysql.rb driver has been removed from Rails 2.2. Please >> install the mysql gem and try again: gem install mysql. >> rake aborted! >> Failed to lookup Init function >> /usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle >> >> (See full trace by running task with --trace) >> >> any idea? >> >> Yudi Soesanto >> >> >> >> On Mon, Mar 15, 2010 at 6:56 AM, Yudi Soesanto <soesa...@gmail.com>wrote: >> >>> Ok, I did require 'rubygems' and then require 'mysql'. They are return >>> true >>> >>> *irb(main):001:0> require 'rubygems' >>> => true >>> irb(main):002:0> require 'mysql' >>> => true* >>> >>> Is that mean mysql gem ok? Please be advise. >>> >>> >>> >>> On Mon, Mar 15, 2010 at 6:40 AM, Frederick Cheung < >>> frederick.che...@gmail.com> wrote: >>> >>>> >>>> >>>> On Mar 15, 10:29 am, Yudi Soesanto <soesa...@gmail.com> wrote: >>>> > Ok, used 2 different command: irb and ruby script/console. >>>> > >>>> > *I use irb and run this command:* >>>> > irb(main):001:0> require 'mysql' >>>> > LoadError: no such file to load -- mysql >>>> > from (irb):1:in `require' >>>> > from (irb):1 >>>> > >>>> You need to require rubygems first (Keep an eye on the system logs (in >>>> the console app) while you do this >>>> >>>> The main difference between 2.0.2 and 2.3.5 is that 2.3.4 no longer >>>> has a fallback version of the mysql driver (written in ruby) - it's >>>> likely that your mysql driver has never been properly installed. >>>> >>>> Fred >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Ruby on Rails: Talk" group. >>>> To post to this group, send email to rubyonrails-t...@googlegroups.com. >>>> To unsubscribe from this group, send email to >>>> rubyonrails-talk+unsubscr...@googlegroups.com<rubyonrails-talk%2bunsubscr...@googlegroups.com> >>>> . >>>> For more options, visit this group at >>>> http://groups.google.com/group/rubyonrails-talk?hl=en. >>>> >>>> >>> >> > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.