Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I get the following single error both when I enter a new weblink and multiple similar errors when I view the Links page in Site Configuration:
# warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /var/www/includes/database.pgsql.inc on line 139.
# user warning: query: SELECT DISTINCT(n.nid), n.title FROM node n INNER JOIN weblinks bw ON n.vid = bw.vid INNER JOIN term_node tn ON tn.nid=n.nid AND tn.vid=n.vid WHERE n.status = 1 AND tn.tid IN (7) ORDER BY n.sticky DESC, n.title ASC in /var/www/modules/weblinks/weblinks.module on line 1173.
The link is created fine, but there must be something wrong - my lack of understanding of databases leaves me at a loss as to how to solve this issue. Any assistance would be appreciated.
Comments
Comment #1
nancydruFix committed to 6.x-2.x-dev. You can also temporarily get by this by changing your sort order to "standard drupal".
Comment #2
mtnnomad commentedThanks for the quick fix and reply. Everything seems to be working fine now.