After a couple hours of agonizing confusion, I've discovered another source of possible trouble with MySQL and Rails tests. If you use a MySQL configuration file (my.cnf, which typically lives in /etc/my.cnf), there is a section that says "Uncomment the following if you are using InnoDB tables". If you do indeed uncomment that section, to all appearances it works fine in the app, but it breaks a bunch of tests. This might be because those lines only work if *all* the tables are InnoDB, but the schema_info table used by the Rails tests is MyISAM. That mismatch might be causing the problem. In any case, avoiding a my.cnf file in your development/test environment is the way to go.
Michael On Sat, Jun 7, 2008 at 12:13 PM, Long Nguyen <[EMAIL PROTECTED]> wrote: > What was the previous version of MySQL? > > Since the gem does do some native compilations, it's possible that the > version mismatch between your old install and new install was the source of > the errors. > > Long > > On Fri, Jun 6, 2008 at 11:26 PM, megatoast <[EMAIL PROTECTED]> wrote: >> >> AHHHHHHHHHHHHHHHHHHHHHH. >> >> finally figured out the problem. >> >> if you have the MySQL gem installed and a previous standalone MySQL >> installation, that causes a conflict. I'm not sure why, but once i >> uninstalled the gem, i was able to get rake going. hope this helps >> anyone who's having problem with raking MySQL. >> >> -steven >> >> On Jun 6, 11:10 pm, megatoast <[EMAIL PROTECTED]> wrote: >> > any ideas what's wrong with my rake install for MySQL? >> > >> > _______________>(in C:/Workspace/insoshiMySQL) >> > >> > ** Invoke install (first_time) >> > ** Invoke environment (first_time) >> > ** Execute environment >> > rake install >> > ** Execute install >> > ** Invoke db:migrate (first_time) >> > ** Invoke environment >> > ** Execute db:migrate >> > rake aborted! >> > NULL pointer given >> > (eval):3:in `each_hash' >> > (eval):3:in `all_hashes' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > connection_adapters/mysql_adapter.rb:482:in `select_without_analyzer' >> > C:/Workspace/insoshiMySQL/vendor/plugins/query_analyzer/lib/ >> > query_analyzer.rb:44:in `select' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/../../ >> > activesupport/lib/active_support/buffered_logger.rb:25:in `silence' >> > C:/Workspace/insoshiMySQL/vendor/plugins/query_analyzer/lib/ >> > query_analyzer.rb:42:in `select' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > connection_adapters/abstract/database_statements.rb:7:in >> > `select_all_without_query_cache' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > connection_adapters/abstract/query_cache.rb:55:in `select_all' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > connection_adapters/abstract/database_statements.rb:13:in `select_one' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > connection_adapters/abstract/database_statements.rb:19:in >> > `select_value' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > migration.rb:319:in `current_version' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > migration.rb:335:in `current_version' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > migration.rb:414:in `irrelevant_migration?' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > migration.rb:345:in `migrate' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > migration.rb:339:in `each' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > migration.rb:339:in `migrate' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > migration.rb:307:in `up' >> > C:/Workspace/insoshiMySQL/vendor/rails/activerecord/lib/active_record/ >> > migration.rb:298:in `migrate' >> > C:/Workspace/insoshiMySQL/vendor/rails/railties/lib/tasks/ >> > databases.rake:85 >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `execute' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `execute' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in >> > `invoke_with_call_chain' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in >> > `synchronize' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in >> > `invoke_with_call_chain' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke' >> > C:/Workspace/insoshiMySQL/lib/tasks/install.rake:7 >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:544:in `call' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:544:in `execute' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `execute' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in >> > `invoke_with_call_chain' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in >> > `synchronize' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in >> > `invoke_with_call_chain' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in >> > `invoke_task' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in >> > `top_level' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `each' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in >> > `top_level' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in >> > `standard_exception_handling' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in >> > `top_level' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in `run' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in >> > `standard_exception_handling' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in `run' >> > c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31 >> > c:/ruby/bin/rake:19:in `load' >> > c:/ruby/bin/rake:19 >> > >> > ___________________ >> > >> > On Jun 3, 10:15 pm, "Michael Hartl" <[EMAIL PROTECTED]> wrote: >> > >> > > # SQLite version 3.x >> > > # gem install sqlite3-ruby (not necessary on OS X Leopard) >> > > # development: >> > > # adapter: sqlite3 >> > > # database: db/development.sqlite3 >> > > # timeout: 5000 >> > > development: >> > > adapter: mysql >> > > database: insoshi_development >> > > username: root >> > > password: >> > > timeout: 5000 >> > >> > > # 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: mysql >> > > database: insoshi_test >> > > username: root >> > > password: >> > > timeout: 5000 >> > >> > > On Tue, Jun 3, 2008 at 7:18 PM, megatoast <[EMAIL PROTECTED]> wrote: >> > >> > > > I was able to rake install using sqlite on a windows vista machine >> > > > but >> > > > not MySQL which was what I was hoping to use. >> > > > Michael, is there anyway you can post your database.yml so i can see >> > > > if i'm missing anything? >> > >> > > > -steven >> > >> > > > On May 20, 2:52 pm, "Michael Hartl" <[EMAIL PROTECTED]> wrote: >> > > >> Strange. Is anyone else having this problem? Let us know if you >> > > >> find >> > > >> a solution. >> > >> > > >> Michael >> > >> > > >> On Tue, May 20, 2008 at 12:04 PM, Kless <[EMAIL PROTECTED]> >> > > >> wrote: >> > >> > > >> > I got *94 failures* withMySQLv5.0.51 on Ubuntu Hardy, x86_64 >> > >> > > >> > On 20 mayo, 18:30, "Michael Hartl" <[EMAIL PROTECTED]> wrote: >> > > >> >> The specs pass for me withMySQL. >> > > > > -- > Long Nguyen > [EMAIL PROTECTED] > > > -- Michael Hartl Insoshi social software http://insoshi.com/ --~--~---------~--~----~------------~-------~--~----~ Insoshi developer site: http://dogfood.insoshi.com/ Insoshi documentation: http://docs.insoshi.com/ You received this message because you are subscribed to the Google Groups "Insoshi" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/insoshi?hl=en -~----------~----~----~----~------~----~------~--~---
