Project:Web Links
Version:6.x-2.3
Component:Miscellaneous
Category:support request
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

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

#1

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".

#2

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

#3

Status:fixed» closed (fixed)

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

nobody click here