When I click on author/type there are error messages ( I use PostgreSQL)

PDOException: SQLSTATE[42803]: Grouping error: 7 ERROR: column "ctd.title" must appear in the GROUP BY clause or be used in an aggregate function: SELECT ctd.*, cid FROM {biblio_contributor_type_data} ctd LEFT JOIN {biblio_contributor} c ON ctd.auth_type = c.auth_type GROUP BY ctd.auth_type; Array ( ) in theme_biblio_admin_author_types_form() (line 1628 of

Comments

rjerome’s picture

rjerome commented
Status: Active » Fixed

fixed.

http://drupalcode.org/project/biblio.git/commit/9d86565

wa2nlinux’s picture

wa2nlinux commented
Status: Fixed » Active

still error different line (using 7.x-1.x-dev 10 July

PDOException: SQLSTATE[42803]: Grouping error: 7 ERROR: column "ctd.title" must appear in the GROUP BY clause or be used in an aggregate function: SELECT ctd.auth_type, ctd.title, ctd.hint, c.cid FROM {biblio_contributor_type_data} ctd LEFT JOIN {biblio_contributor} c ON ctd.auth_type = c.auth_type GROUP BY ctd.auth_type; Array ( ) in theme_biblio_admin_author_types_form() (line 1675 of /home/ie/drupal-7.4/sites/all/modules/biblio/includes/biblio.admin.inc).
rjerome’s picture

rjerome commented
Status: Active » Needs review

OK, my bad.

This time I re-wrote it to use a dynamic query which should be PostgreSQL compatible.

http://drupalcode.org/project/biblio.git/commit/0efca5a

Ron.

wa2nlinux’s picture

wa2nlinux commented

still got error different line (using 7.x-1.x-dev 12 July

PDOException: SQLSTATE[42803]: Grouping error: 7 ERROR: column "ctd.title" must appear in the GROUP BY clause or be used in an aggregate function: SELECT ctd.auth_type, ctd.title, ctd.hint, c.cid FROM {biblio_contributor_type_data} ctd LEFT JOIN {biblio_contributor} c ON ctd.auth_type = c.auth_type GROUP BY ctd.auth_type; Array ( ) in theme_biblio_admin_author_types_form() (line 1674 of /home/drupal-7.4/sites/all/modules/biblio/includes/biblio.admin.inc).
rjerome’s picture

rjerome commented

I just checked and the current -dev package doesn't have the changes in it yet, there should be another one built within the next twelve hours that does.

ar-jan’s picture

ar-jan commented
Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

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