Skip to main content

Cookie settings

We use cookies to ensure the basic functionalities of the website and to enhance your online experience. You can choose for each category to opt-in/out whenever you want.

Essential

Preferences

Analytics and statistics

Marketing

This proposal has been implemented

This incidence has been solved. Closed via #4979.

Thank you for contributing!

Broken metrics task: results (wrong SQL query)

Avatar: Deleted participant Deleted participant Finished
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.
Comment

Confirm

Please log in

The password is too short.

Share