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

nancydru’s picture

Status: Active » Fixed

Fix committed to 6.x-2.x-dev. You can also temporarily get by this by changing your sort order to "standard drupal".

mtnnomad’s picture

Thanks for the quick fix and reply. Everything seems to be working fine now.

Status: Fixed » Closed (fixed)

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