Skip to content
This repository has been archived by the owner on Aug 29, 2023. It is now read-only.

ActionView::Template::Error: Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '3 & DESC LIMIT 10 OFFSET 0' at line 1: SELECT templates.id AS t0_r0, #322

Open
ualbertalib-bot opened this issue Oct 17, 2020 · 0 comments
Open

ActionView::Template::Error: Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '3 & DESC LIMIT 10 OFFSET 0' at line 1: SELECT templates.id AS t0_r0, #322

ualbertalib-bot opened this issue Oct 17, 2020 · 0 comments

Comments

@ualbertalib-bot
Copy link

View details in Rollbar: https://rollbar.com/ualbertalib/DMPonline_v4/items/125/


Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '3 & DESC LIMIT 10 OFFSET 0' at line 1
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/mysql2-0.4.10/lib/mysql2/client.rb", line 120, in _query
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/mysql2-0.4.10/lib/mysql2/client.rb", line 120, in block in query
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/mysql2-0.4.10/lib/mysql2/client.rb", line 119, in handle_interrupt
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/mysql2-0.4.10/lib/mysql2/client.rb", line 119, in query
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb", line 317, in block in execute
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract_adapter.rb", line 484, in block in log
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activesupport-4.2.11.3/lib/active_support/notifications/instrumenter.rb", line 20, in instrument
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract_adapter.rb", line 478, in log
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb", line 317, in execute
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/mysql2_adapter.rb", line 217, in execute
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/mysql2_adapter.rb", line 221, in exec_query
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/database_statements.rb", line 356, in select
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/database_statements.rb", line 32, in select_all
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/query_cache.rb", line 68, in block in select_all
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/query_cache.rb", line 83, in cache_sql
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/connection_adapters/abstract/query_cache.rb", line 68, in select_all
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/relation/finder_methods.rb", line 356, in find_with_associations
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/relation.rb", line 639, in exec_queries
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/relation.rb", line 515, in load
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/relation.rb", line 243, in to_a
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activerecord-4.2.11.3/lib/active_record/relation/delegation.rb", line 46, in each
  File "/var/www/sites/dmp/app/views/paginable/templates/_publicly_visible.html.erb", line 19, in _app_views_paginable_templates__publicly_visible_html_erb___1444873367671481692_69993679800100
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionview-4.2.11.3/lib/action_view/template.rb", line 145, in block in render
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 166, in instrument
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionview-4.2.11.3/lib/action_view/template.rb", line 337, in instrument
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionview-4.2.11.3/lib/action_view/template.rb", line 143, in render
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionview-4.2.11.3/lib/action_view/renderer/partial_renderer.rb", line 339, in render_partial
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionview-4.2.11.3/lib/action_view/renderer/partial_renderer.rb", line 310, in block in render
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionview-4.2.11.3/lib/action_view/renderer/abstract_renderer.rb", line 39, in block in instrument
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 164, in block in instrument
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activesupport-4.2.11.3/lib/active_support/notifications/instrumenter.rb", line 20, in instrument
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activesupport-4.2.11.3/lib/active_support/notifications.rb", line 164, in instrument
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionview-4.2.11.3/lib/action_view/renderer/abstract_renderer.rb", line 39, in instrument
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionview-4.2.11.3/lib/action_view/renderer/partial_renderer.rb", line 309, in render
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionview-4.2.11.3/lib/action_view/renderer/renderer.rb", line 51, in render_partial
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionview-4.2.11.3/lib/action_view/renderer/renderer.rb", line 25, in render
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionview-4.2.11.3/lib/action_view/rendering.rb", line 100, in _render_template
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionpack-4.2.11.3/lib/action_controller/metal/streaming.rb", line 217, in _render_template
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionview-4.2.11.3/lib/action_view/rendering.rb", line 83, in render_to_body
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionpack-4.2.11.3/lib/action_controller/metal/rendering.rb", line 32, in render_to_body
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionpack-4.2.11.3/lib/action_controller/metal/renderers.rb", line 37, in render_to_body
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionpack-4.2.11.3/lib/abstract_controller/rendering.rb", line 25, in render
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionpack-4.2.11.3/lib/action_controller/metal/rendering.rb", line 16, in render
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionpack-4.2.11.3/lib/action_controller/metal/instrumentation.rb", line 44, in block (2 levels) in render
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activesupport-4.2.11.3/lib/active_support/core_ext/benchmark.rb", line 12, in block in ms
  File "/usr/lib64/ruby/2.5.0/benchmark.rb", line 308, in realtime
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/activesupport-4.2.11.3/lib/active_support/core_ext/benchmark.rb", line 12, in ms
  File "/var/www/sites/dmp/vendor/ruby/2.5.0/gems/actionpack-4.2.11.3/lib/action_controller/metal/instrument
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@ualbertalib-bot