On 18 September 2011 10:35, Colin Law <[email protected]> wrote:
> On 18 September 2011 10:29, gato pardo <[email protected]> wrote:
>> [...]
>>   1.- Results with Pack.find 1
>>
>> "irb(main):001:0> Pack.find 1
>> Could not log "sql.active_record" event. NoMethodError: undefined method
>> `name' for nil:NilClass
>> PGError: ERROR:  zero-length delimited identifier at or near """"
>> LINE 1: SELECT  "packs".* FROM "packs"  WHERE "packs"."" = $1 LIMIT ...
>>                                                       ^
>> : SELECT  "packs".* FROM "packs"  WHERE "packs"."" = $1 LIMIT 1
>> ActiveRecord::StatementInvalid: PGError: ERROR:  zero-length delimited
>> identifier at or near """"
>> LINE 1: SELECT  "packs".* FROM "packs"  WHERE "packs"."" = $1 LIMIT ...
>>                                                       ^
>> : SELECT  "packs".* FROM "packs"  WHERE "packs"."" = $1 LIMIT 1
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:968:in
>> `prepare'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:968:in
>> `exec_cache'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:552:in
>> `exec_query'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:244:in
>> `log'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activesupport-3.1.0/lib/active_support/notifications/instrumenter.rb:21:in
>> `instrument'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:239:in
>> `log'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:550:in
>> `exec_query'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:1031:in
>> `select'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in
>> `select_all'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in
>> `select_all'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/base.rb:470:in
>> `find_by_sql'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/relation.rb:111:in
>> `to_a'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/relation/finder_methods.rb:370:in
>> `find_first'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/relation/finder_methods.rb:122:in
>> `first'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/relation/finder_methods.rb:328:in
>> `find_one'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/relation/finder_methods.rb:304:in
>> `find_with_ids'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/relation/finder_methods.rb:107:in
>> `find'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/base.rb:441:in
>> `__send__'
>>     from
>> /usr/lib/ruby/gems/1.8/gems/activerecord-3.1.0/lib/active_record/base.rb:441:in
>> `find'
>> "
>>
>> 2.- I do not have a file db/schema.rb.
>>     I am just using my database through config/database.yml.
>
> Well you should have, you should have used rails migrations to create
> the db, unless this is a legacy database.  Create schema.rb by running
> rake db:schema:dump
> and post it here, though whether this is anything to do with the
> problem is unlikely.

Also post model/pack.rb please.

Colin

-- 
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 [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to