After enabling a block for random quotes, the following error occurred:

* warning: pg_query(): Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /srv/www/web10/web/portal/includes/database.pgsql.inc on line 138.
* user warning: query: SELECT DISTINCT(n.nid) FROM quotes q INNER JOIN (SELECT DISTINCT ON (nid) * FROM node) n USING(vid) WHERE n.status=1 AND n.type='quotes' AND q.promote = 1 AND 1=1 ORDER BY RAND() LIMIT 1 OFFSET 0 in /srv/www/web10/web/portal/modules/quotes/quotes.module on line 1019.

Drupal 6.4
PostgreSQL 8.1.11
Quotes 6.x-1.1

Comments

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Assigned: Unassigned » nancydru
Status: Active » Postponed (maintainer needs more info)

I made a small change that probably won't fix this. I am sorry that I don't know Postgres. But I would love to have someone who could help get it all right.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

No comments in over a week. Reopen this if you come back to this issue.