Any idea why I am getting this error, looks like the query where clause is
missing an attribute.
ActiveRecord::StatementInvalid (Mysql::Error: You have an error in your SQL
syntax; check the manual that corresponds to yo
ur MySQL server version for the right syntax to use near
':suspended_at=>nil}) GROUP BY tags.id, tags.name HAVING COUNT(*)
> 0 ORDER BY c' at line 1: SELECT tags.id, tags.name, COUNT(*) AS count
FROM `tags` INNER JOIN taggings ON tags.id = tagg
ings.tag_id INNER JOIN projects ON projects.id = taggings.taggable_id WHERE
(taggings.taggable_type = 'Project' AND {:suspe
nded_at=>nil}) GROUP BY tags.id, tags.name HAVING COUNT(*) > 0 ORDER BY
count desc LIMIT 10):
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in
`rescue in log'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:202:in
`log'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:323:in
`execute'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:608:in
`select'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in
`select_all'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in
`block in select_all_with_q
uery_cache'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in
`cache_sql'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in
`select_all_with_query_cach
e'
vendor/rails/activerecord/lib/active_record/base.rb:661:in `find_by_sql'
vendor/rails/activerecord/lib/active_record/base.rb:1548:in `find_every'
vendor/rails/activerecord/lib/active_record/base.rb:615:in `find'
vendor/plugins/acts_as_taggable_on_steroids/lib/acts_as_taggable.rb:114:in
`tag_counts'
app/models/project.rb:133:in `top_tags'
app/controllers/projects_controller.rb:43:in `block (2 levels) in index'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:135:in
`call'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:135:in
`block in custom'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:179:in
`call'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:179:in
`block in respond'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:173:in
`each'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:173:in
`respond'
vendor/rails/actionpack/lib/action_controller/mime_responds.rb:107:in
`respond_to'
app/controllers/projects_controller.rb:40:in `index'
vendor/rails/actionpack/lib/action_controller/base.rb:1331:in
`perform_action'
vendor/rails/actionpack/lib/action_controller/filters.rb:617:in
`call_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:610:in
`perform_action_with_filters'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `block
in perform_action_with_benchmark'
vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in
`block in ms'
/opt/ruby192/lib/ruby/1.9.1/benchmark.rb:309:in `realtime'
vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in
`ms'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in
`perform_action_with_benchmark'
vendor/rails/actionpack/lib/action_controller/rescue.rb:160:in
`perform_action_with_rescue'
vendor/rails/actionpack/lib/action_controller/flash.rb:146:in
`perform_action_with_flash'
vendor/rails/actionpack/lib/action_controller/base.rb:532:in `process'
vendor/rails/actionpack/lib/action_controller/filters.rb:606:in
`process_with_filters'
vendor/rails/actionpack/lib/action_controller/base.rb:391:in `process'
vendor/rails/actionpack/lib/action_controller/base.rb:386:in `call'
vendor/rails/actionpack/lib/action_controller/routing/route_set.rb:437:in
`call'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:87:in
`dispatch'
--
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
