On 18 September 2011 10:29, gato pardo <gato.pa...@gmail.com> 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.

Colin
-- 
gplus.to/clanlaw

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

Reply via email to