* warning: pg_query(): Query failed: ERROR: syntax error at or near "WHERE" at character 49 in /home/brenda/projects/drupal/HEAD/includes/database.pgsql.inc on line 155.
* user warning: query: SELECT t.tid FROM term_node t INNER JOIN node n WHERE t.vid = n.vid AND n.nid = 0 ORDER BY t.vid DESC LIMIT 1 OFFSET 0 in /home/brenda/projects/drupal/HEAD/modules/forum/forum.module on line 254.

I've attached a path that adds the missing "ON" clause

SELECT t.tid FROM term_node t INNER JOIN node n WHERE t.vid = n.vid AND n.nid = 0 ORDER BY t.vid DESC LIMIT 1 OFFSET 0

becomes

SELECT t.tid FROM term_node t INNER JOIN node n ON t.vid = n.vid WHERE AND n.nid = 0 ORDER BY t.vid DESC LIMIT 1 OFFSET 0
CommentFileSizeAuthor
forum.module_23.patch979 bytesShiny
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

chx’s picture

chx CreditAttribution: chx commented
Title: postgresql errors on forum topic creation » missing on clause in forum_nodeapi
Priority: Normal » Critical
Status: Needs review » Reviewed & tested by the community
Gábor Hojtsy’s picture

Gábor Hojtsy
he/him
Primary language Hungarian
Location Hungary
CreditAttribution: Gábor Hojtsy commented
Status: Reviewed & tested by the community » Fixed

Well, the patch you submitted thankfully contained the correct code (unlike your explanation here, which has a copy-paste typo). So committed, thanks.

Anonymous’s picture

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