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

ActiveRecord::StatementInvalid: PG::InvalidTextRepresentation: ERROR: invalid input syntax for type integer: "'3'" LINE 1: ...cipants"."position_id" WHERE (positions.holder_id = '''3''') ^ : #948

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

ActiveRecord::StatementInvalid: PG::InvalidTextRepresentation: ERROR: invalid input syntax for type integer: "'3'" LINE 1: ...cipants"."position_id" WHERE (positions.holder_id = '''3''') ^ : #948

voodoorai2000 opened this issue Jan 25, 2022 · 0 comments

Comments

@voodoorai2000
Copy link
Member

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


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

  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/querying.rb", line 39, in find_by_sql
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/relation.rb", line 639, in exec_queries
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/relation.rb", line 515, in load
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/relation.rb", line 243, in to_a
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/relation/delegation.rb", line 46, in to_ary
  File "/home/rubyruby/proyectos_trabajo/iam_agend/app/controllers/visitors_controller.rb", line 192, in puts
  File "/home/rubyruby/proyectos_trabajo/iam_agend/app/controllers/visitors_controller.rb", line 192, in puts
  File "/home/rubyruby/proyectos_trabajo/iam_agend/app/controllers/visitors_controller.rb", line 192, in get_events_array
  File "/home/rubyruby/proyectos_trabajo/iam_agend/app/controllers/visitors_controller.rb", line 17, in index
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/action_controller/metal/implicit_render.rb", line 4, in send_action
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/abstract_controller/base.rb", line 198, in process_action
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/action_controller/metal/rendering.rb", line 10, in process_action
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/abstract_controller/callbacks.rb", line 20, in block in process_action
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/callbacks.rb", line 117, in call
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/callbacks.rb", line 555, in block (2 levels) in compile
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/callbacks.rb", line 505, in call
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/callbacks.rb", line 92, in __run_callbacks__
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/callbacks.rb", line 778, in _run_process_action_callbacks
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activesupport-4.2.11.3/lib/active_support/callbacks.rb", line 81, in run_callbacks
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/abstract_controller/callbacks.rb", line 19, in process_action
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/action_controller/metal/rescue.rb", line 29, in process_action
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/action_controller/metal/instrumentation.rb", line 32, in block in process_action
  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/actionpack-4.2.11.3/lib/action_controller/metal/instrumentation.rb", line 30, in process_action
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/action_controller/metal/params_wrapper.rb", line 250, in process_action
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/activerecord-4.2.11.3/lib/active_record/railties/controller_runtime.rb", line 18, in process_action
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/abstract_controller/base.rb", line 137, in process
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionview-4.2.11.3/lib/action_view/rendering.rb", line 30, in process
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/action_controller/metal.rb", line 196, in dispatch
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/action_controller/metal/rack_delegation.rb", line 13, in dispatch
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/action_controller/metal.rb", line 237, in block in action
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2.11.3/lib/action_dispatch/routing/route_set.rb", line 74, in dispatch
  File "/home/rubyruby/.rvm/gems/ruby-2.3.5/gems/actionpack-4.2
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