* warning: pg_query() [function.pg-query]: Query failed: ERREUR: la colonne « u.name » doit apparaître dans la clause GROUP BY ou doit être utilisé dans une fonction d'agrégat in /home/html/test/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT COUNT(op.vc_op_id) AS count, op.uid, u.name FROM versioncontrol_operations op INNER JOIN users u ON op.uid = u.uid AND op.uid != 0 AND op.date > 1236334710 WHERE op.type = 1 GROUP BY op.uid ORDER BY count DESC LIMIT 15 OFFSET 0 in /home/html/test/sites/all/modules/versioncontrol/versioncontrol.module on line 3332.

Patch attached. Kind regards, JMP

CommentFileSizeAuthor
patch.diff632 bytesgrub3

Comments

jpetso’s picture

jpetso commented
Status: Reviewed & tested by the community » Fixed

Please don't post patches with initial "reviewed & tested by the community" status, that's reserved for patch reviews by someone other than the original patch creator.

That said:
1. Thanks a lot for the report, Postgres testing is appreciated!
2. Patch applied in commit #183430, marking this issue as fixed.

In case you find any more Postgres related problems, please do not hesitate to report those too. Thanks again! :)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

  • Commit 733e996 on 6.x-1.x, repository-families, drush-vc-sync-unlock by jpetso: 
    #400710 by jmpoure: Postgres compatibility (GROUP BY) for query in the "...

  • Commit 733e996 on 6.x-1.x, repository-families by jpetso: 
    #400710 by jmpoure: Postgres compatibility (GROUP BY) for query in the "...