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 integer: "188'A=0" LINE 1: ...."id" = "positions"."holder_id" WHERE (holders.id='188''A=0'... ^ : SEL #940

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

ActionView::Template::Error: PG::InvalidTextRepresentation: ERROR: invalid input syntax for integer: "188'A=0" LINE 1: ...."id" = "positions"."holder_id" WHERE (holders.id='188''A=0'... ^ : SEL #940

voodoorai2000 opened this issue Jan 20, 2022 · 0 comments

Comments

@voodoorai2000
Copy link
Contributor

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


PG::InvalidTextRepresentation: ERROR:  invalid input syntax for integer: "188'A=0"
LINE 1: ...."id" = "positions"."holder_id" WHERE (holders.id='188''A=0'...
                                                             ^

  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/postgresql_adapter.rb", line 592, in async_exec
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/postgresql_adapter.rb", line 592, in block in exec_no_cache
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract_adapter.rb", line 484, in block in log
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activesupport-4.2.11.3/lib/active_support/notifications/instrumenter.rb", line 20, in instrument
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract_adapter.rb", line 478, in log
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/postgresql_adapter.rb", line 592, in exec_no_cache
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/postgresql_adapter.rb", line 584, in execute_and_clear
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/postgresql/database_statements.rb", line 160, in exec_query
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/database_statements.rb", line 356, in select
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/database_statements.rb", line 32, in select_all
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/query_cache.rb", line 68, in block in select_all
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/query_cache.rb", line 83, in cache_sql
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/query_cache.rb", line 68, in select_all
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/relation/calculations.rb", line 270, in execute_simple_calculation
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/relation/calculations.rb", line 227, in perform_calculation
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/relation/calculations.rb", line 133, in calculate
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/newrelic_rpm-3.13.2.302/lib/new_relic/agent/instrumentation/active_record_helper.rb", line 70, in block in calculate
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/newrelic_rpm-3.13.2.302/lib/new_relic/agent/transaction.rb", line 807, in with_database_metric_name
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/newrelic_rpm-3.13.2.302/lib/new_relic/agent.rb", line 572, in with_database_metric_name
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/newrelic_rpm-3.13.2.302/lib/new_relic/agent/instrumentation/active_record_helper.rb", line 69, in calculate
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/relation/calculations.rb", line 48, in count
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activerecord-4.2.11.3/lib/active_record/relation.rb", line 258, in size
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/kaminari-core-1.0.1/lib/kaminari/helpers/helper_methods.rb", line 104, in page_entries_info
  File "/aytomad/app/agendas/agendas/releases/20220102191712/app/views/visitors/index.html.erb", line 35, in _app_views_visitors_index_html_erb___2827345239816145588_65673060
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/actionview-4.2.11.3/lib/action_view/template.rb", line 145, in block in render
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 164, in block in instrument
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activesupport-4.2.11.3/lib/active_support/notifications/instrumenter.rb", line 20, in instrument
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 164, in instrument
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/actionview-4.2.11.3/lib/action_view/template.rb", line 337, in instrument
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/actionview-4.2.11.3/lib/action_view/template.rb", line 143, in render
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/actionview-4.2.11.3/lib/action_view/renderer/template_renderer.rb", line 54, in block (2 levels) in render_template
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/actionview-4.2.11.3/lib/action_view/renderer/abstract_renderer.rb", line 39, in block in instrument
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 164, in block in instrument
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activesupport-4.2.11.3/lib/active_support/notifications/instrumenter.rb", line 20, in instrument
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 164, in instrument
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/actionview-4.2.11.3/lib/action_view/renderer/abstract_renderer.rb", line 39, in instrument
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/actionview-4.2.11.3/lib/action_view/renderer/template_renderer.rb", line 53, in block in render_template
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/actionview-4.2.11.3/lib/action_view/renderer/template_renderer.rb", line 61, in render_with_layout
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/actionview-4.2.11.3/lib/action_view/renderer/template_renderer.rb", line 52, in render_template
  File "/aytomad/app/agendas/agendas/shared/bundle/ruby/2.3.0/gems/actionview-4.2.11.3/lib/action_view/renderer/template_renderer.rb", line 14, in
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