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.

Comments

jeremy’s picture

Project: Database Administration » Drupal core
Version: 5.x-1.x-dev » 4.7.0-rc3
Component: PostgreSQL Support » postgresql database

Re-assigning this to the proper place -- it's unrelated to the dba.module which it was originally assigned to.

markus_petrux’s picture

Status: Active » Closed (duplicate)

Fixed by this:
http://drupal.org/node/58921

Here's the diff.