Getting undefined method 'add_order!' error on a new Ruby 1.9.3/Rails 4.0.0 project

[rnhurt]

I created a brand new Rails 4.0.0 project and replaced gem 'sqlite3' in the Gemfile with:

gem 'tiny_tds'
gem 'activerecord-sqlserver-adapter'

I'm getting the following error when trying to start Rails or running the console:

/Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@api/gems/activesupport-4.0.0/lib/active_support/core_ext/module/aliasing.rb:32:in `alias_method': undefined method `add_order!' for class `Class' (NameError)
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@api/gems/activesupport-4.0.0/lib/active_support/core_ext/module/aliasing.rb:32:in `alias_method_chain'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@api/gems/activerecord-sqlserver-adapter-2.3.8/lib/active_record/connection_adapters/sqlserver_adapter/core_ext/active_record.rb:14:in `singletonclass'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@api/gems/activerecord-sqlserver-adapter-2.3.8/lib/active_record/connection_adapters/sqlserver_adapter/core_ext/active_record.rb:12:in `included'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@api/gems/activerecord-sqlserver-adapter-2.3.8/lib/active_record/connection_adapters/sqlserver_adapter/core_ext/active_record.rb:145:in `include'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@api/gems/activerecord-sqlserver-adapter-2.3.8/lib/active_record/connection_adapters/sqlserver_adapter/core_ext/active_record.rb:145:in `<top (required)>'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@api/gems/activerecord-sqlserver-adapter-2.3.8/lib/active_record/connection_adapters/sqlserver_adapter.rb:3:in `require'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@api/gems/activerecord-sqlserver-adapter-2.3.8/lib/active_record/connection_adapters/sqlserver_adapter.rb:3:in `<top (required)>'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@api/gems/activerecord-sqlserver-adapter-2.3.8/lib/activerecord-sqlserver-adapter.rb:1:in `require'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@api/gems/activerecord-sqlserver-adapter-2.3.8/lib/activerecord-sqlserver-adapter.rb:1:in `<top (required)>'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:72:in `require'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:72:in `block (2 levels) in require'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:70:in `each'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:70:in `block in require'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:59:in `each'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:59:in `require'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@global/gems/bundler-1.3.5/lib/bundler.rb:132:in `require'
    from /Users/rnhurt/src/ik/sqltest/config/application.rb:7:in `<top (required)>'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@api/gems/railties-4.0.0/lib/rails/commands.rb:62:in `require'
    from /Users/rnhurt/.rvm/gems/ruby-1.9.3-p448@api/gems/railties-4.0.0/lib/rails/commands.rb:62:in `<top (required)>'
    from bin/rails:4:in `require'
    from bin/rails:4:in `<main>'

[rnhurt]

Hmmmm.... using gem 'activerecord-sqlserver-adapter', git: 'https://github.com/Desarrollo-CeSPI/activerecord-sqlserver-adapter.git' in my Gemfile seems to get me past this issue.

I'm guessing that the latest version of this Gem '3.2.12' works with Rails 4 but the gemspec hasen't been updated yet to reflect that.

[kevinbeck]

Are you able to run rake db:migrate or rake db:seed?

If you create a brand new project again with rails 4 and add the activerecord-sqlserver-adapter (without the git source) what version of the activerecord-sqlserver-adapter do you get?

[rnhurt]

Here's what I did:

1. Using RVM on OS X, I created a new gemset and installed the Rails 4.0.0 gem.
2. Created a new project and added the gem 'activerecord-sqlserver-adapter' line to the Gemfile.
3. Ran bundle install
4. Ran gem list | grep activerecord resulted in this:

activerecord (4.0.0)
activerecord-deprecated_finders (1.0.3)
activerecord-sqlserver-adapter (2.3.8)

I have no idea why it chose 2.3.8. I even ran a bundle update to see if that would update it somehow, but it didn't change anything.

BTW: Trying to run rails generate model User still gives me the same error as before.

[thatdom]

Same problem here.

Is Rails 4 support coming soon?

[veravira]

Same issue

[ringe]

+1 same issue

[cr0t]

+1 with Rails 4.0.0
@rnhurt's solution helped me to pass this error.

[smn8600]

+1 same issue

[RammohanRaju]

+1 same issue..
did anyone get the solution?? if so could you please update it
thanks in advance

[ringe]

I switched to Rails 3.2, where this issue did not appear.

[dugsmith]

+1 on Rails 4.0.1/Ruby 2.0.0-p247. We are looking forward to a fix for this as well.

/usr/local/rvm/gems/ruby-2.0.0-p247/gems/activesupport-4.0.1/lib/active_support/core_ext/module/aliasing.rb:32:in `alias_method': undefined method `add_order!' for class `Class' (NameError)
    from /usr/local/rvm/gems/ruby-2.0.0-p247/gems/activesupport-4.0.1/lib/active_support/core_ext/module/aliasing.rb:32:in `alias_method_chain'
    from /usr/local/rvm/gems/ruby-2.0.0-p247/gems/activerecord-sqlserver-adapter-2.3.8/lib/active_record/connection_adapters/sqlserver_adapter/core_ext/active_record.rb:14:in `singleton class'
    from /usr/local/rvm/gems/ruby-2.0.0-p247/gems/activerecord-sqlserver-adapter-2.3.8/lib/active_record/connection_adapters/sqlserver_adapter/core_ext/active_record.rb:12:in `included'
    from /usr/local/rvm/gems/ruby-2.0.0-p247/gems/activerecord-sqlserver-adapter-2.3.8/lib/active_record/connection_adapters/sqlserver_adapter/core_ext/active_record.rb:145:in `include'
    from /usr/local/rvm/gems/ruby-2.0.0-p247/gems/activerecord-sqlserver-adapter-2.3.8/lib/active_record/connection_adapters/sqlserver_adapter/core_ext/active_record.rb:145:in `<top (required)>'
    from /usr/local/rvm/gems/ruby-2.0.0-p247/gems/activerecord-sqlserver-adapter-2.3.8/lib/active_record/connection_adapters/sqlserver_adapter.rb:3:in `require'
    from /usr/local/rvm/gems/ruby-2.0.0-p247/gems/activerecord-sqlserver-adapter-2.3.8/lib/active_record/connection_adapters/sqlserver_adapter.rb:3:in `<top (required)>'
    from /usr/local/rvm/gems/ruby-2.0.0-p247/gems/activerecord-sqlserver-adapter-2.3.8/lib/activerecord-sqlserver-adapter.rb:1:in `require'
    from /usr/local/rvm/gems/ruby-2.0.0-p247/gems/activerecord-sqlserver-adapter-2.3.8/lib/activerecord-sqlserver-adapter.rb:1:in `<top (required)>'
    from /usr/local/rvm/gems/ruby-2.0.0-p247@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:72:in `require'
    from /usr/local/rvm/gems/ruby-2.0.0-p247@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:72:in `block (2 levels) in require'
    from /usr/local/rvm/gems/ruby-2.0.0-p247@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:70:in `each'
    from /usr/local/rvm/gems/ruby-2.0.0-p247@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:70:in `block in require'
    from /usr/local/rvm/gems/ruby-2.0.0-p247@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:59:in `each'
    from /usr/local/rvm/gems/ruby-2.0.0-p247@global/gems/bundler-1.3.5/lib/bundler/runtime.rb:59:in `require'
    from /usr/local/rvm/gems/ruby-2.0.0-p247@global/gems/bundler-1.3.5/lib/bundler.rb:132:in `require'
    from /Users/doug.smith/Sites/activerecord_sqlserver_test/config/application.rb:7:in `<top (required)>'
    from /usr/local/rvm/gems/ruby-2.0.0-p247/gems/railties-4.0.1/lib/rails/commands.rb:43:in `require'
    from /usr/local/rvm/gems/ruby-2.0.0-p247/gems/railties-4.0.1/lib/rails/commands.rb:43:in `<top (required)>'

[erlingur]

+1 On this one as well.

[neversion]

+1 same issue, waitting for solution

[weexpectedTHIS]

+1 same

[trak3r]

Seems the issue is the gem requires an older version of activerecord than Rails:

Resolving dependencies...
Bundler could not find compatible versions for gem "activerecord":
  In Gemfile:
    activerecord-sqlserver-adapter (>= 3.2.12) ruby depends on
      activerecord (~> 3.2.0) ruby

    rails (= 4.0.0) ruby depends on
      activerecord (4.0.0)