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 :-(
| Comment | File | Size | Author |
|---|---|---|---|
| #5 | privatemsg.pgsql_fixes.patch | 1.32 KB | berdir |
| #4 | privatemsg.sent_pgsql_fix.patch | 669 bytes | berdir |
| #2 | privatemsg.sent_pgsql_fix.patch | 669 bytes | berdir |
Comments
Comment #1
ibeardslee commentedThe 6.x-1.x-dev version of 2008-Dec-24 is exhibiting the same symptoms
Comment #2
berdirTry the attached patch, does work for me...
Forgot that page when I added PostgreSQL support to HEAD...
Comment #3
ibeardslee commentedOarsum .. 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.
Comment #4
berdirSeems that one of my patch introduced an additional issue with pgsql. Forgot to check that..
Patch re-rolled and timestamp issue fixed.
Comment #5
berdirWrong patch..
Comment #6
litwol commentedIts in.
thanks :)