We have an application running Decidim 0.16.0, the task bundle exec rake decidim:metrics:one["results"] generates the following error:
ActiveRecord::StatementInvalid: PG::GroupingError: ERROR: column "decidim_accountability_results.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...ipatory_space_id", decidim_components.id ORDER BY "decidim_a...
I've been unable to replicate this in the development_app (there it does not happen). The closest I've get is pointing our application and the development_app both to a cloned Decidim repo on 0.16 and comparing the generated SQL queries (they differ in some points).
Here I've pasted both queries:
https://gist.github.com/amiedes/8318f5728da87ab5b7bbf223fe0d0220
I suspect of the extra ORDER BY "decidim_accountability_results"."id" ASC present in the erroneous query, but I can't guess where it comes from.
Share