Hi (I''m resubmitting this because
First question: This is the rails dev list, correct?
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. Is this correct or should all tests 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
........EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE.................EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE...............................................................................................F.............F.......EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE...EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE....EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE.......................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;...]
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
........EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE.................EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE...............................................................................................F.............F.......EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE...EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE....EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE.......................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;...]
> Is there an archive of this list I could check > such things?Try http://wrath.rubyonrails.org/pipermail/rails-core/ Tom _______________________________________________ Rails-core mailing list Rails-core@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails-core
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 > Rails-core@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails-core
Thanks for the response, David. I just switched to mysql 4 and it works. On 11/29/05, David Rupp <rails@ruppconsulting.com> 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 > > Rails-core@lists.rubyonrails.org > > http://lists.rubyonrails.org/mailman/listinfo/rails-core > > _______________________________________________ > Rails-core mailing list > Rails-core@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails-core >