Saltar al contenido principal

Configuración de cookies

Utilizamos cookies para asegurar las funcionalidades básicas del sitio web y para mejorar tu experiencia en línea. Puedes configurar y aceptar el uso de las cookies, y modificar tus opciones de consentimiento en cualquier momento.

Esenciales

Preferencias

Analíticas y estadísticas

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: Participante eliminada Participante 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.
Comentario

Confirmar

Por favor, inicia la sesión

La contraseña es demasiado corta.

Compartir