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.