When updating a node on a PostgreSQL-based Drupal site with Link Intelligence, the following warnings are generated:
warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "linkintel_keyword" LINE 2: INSERT linkintel_keyword ^ in /home/friendsofqola/public_html/includes/database.pgsql.inc on line 138.
user warning: query: INSERT linkintel_keyword (keyword, keyword_stem, word_count) VALUES ('welcome', '', 1) in /home/friendsofqola/public_html/sites/all/modules/linkintel/linkintel.module on line 826.
The problem is that in PostgreSQL, the INTO keyword is not optional (unlike MySqL). Patch follows.
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | Fix_missing_INTO_keyword-1335794-1.patch | 738 bytes | ben coleman |
Comments
Comment #1
ben coleman commentedThis patch fixes the above problem.