Skip to content

Instantly share code, notes, and snippets.

@uxp
Created April 12, 2010 06:02
Show Gist options
  • Save uxp/363315 to your computer and use it in GitHub Desktop.
Save uxp/363315 to your computer and use it in GitHub Desktop.
ActiveRecord::StatementInvalid in 'Weather.fetch_for_zipcode should populate recorded_at'
PGError: ERROR: operator does not exist: character varying = integer
LINE 1: ...ECT * FROM "weathers" WHERE ("weathers"."zipcode" = 90210) ...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
: SELECT * FROM "weathers" WHERE ("weathers"."zipcode" = 90210) LIMIT 1
/home/uxp/.rvm/gems/ruby-1.8.7-p249@rails2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:219:in `log'
/home/uxp/.rvm/gems/ruby-1.8.7-p249@rails2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:550:in `execute'
/home/uxp/.rvm/gems/ruby-1.8.7-p249@rails2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:1037:in `select_raw'
/home/uxp/.rvm/gems/ruby-1.8.7-p249@rails2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:1024:in `select'
/home/uxp/.rvm/gems/ruby-1.8.7-p249@rails2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
/home/uxp/.rvm/gems/ruby-1.8.7-p249@rails2/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract/query_cache.rb:62:in `select_all'
/home/uxp/.rvm/gems/ruby-1.8.7-p249@rails2/gems/activerecord-2.3.5/lib/active_record/base.rb:661:in `find_by_sql'
/home/uxp/.rvm/gems/ruby-1.8.7-p249@rails2/gems/activerecord-2.3.5/lib/active_record/base.rb:1548:in `find_every'
/home/uxp/.rvm/gems/ruby-1.8.7-p249@rails2/gems/activerecord-2.3.5/lib/active_record/base.rb:1505:in `find_initial'
/home/uxp/.rvm/gems/ruby-1.8.7-p249@rails2/gems/activerecord-2.3.5/lib/active_record/base.rb:613:in `find'
/home/uxp/.rvm/gems/ruby-1.8.7-p249@rails2/gems/activerecord-2.3.5/lib/active_record/base.rb:1954:in `find_or_initialize_by_zipcode'
/home/uxp/Code/rails/pc-forecaster/app/models/weather.rb:9:in `fetch_for_zipcode'
/home/uxp/Code/rails/pc-forecaster/spec/models/weather_spec.rb:64:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment