Skip to content

Instantly share code, notes, and snippets.

@shingara
Created September 3, 2008 14:03
Show Gist options
  • Save shingara/8589 to your computer and use it in GitHub Desktop.
Save shingara/8589 to your computer and use it in GitHub Desktop.
error in Typo 5.1.3
Processing ContentController#index (for 91.121.27.96 at 2008-09-03 12:50:07) [GET]
Session ID: 206ca70bb763c4cbbe25d61edfacf954
Parameters: {"search"=>{"category"=>"5", "published"=>"0", "published_at"=>"", "user_id"=>""}, "action"=>"index", "controller"=>"admin/content"}
ActiveRecord::StatementInvalid (PGError: ERROR: operator does not exist: boolean = integer
LINE 1: ...(state in('published', 'withdrawn') AND published = 0 AND ca...
^
HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts.
: SELECT count(DISTINCT contents.id) AS count_all FROM contents LEFT OUTER JOIN categorizations ON categorizations.article_id = contents.id WHERE (state in('published', 'withdrawn') AND published = 0 AND categorizations.category_id = 5) AND ( (contents."type" = 'Article' ) ) ):
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:151:in `log'
/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:407:in `execute'
/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:782:in `select_raw'
/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:769:in `select'
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:53:in `select_all'
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:74:in `cache_sql'
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:53:in `select_all'
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in `select_one'
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:19:in `select_value'
/vendor/rails/activerecord/lib/active_record/calculations.rb:209:in `execute_simple_calculation'
/vendor/rails/activerecord/lib/active_record/calculations.rb:123:in `calculate'
/vendor/rails/activerecord/lib/active_record/calculations.rb:119:in `catch'
/vendor/rails/activerecord/lib/active_record/calculations.rb:119:in `calculate'
/vendor/rails/activerecord/lib/active_record/calculations.rb:46:in `count'
/app/controllers/admin/content_controller.rb:44:in `index'
/vendor/rails/actionpack/lib/action_controller/base.rb:1159:in `send'
/vendor/rails/actionpack/lib/action_controller/base.rb:1159:in `perform_action_without_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:699:in `call_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:727:in `run_before_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:666:in `call'
/vendor/rails/actionpack/lib/action_controller/filters.rb:666:in `proxy_before_and_after_filter'
/vendor/rails/actionpack/lib/action_controller/filters.rb:483:in `call'
/vendor/rails/actionpack/lib/action_controller/filters.rb:483:in `call'
/vendor/rails/actionpack/lib/action_controller/filters.rb:724:in `run_before_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:697:in `call_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:691:in `perform_action_without_benchmark'
/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/vendor/rails/actionpack/lib/action_controller/rescue.rb:199:in `perform_action_without_caching'
/vendor/rails/actionpack/lib/action_controller/caching.rb:678:in `perform_action'
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:33:in `cache'
/vendor/rails/activerecord/lib/active_record/query_cache.rb:8:in `cache'
/vendor/rails/actionpack/lib/action_controller/caching.rb:677:in `perform_action'
/vendor/rails/actionpack/lib/action_controller/base.rb:524:in `send'
/vendor/rails/actionpack/lib/action_controller/base.rb:524:in `process_without_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:687:in `process_without_session_management_support'
/vendor/rails/actionpack/lib/action_controller/session_management.rb:123:in `process'
/vendor/rails/actionpack/lib/action_controller/base.rb:388:in `process'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:171:in `handle_request'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:115:in `dispatch'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:126:in `dispatch_cgi'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:9:in `dispatch'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel/rails.rb:76:in `process'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel/rails.rb:74:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel/rails.rb:74:in `process'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:159:in `process_client'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:158:in `each'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:158:in `process_client'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:285:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:285:in `initialize'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:285:in `new'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:285:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:268:in `initialize'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:268:in `new'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:268:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel/configurator.rb:282:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel/configurator.rb:281:in `each'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel/configurator.rb:281:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/mongrel_rails:128:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel/command.rb:212:in `run'
/usr/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/mongrel_rails:281
/usr/bin/mongrel_rails:19:in `load'
/usr/bin/mongrel_rails:19
Rendering /var/rails/blog-typo/releases/20080901161519/public/500.html (500 Internal Server Error)
=> http://blog.shingara.fr/admin/content?search[category]=5&search[published_at]=&search[user_id]=&search[published]=0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment