Postgres 8.3 error

mtnnomad - September 29, 2009 - 22:27
Project:Web Links
Version:6.x-2.3
Component:Miscellaneous
Category:support request
Priority:normal
Assigned:Unassigned
Status:closed
Description

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.

#1

NancyDru - September 30, 2009 - 03:37
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

mtnnomad - September 30, 2009 - 17:32

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

#3

System Message - October 14, 2009 - 17:40
Status:fixed» closed

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

 
 

Drupal is a registered trademark of Dries Buytaert.