Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

ActionView::Template::Error: PG::InvalidTextRepresentation: ERROR: invalid input syntax for type integer: "'4'" LINE 1: ...pants"."position_id" WHERE (positions.holder_id = '''4''')))... ^ : SE #947

Open
voodoorai2000 opened this issue Jan 25, 2022 · 0 comments
Open

ActionView::Template::Error: PG::InvalidTextRepresentation: ERROR: invalid input syntax for type integer: "'4'" LINE 1: ...pants"."position_id" WHERE (positions.holder_id = '''4''')))... ^ : SE #947

voodoorai2000 opened this issue Jan 25, 2022 · 0 comments

Comments

@voodoorai2000
Copy link
Member

View details in Rollbar: https://rollbar.com/consul/Agendas/items/691/


PG::InvalidTextRepresentation: ERROR:  invalid input syntax for type integer: "'4'"
LINE 1: ...pants"."position_id" WHERE (positions.holder_id = '''4''')))...
                                                             ^

  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/postgresql_adapter.rb", line 592, in async_exec
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/postgresql_adapter.rb", line 592, in block in exec_no_cache
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract_adapter.rb", line 484, in block in log
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/notifications/instrumenter.rb", line 20, in instrument
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract_adapter.rb", line 478, in log
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/postgresql_adapter.rb", line 592, in exec_no_cache
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/postgresql_adapter.rb", line 584, in execute_and_clear
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/postgresql/database_statements.rb", line 160, in exec_query
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/database_statements.rb", line 356, in select
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/database_statements.rb", line 32, in select_all
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/query_cache.rb", line 68, in block in select_all
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/query_cache.rb", line 83, in cache_sql
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/query_cache.rb", line 68, in select_all
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/relation/calculations.rb", line 270, in execute_simple_calculation
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/relation/calculations.rb", line 227, in perform_calculation
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/relation/calculations.rb", line 133, in calculate
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/newrelic_rpm-3.13.2.302/lib/new_relic/agent/instrumentation/active_record_helper.rb", line 70, in block in calculate
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/newrelic_rpm-3.13.2.302/lib/new_relic/agent/transaction.rb", line 807, in with_database_metric_name
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/newrelic_rpm-3.13.2.302/lib/new_relic/agent.rb", line 572, in with_database_metric_name
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/newrelic_rpm-3.13.2.302/lib/new_relic/agent/instrumentation/active_record_helper.rb", line 69, in calculate
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/relation/calculations.rb", line 48, in count
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/relation.rb", line 258, in size
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/kaminari-core-1.0.1/lib/kaminari/helpers/helper_methods.rb", line 104, in page_entries_info
  File "/home/rubyruby/proyectos_trabajo/iam_agend/app/views/visitors/_list_composition.html.erb", line 2, in _app_views_visitors__list_composition_html_erb__1548113498025060447_47313286648200
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionview-4.2.11.3/lib/action_view/template.rb", line 145, in block in render
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 164, in block in instrument
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/notifications/instrumenter.rb", line 20, in instrument
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 164, in instrument
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionview-4.2.11.3/lib/action_view/template.rb", line 337, in instrument
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionview-4.2.11.3/lib/action_view/template.rb", line 143, in render
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionview-4.2.11.3/lib/action_view/renderer/partial_renderer.rb", line 339, in render_partial
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionview-4.2.11.3/lib/action_view/renderer/partial_renderer.rb", line 310, in block in render
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionview-4.2.11.3/lib/action_view/renderer/abstract_renderer.rb", line 39, in block in instrument
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 164, in block in instrument
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/notifications/instrumenter.rb", line 20, in instrument
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 164, in instrument
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionview-4.2.11.3/lib/action_view/renderer/abstract_renderer.rb", line 39, in instrument
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionview-4.2.11.3/lib/action_view/renderer/partial_renderer.rb", line 309, in render
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionview-4.2.11.3/lib/action_view/renderer/renderer.rb", line 51, in render_partial
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionview-4.2.11.3/lib/action_view/helpers/rendering_helper.rb", line 35, in render
  File "/home/rubyruby/proyectos_trabajo/iam_agend/app/views/visitors/_list_events.html.erb", line 15, in _app_views_visitors__list_events_html_erb__130418508888260951_47313269656360
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionview-4.2.11.3/lib/action_view/template.rb", line 145, in block in render
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 164, in block in instrument
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/notifications/instrumenter.rb", line 20, in instrument
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 164, in instru
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@voodoorai2000