i am using drupal & taxonomy access of 4.7 and postgres. at first the installation causes error as no sql files embed with the module, so i downloaded the 4.6 version and uses the taxonomy_access.pgsql instead. Below are the errors as i log out.

* warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: "" in public_html/drupal/includes/database.pgsql.inc on line 84.
* user warning: query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE (t.tid IN ('')) AND r.nid = 3 ORDER BY v.weight, t.weight, t.name in public_html/drupal/includes/database.pgsql.inc on line 103.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: "" in public_html/drupal/includes/database.pgsql.inc on line 84.
* user warning: query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE (t.tid IN ('')) AND r.nid = 4 ORDER BY v.weight, t.weight, t.name in public_html/drupal/includes/database.pgsql.inc on line 103.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: "" in public_html/drupal/includes/database.pgsql.inc on line 84.
* user warning: query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE (t.tid IN ('')) AND r.nid = 2 ORDER BY v.weight, t.weight, t.name in public_html/drupal/includes/database.pgsql.inc on line 103.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: "" in public_html/drupal/includes/database.pgsql.inc on line 84.
* user warning: query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE (t.tid IN ('')) AND r.nid = 5 ORDER BY v.weight, t.weight, t.name in public_html/drupal/includes/database.pgsql.inc on line 103.

anyone having the same problem using postgres? got any idea how to fix the problem?

CommentFileSizeAuthor
#1 taxonomy_access.module.cvs42.13 KBkeve

Comments

keve’s picture

StatusFileSize
new42.13 KB

Try it with this module. (rename it to taxonomy_access.module)
Does it solve your problem?

keve’s picture

Status: Active » Closed (duplicate)