Not able to insert value in rails console

Rails
1

I am using authlogic for authentication in rails 3.0.3 with ruby 1.9.2
Using activerecord-sqlserver-adapter (3.0.5)
windows with sqlserver database

when i create user details in rails console, i am getting below error,

User.create(:login=>‘test’,:password=>‘test123’,:password_confirmation=>‘test123’)
ActiveRecord::StatementInvalid: ODBC::Error: 37000 (102)
[Microsoft][ODBC SQL Se
rver Driver][SQL Server]Incorrect syntax near ‘LIMIT’.: SELECT
[users].[id] FROM
[users] WHERE (LOWER([users].[login]) = LOWER(N’test’)) LIMIT 1
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/connection_adapters/abstract_adapter.rb:202:in rescue in log' from c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco rd/connection_adapters/abstract_adapter.rb:194:inlog’
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-sqlserver-adapter-3.0
.5/lib/active_record/connection_adapters/sqlserver/database_statements.rb:249:in
raw_select' from c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-sqlserver-adapter-3.0 .5/lib/active_record/connection_adapters/sqlserver/database_statements.rb:193:inselect’
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/connection_adapters/abstract/database_statements.rb:7:in select_all' from c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco rd/connection_adapters/abstract/query_cache.rb:56:inselect_all’
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/base.rb:467:in find_by_sql' from c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco rd/relation.rb:64:into_a’
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/relation/finder_methods.rb:333:in find_first' from c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco rd/relation/finder_methods.rb:122:infirst’
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco
rd/relation/finder_methods.rb:180:in exists?' from c:/Ruby/lib/ruby/gems/1.9.1/gems/activerecord-3.0.3/lib/active_reco rd/validations/uniqueness.rb:39:invalidate_each’
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activemodel-3.0.3/lib/active_model
/validator.rb:154:in block in validate' from c:/Ruby/lib/ruby/gems/1.9.1/gems/activemodel-3.0.3/lib/active_model /validator.rb:151:ineach’
from
c:/Ruby/lib/ruby/gems/1.9.1/gems/activemodel-3.0.3/lib/active_model
/validator.rb:151:in validate' from c:/Ruby/lib/ruby/gems/1.9.1/gems/activesupport-3.0.3/lib/active_sup port/callbacks.rb:314:in_callback_before_85’

2

I think this is for your sql server adapter configuration
check it

3

More than likely related to this issue:

4

Alpha B. wrote in post #972808:

More than likely related to this issue:

Yes. You are correct… How i am solve this error?.. Any idea??

5

On 7 January 2011 06:02, Sathiyaraj G. [email protected]
wrote:

Alpha B. wrote in post #972808:

More than likely related to this issue:

Yes. You are correct… How i am rectify this error?.. Any idea??

The details in the link seem quite clear. Go back to Rails 3.0.1 for
the moment until the work is complete for 3.0.3. The latest comment
in the link (dated 10 hours ago as I write) states that work has
started on it.

Colin