Error on pgsql 8.3.x possible Syntax change issue
spydmobile - November 7, 2008 - 22:58
| Project: | autocategorise |
| Version: | 6.x-1.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
I think you need to update the code to be compliant with new SQL syntax in postgres after 8.3
here is an error when you save a autocategorise enabled node:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "`" LINE 1: SELECT v.vid FROM `vocabulary_node_types` AS t LEFT JOIN voc... ^ in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\SPARCS\includes\database.pgsql.inc on line 138.
* user warning: query: SELECT v.vid FROM `vocabulary_node_types` AS t LEFT JOIN vocabulary AS v ON t.vid = v.vid WHERE t.type='var' in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\SPARCS\sites\all\modules\autocategorise\auto_categorise.module on line 66.Hope this help, I might like to use this module in my PG Drupal some day!
#1
Thanks I've removed the backticks and committed the change
#2