I am working on setting up the Biblio module in a D6.13 setup but have little experience with PHP. The default biblio filter type is year, which works fine, however when attempting to filter by any means (Author, Type, etc...) two errors are returned. Below are the errors when filtering by Author.
warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /usr/local/apache2/htdocs/includes/database.pgsql.inc on line 139.
user warning: query: SELECT DISTINCT(n.nid), n.*, b.*, bt.name as biblio_type_name FROM (SELECT DISTINCT ON (nid) * FROM node) n left join biblio b on n.vid=b.vid inner join biblio_types bt on b.biblio_type=bt.tid INNER JOIN biblio_contributor as bc on b.vid = bc.vid JOIN biblio_contributor_data as bcd on bc.cid = bcd.cid WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( (bc.rank=0) AND (bc.auth_category=1) AND (n.type='biblio' ) AND (n.status = 1 ) )ORDER BY bcd.lastname desc LIMIT 50 OFFSET 0 in /usr/local/apache2/htdocs/sites/all/modules/biblio/biblio.pages.inc on line 87.
Any help decoding what this means / what I have to do is much appreciated. Thank you.
Comments
Comment #1
rjerome commentedThe PostgreSQL support is still a little dodgy, so unfortunately all bets are off right now. I just haven't had the time to thoroughly test it with PostgreSQL.
Comment #2
GarenCheckley commentedOK -- thanks for the reply.
Comment #3
liam morlandThis version is no longer maintained. If this issue is still relevant to the Drupal 7 version, please re-open and provide details.