I'm trying Webform Module with Drupal 6 (which is working with PostgreSQL).

When I try to add the first component (for example, a date), I click on the 'submit' (or 'add') button, and then I get an empty page with 4 critical messages :

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/tekover/includes/database.pgsql.inc on line 138

Warning: ERROR: current transaction is aborted, commands ignored until end of transaction block query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:"%error";s:7:"warning";s:8:"%message";s:171:"pg_query() [<a href=''function.pg-query''>function.pg-query</a>]: Query failed: ERROR: zero-length delimited identifier at or near &quot;&quot;&quot;&quot; at character 139";s:5:"%file";s:44:"/var/www/tekover/includes/database.pgsql.inc";s:5:"%line";i:138;}', 3, '', 'http://www.tekover.net/node/9/edit/components/new/grid?name=my&mandatory=0&pid=0&weight=-10', 'http://www.tekover.net/node/9/edit/components/new/grid?name=my&mandatory=0&pid=0&weight=-10', '84.102.119.230', 1206902256) in /var/www/tekover/includes/database.pgsql.inc on line 159

Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /var/www/tekover/includes/database.pgsql.inc on line 138

Warning: ERROR: current transaction is aborted, commands ignored until end of transaction block query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:"%error";s:12:"user warning";s:8:"%message";s:500:"ERROR: current transaction is aborted, commands ignored until end of transaction block query: INSERT INTO webform_component (nid, cid, pid, form_key, name, type, value, extra, mandatory, weight) VALUES (9, 1, 0, &quot;my&quot;, &quot;my&quot;, &quot;grid&quot;, &quot;&quot;, &quot;a:5:{s:11:&quot;description&quot;;s:4:&quot;test&quot;;s:7:&quot;options&quot;;s:4:&quot;test&quot;;s:9:&quot;questions&quot;;s:4:&quot;test&quot;;s:7:&quot;optrand&quot;;i:1;s:5:&quot;qrand&quot;;i:1;}&quot;, 1, -10)";s:5:"%file"; in /var/www/tekover/includes/database.pgsql.inc on line 159

Then, I'm unable to add any component... :(.

Comments

cf357’s picture

Status: Postponed (maintainer needs more info) » Fixed

The patch which is provided here : http://drupal.org/node/239050
works with my version of Drupal 6.

quicksketch’s picture

Thanks for finding the fix. I'll roll out another beta shortly to keep this from happening.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.