Jump to:
| 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
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
Automatically closed -- issue fixed for 2 weeks with no activity.