Skip to main content
Information about the cookies used on the website

We use cookies on our website to improve the performance and content of the site. The cookies enable us to provide a more individual user experience and social media channels.

This proposal has been implemented

This incidence has been solved. Closed via #4979(External link).

Thank you for contributing!

Broken metrics task: results (wrong SQL query)

Finished
Avatar: Deleted participant Deleted participant
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(External link) 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.
Comment