i''m using a table, that uses fulltext search and therefore the table type MyISAM everything works fine in production mode, but tests fail with ActiveRecord::StatementInvalid: Mysql::Error: The used table type doesn''t support FULLTEXT indexes when looking in the test db it''s clear, that it''s using InnoDB, but even manually changing the table type does not help, since it''s created new for every test run (we use rspec, but it''s the same for normal test) migration: create_table :pages, :options => "engine=MyISAM" do |t| ... end should work that way and does in development mode... -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 13 Feb 2008, at 13:09, Thorsten Mueller wrote:> > i''m using a table, that uses fulltext search and therefore the table > type MyISAM > everything works fine in production mode, but tests fail with > > ActiveRecord::StatementInvalid: Mysql::Error: The used table type > doesn''t support FULLTEXT indexes > > when looking in the test db it''s clear, that it''s using InnoDB, but > even > manually changing the table type does not help, since it''s created new > for every test run > > (we use rspec, but it''s the same for normal test) > > migration: > > create_table :pages, :options => "engine=MyISAM" do |t| > ... > endAre you using the ruby schema dumped? it doesn''t support options like that IIRC (you can turn this on/off in environment.rb)> > > should work that way and does in development mode... > -- > Posted via http://www.ruby-forum.com/. > > >--~--~---------~--~----~------------~-------~--~----~ 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-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
> Are you using the ruby schema dumped? it doesn''t support options like > that IIRC (you can turn this on/off in environment.rb)yep, that was it! thanks a lot -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---