Notifica una Bug (Errors o Incidències)

Empremta digital

El text següent és una representació abreviada i hashejada d'aquest contingut. És útil per garantir que el contingut no hagi estat alterat, ja que una única modificació provocaria un valor totalment diferent.

Valor: 169db543f3ed67ebb0e7501b53018ded94174c6aabfe827810d9526670f4b5c9

Origen: {"body":"We have an application running Decidim 0.16.0, the task bundle exec rake decidim:metrics:one[\"results\"] generates the following error:\r\n\r\nActiveRecord::StatementInvalid: PG::GroupingError: ERROR: column \"decidim_accountability_results.id\" must appear in the GROUP BY clause or be used in an aggregate function\r\nLINE 1: ...ipatory_space_id\", decidim_components.id ORDER BY \"decidim_a...\r\n\r\nI'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).\r\n\r\nHere I've pasted both queries:\r\n\r\nhttps://gist.github.com/amiedes/8318f5728da87ab5b7bbf223fe0d0220\r\n\r\nI 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.","title":"Broken metrics task: results (wrong SQL query)"}

Aquesta empremta digital es calcula mitjançant un algoritme de hash SHA256. Per reproduir-lo tu mateix, pots utilitzar una Calculadora MD5 en línia i copiar-hi les dades d'origen. ×