Thanks for the response, David. I just switched to mysql 4 and it works.
On 11/29/05, David Rupp <[EMAIL PROTECTED]> wrote: > Ben, > > There's a bug recorded at http://bugs.mysql.com/bug.php?id=14786; > seems to be a known issue with MySQL 5. There's also a post at http:// > wordpress.org/support/topic/46047 that recommends disabling "strict > mode". I'm not on MySQL5 yet, so I can't vouch for this fix. Sounds > like it's worth a try though. > > Regards, > David > > On Nov 29, 2005, at 6:05 AM, Ben Anderson wrote: > > > Annoying me again, > > Sorry for berating this list... and sorry if I sounded annoyed > > previously - seems everything is fine here. I tried posting this > > question over the weekend and as I recall, it may not have gone > > through. Anyways, here it is again. I apologize if this already came > > through the other day. Is there an archive of this list I could check > > such things? I see the rails list is mirrored in the forums, but I > > don't see this list. > > > > I'd like to submit a patch and am following the steps on this page: > > http://dev.rubyonrails.org/ > > > > Here's what I did (using mysql 5.0.15-nt): > > > > created 2 databases: > > activerecord_unittest > > activerecord_unittest2 > > > > created 1 user: rails (giving all priveleges to both databases) > > > > ran $RAILS_HOME/activerecord\test\fixtures\db_definitions\mysql.sql on > > activerecord_unittest > > ran $RAILS_HOME/activerecord\test\fixtures\db_definitions\mysql2.sql > > on activerecord_unittest2 > > > > modified $RAILS_HOME/activerecord\test\connections\native_mysql/ > > connect.rb > > accordingly > > > > I removed all my local changes, so I'm running with a pristine copy of > > the current trunk. > > cd $RAILS_HOME/activerecord > > rake test_mysql > > > > below I posted the output I received. I'm assuming at least most of > > the tests should pass, if not all and that I've got something screwed > > up. Anyone have any ideas? Can someone let me if the tests should > > pass? > > Thanks, > > Ben > > > > > > (in C:/ruby/projects/rails/projects/myWardrobe/vendor/rails/ > > activerecord) > > Using native MySQL > > Loaded suite c:/ruby/ruby-1.8.2-15/ruby/lib/ruby/gems/1.8/gems/ > > rake-0.6.2/lib/rake/rake_test_loader > > Started > > ........EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE > > EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE > > EEEEEEEE.................EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE...... > > ...................................................................... > > ...................F.............F.......EEEEEEEEEEEEEEEEEEEEEEEEEEEEE > > EEEEEEE...EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE....EE > > EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE.......................E...E... > > .......E............F............EEE..............EEEEEEE............. > > .......FF....F........................................................ > > ............................. > > Finished in 77.0 seconds. > > > > 1) Error: > > test_adding_macro_callbacks(AssociationCallbacksTest): > > ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field 'type' > > doesn't have a default value: INSERT INTO projects (`name`, `id`) > > VALUES ('Active Record', 1) > > ./test/../lib/active_record/connection_adapters/ > > abstract_adapter.rb:78:in > > `log' > > ./test/../lib/active_record/connection_adapters/ > > mysql_adapter.rb:181:in > > `execute' > > ./test/../lib/active_record/fixtures.rb:284:in `insert_fixtures' > > ./test/../lib/active_record/fixtures.rb:283:in `each' > > ./test/../lib/active_record/fixtures.rb:283:in `insert_fixtures' > > ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:253:in `each' > > ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:251:in `transaction' > > ./test/../lib/active_record/fixtures.rb:251:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:244:in `silence' > > ./test/../lib/active_record/fixtures.rb:244:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:539:in `load_fixtures' > > ./test/../lib/active_record/fixtures.rb:487:in > > `setup_with_fixtures' > > ./test/../lib/active_record/fixtures.rb:521:in `setup' > > ./test/../lib/active_record/fixtures.rb:520:in `setup' > > > > 2) Error: > > test_adding_with_proc_callbacks(AssociationCallbacksTest): > > ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field 'type' > > doesn't have a default value: INSERT INTO projects (`name`, `id`) > > VALUES ('Active Record', 1) > > ./test/../lib/active_record/connection_adapters/ > > abstract_adapter.rb:78:in > > `log' > > ./test/../lib/active_record/connection_adapters/ > > mysql_adapter.rb:181:in > > `execute' > > ./test/../lib/active_record/fixtures.rb:284:in `insert_fixtures' > > ./test/../lib/active_record/fixtures.rb:283:in `each' > > ./test/../lib/active_record/fixtures.rb:283:in `insert_fixtures' > > ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:253:in `each' > > ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:251:in `transaction' > > ./test/../lib/active_record/fixtures.rb:251:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:244:in `silence' > > ./test/../lib/active_record/fixtures.rb:244:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:539:in `load_fixtures' > > ./test/../lib/active_record/fixtures.rb:487:in > > `setup_with_fixtures' > > ./test/../lib/active_record/fixtures.rb:521:in `setup' > > ./test/../lib/active_record/fixtures.rb:520:in `setup' > > > > 3) Error: > > test_dont_add_if_before_callback_raises_exception > > (AssociationCallbacksTest): > > ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field 'type' > > doesn't have a default value: INSERT INTO projects (`name`, `id`) > > VALUES ('Active Record', 1) > > ./test/../lib/active_record/connection_adapters/ > > abstract_adapter.rb:78:in > > `log' > > ./test/../lib/active_record/connection_adapters/ > > mysql_adapter.rb:181:in > > `execute' > > ./test/../lib/active_record/fixtures.rb:284:in `insert_fixtures' > > ./test/../lib/active_record/fixtures.rb:283:in `each' > > ./test/../lib/active_record/fixtures.rb:283:in `insert_fixtures' > > ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:253:in `each' > > ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:251:in `transaction' > > ./test/../lib/active_record/fixtures.rb:251:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:244:in `silence' > > ./test/../lib/active_record/fixtures.rb:244:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:539:in `load_fixtures' > > ./test/../lib/active_record/fixtures.rb:487:in > > `setup_with_fixtures' > > ./test/../lib/active_record/fixtures.rb:521:in `setup' > > ./test/../lib/active_record/fixtures.rb:520:in `setup' > > > > 4) Error: > > test_has_and_belongs_to_many_add_callback(AssociationCallbacksTest): > > ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field 'type' > > doesn't have a default value: INSERT INTO projects (`name`, `id`) > > VALUES ('Active Record', 1) > > ./test/../lib/active_record/connection_adapters/ > > abstract_adapter.rb:78:in > > `log' > > ./test/../lib/active_record/connection_adapters/ > > mysql_adapter.rb:181:in > > `execute' > > ./test/../lib/active_record/fixtures.rb:284:in `insert_fixtures' > > ./test/../lib/active_record/fixtures.rb:283:in `each' > > ./test/../lib/active_record/fixtures.rb:283:in `insert_fixtures' > > ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:253:in `each' > > ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:251:in `transaction' > > ./test/../lib/active_record/fixtures.rb:251:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:244:in `silence' > > ./test/../lib/active_record/fixtures.rb:244:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:539:in `load_fixtures' > > ./test/../lib/active_record/fixtures.rb:487:in > > `setup_with_fixtures' > > ./test/../lib/active_record/fixtures.rb:521:in `setup' > > ./test/../lib/active_record/fixtures.rb:520:in `setup' > > > > ... > > bunch of smiliar stuff in the middle > > ... > > > > > > 326) Error: > > test_readonly_scoping(ReadOnlyTest): > > ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field 'type' > > doesn't have a default value: INSERT INTO projects (`name`, `id`) > > VALUES ('Active Record', 1) > > ./test/../lib/active_record/connection_adapters/ > > abstract_adapter.rb:78:in > > `log' > > ./test/../lib/active_record/connection_adapters/ > > mysql_adapter.rb:181:in > > `execute' > > ./test/../lib/active_record/fixtures.rb:284:in `insert_fixtures' > > ./test/../lib/active_record/fixtures.rb:283:in `each' > > ./test/../lib/active_record/fixtures.rb:283:in `insert_fixtures' > > ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:253:in `each' > > ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:251:in `transaction' > > ./test/../lib/active_record/fixtures.rb:251:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:244:in `silence' > > ./test/../lib/active_record/fixtures.rb:244:in `create_fixtures' > > ./test/../lib/active_record/fixtures.rb:539:in `load_fixtures' > > ./test/../lib/active_record/fixtures.rb:487:in `setup' > > > > 327) Failure: > > test_callback_rollback_in_save(TransactionTest) > > [./test/transactions_test.rb:119]: > > <false> is not true. > > > > 328) Failure: > > test_failing_on_exception(TransactionTest) [./test/ > > transactions_test.rb:87]: > > First shouldn't have been approved. > > <false> is not true. > > > > 329) Failure: > > test_successful_with_return(TransactionTest) [./test/ > > transactions_test.rb:49]: > > <false> is not true. > > > > 659 tests, 1142 assertions, 6 failures, 323 errors > > rake aborted! > > Command failed with status (1): [c:/ruby/ruby-1.8.2-15/ruby/bin/ > > ruby -Ilib;...] > > _______________________________________________ > > Rails-core mailing list > > [email protected] > > http://lists.rubyonrails.org/mailman/listinfo/rails-core > > _______________________________________________ > Rails-core mailing list > [email protected] > http://lists.rubyonrails.org/mailman/listinfo/rails-core > _______________________________________________ Rails-core mailing list [email protected] http://lists.rubyonrails.org/mailman/listinfo/rails-core
