* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near ")" at character 113 in /websites/current/includes/database.pgsql.inc on line 126.
* user warning: query: INSERT INTO xmlsitemap_term (tid, pid, last_changed, priority_override) VALUES (31, 409, 1226059385, ) in /websites/current/includes/database.pgsql.inc on line 145.

I get the above error when one of my authors adds a term. I simply check to see if it is !empty. versus isset. Everything is fine.

CommentFileSizeAuthor
xmlsitemap_term.module.patch655 bytespearcec
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

apaderno’s picture

apaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
CreditAttribution: apaderno commented
Title: postgresql error on insert of a term. Might be related to taxonomy delegator » Postgresql error on inserting a term
apaderno’s picture

apaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
CreditAttribution: apaderno commented
Version: 5.x-1.6 » 5.x-2.x-dev
Status: Needs review » Closed (duplicate)

I am changing the referring version to the version which gets the code fixes.
This is then a duplicate of #278012: SQL error when adding new term.