Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By rbroberts on
I'm a newbie with Drupal (4.7RC3) but have been using php and postgres for a long time. My first page creation gave me this:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: column "c.status" must appear in the GROUP BY clause or be used in an aggregate function in /var/www/cms.astrofoto.org/html/includes/database.pgsql.inc on line 84.
* user warning: query: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.picture, u.data, c.score, c.users, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 1 GROUP BY c.cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, u.picture, c.homepage, u.uid, u.name, u.picture, u.data, c.score, c.users, c.thread ORDER BY c.thread DESC LIMIT 50 OFFSET 0 in /var/www/cms.astrofoto.org/html/includes/database.pgsql.inc on line 103.
The error appears to be in modules/comment.module at line 755 which, as the error says, just needs c.status added to the group by clause.
Is this the appropriate place to post patches/diffs?
roland
Comments
pgsql missing group by column
I posted this in the issues at http://drupal.org/node/60320 and it has been fixed in CVS.