search

bap14 / redmine_category_tree

Module for Redmine to allow categories to be a tree instead of a single-list
18 stars 21 forks source link

PG::Error: ERROR: column "issue_categories.id" must appear in the GROUP BY clause or be used in an aggregate function #2

Closed missedone closed 11 years ago

missedone commented 11 years ago

hi,

I setup the redmine instance with PostgreSQL, when i migrated to install this plugin, i got the error below:

PG::Error: ERROR:  column "issue_categories.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT "issue_categories".* FROM "issue_categories"  WHERE "...
               ^
: SELECT "issue_categories".* FROM "issue_categories"  WHERE "issue_categories"."parent_id" IS NULL GROUP BY project_id ORDER BY "lft"
/var/lib/gems/1.9.1/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:1161:in `async_exec'
/var/lib/gems/1.9.1/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:1161:in `exec_no_cache'
/var/lib/gems/1.9.1/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:660:in `block in exec_query'
/var/lib/gems/1.9.1/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `block in log'
/var/lib/gems/1.9.1/gems/activesupport-3.2.13/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
missedone commented 11 years ago

thanks, the fix works