Vés al contingut principal

Configuració de les galetes

Fem servir galetes per assegurar les funcionalitats bàsiques del lloc web i per a millorar la teva experiència en línia. Pots configurar i acceptar l'ús de galetes, i modificar les teves opcions de consentiment en qualsevol moment.

Essencials

Preferències

Analítiques i estadístiques

Màrqueting

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: Participant eliminada Participant eliminada 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.
Comentari

Confirmar

Si us plau, inicia la sessió

La contrasenya és massa curta.

Compartir