When clicking on the Sent Messages link in the Private Messages block I get the following errors ...

* warning: pg_query() [function.pg-query]: Query failed: ERROR: column "pm.subject" must appear in the GROUP BY clause or be used in an aggregate function in /var/www/testd.msc.org.nz/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT pmi.thread_id, pm.subject, MAX(pm.timestamp) as timestamp FROM pm_message pm INNER JOIN pm_index pmi ON pm.mid = pmi.mid WHERE (pmi.uid = 1) AND (pm.author = 1) AND (pmi.deleted = 0) GROUP BY pmi.thread_id ORDER BY timestamp desc LIMIT 25 OFFSET 0 in /var/www/testd.msc.org.nz/sites/default/modules/privatemsg/privatemsg.module on line 274.

Still learning about PHP and drupal development, so I'm having trouble working out where the error is :-(

Comments

ibeardslee’s picture

The 6.x-1.x-dev version of 2008-Dec-24 is exhibiting the same symptoms

berdir’s picture

Status: Active » Needs review
StatusFileSize
new669 bytes

Try the attached patch, does work for me...

Forgot that page when I added PostgreSQL support to HEAD...

ibeardslee’s picture

Oarsum .. thanks for that, tested it on the 6.x-1.x-dev version and it worked a treat. Good to see more modules supporting PostgreSQL.

berdir’s picture

StatusFileSize
new669 bytes

Seems that one of my patch introduced an additional issue with pgsql. Forgot to check that..

Patch re-rolled and timestamp issue fixed.

berdir’s picture

StatusFileSize
new1.32 KB

Wrong patch..

litwol’s picture

Status: Needs review » Fixed

Its in.
thanks :)

Status: Fixed » Closed (fixed)

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