When I enabled the module I recieved the following message on my frontpage:
pg_query() [function.pg-query]: Query failed: ERROR: column "d.vid" must appear in the GROUP BY clause or be used in an aggregate function in /htdocs/includes/database.pgsql.inc on line 84.
query: SELECT t.tid, d.vid, BIT_OR(t.grant_list) AS grant_list FROM term_access t INNER JOIN term_data d ON t.tid=d.tid WHERE t.rid in ('1') AND grant_list = 1 group by t.tid in /htdocs/includes/database.pgsql.inc on line 103.

The attached patch seems to fix this problem.

CommentFileSizeAuthor
taxonomy_access.module.diff738 byteswedge

Comments

keve’s picture

keve commented
Status: Active » Needs review

Thanks for the patch. i will commit after checking.

keve’s picture

keve commented
Status: Needs review » Fixed

Commited.

TheFazz’s picture

TheFazz commented
Title: SQL query error on postgresql » SQL query error on mysql

I just upgraded to 4.7.0r3 from Civicspace 0.8.2

am using taxonomy access control 4.7.0. on mySQL 4.1.18 database. using phpmyadmin to update SQL. I keep getting this message:

Unknown column 't.grant_list' in 'field list' query: SELECT t.tid, d.vid, BIT_OR(t.grant_list) AS grant_list FROM term_access t INNER JOIN term_data d ON t.tid=d.tid WHERE t.rid in ('1') AND grant_list = 1 group by t.tid, d.vid in /home/thefazz/public_html/me/includes/database.mysql.inc on line 120.

appreciate any help here. thanks in advance.

fazz

keve’s picture

keve commented
Title: SQL query error on mysql » SQL query error on postgresql

Please do not change title, but submit a new bug report for each issue.

Please read update.txt. You have to update your database.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)