taxonomy query issue on PostgreSQL

Created on 23 April 2015, almost 10 years ago
Updated 26 November 2024, 5 months ago

I have this exeption when I use the taxonomy module :

PDOException : SQLSTATE[42803]: Grouping error: 7 ERREUR: la colonne « t.tid » doit apparaître dans la clause GROUP BY ou doit être utilisé dans une fonction d'agrégat LINE 1: SELECT t.tid AS tid, t.name AS name, t.description AS descri... ^: SELECT t.tid AS tid, t.name AS name, t.description AS description, COUNT(i.nid) AS count FROM {taxonomy_index} i LEFT OUTER JOIN {taxonomy_term_data} t ON t.tid = i.tid GROUP BY i.tid ORDER BY count DESC LIMIT 12 OFFSET 0; Array ( ) dans tagadelic_taxonomy_tags_from_db() (ligne 90 dans /drupal/sites/all/modules/tagadelic/tagadelic_taxonomy.module).

I have to change ->groupBy("i.tid") by ->groupBy("t.tid") in tagadelic_taxonomy.module and it works for me :)

🐛 Bug report
Status

Closed: outdated

Version

2.0

Component

Code

Created by

🇫🇷France moumoul

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • 🇺🇦Ukraine AstonVictor

    I'm closing it because the issue was created a long time ago without any further steps.

    if you still need it then raise a new one.
    thanks

Production build 0.71.5 2024