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

rbroberts’s picture

I posted this in the issues at http://drupal.org/node/60320 and it has been fixed in CVS.