When i click the Recent posts, it shows this error:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "ON" at character 24 in /var/www/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT COUNT( DISTINCT ON (n.nid) n.nid) FROM node n INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( n.status = 1) in /var/www/includes/database.pgsql.inc on line 144.

It didn't show this error before, but suddenly when i tried it now, it was there.

I noticed it only after installing gallery2 + gallery module, i don't know if that affected it.

I'm using drupal version 5.1 running on apache2, php5.1.6, using postgresql, on an ubuntu edgy machine. with 24MB limit in the php.ini

Comments

dpearcefl’s picture

dpearcefl commented
Status: Active » Closed (won't fix)

Considering the age of this issue with no comments and that Drupal 5 is no longer supported, I'm closing this ticket.