If I define a poll and activate a block with this poll on the left/rigth side, I get an error message when I try to vote as an anonymous/member user in the block: "You didn't specify a valid poll choice." I cannot see other errors in logs.

This happens in all pages showing the poll block except in the poll side, here I do not get the error and I can vote without problems. To vote from the poll side (and not from poll block) works without problem.

php-4.3.11
drupal-cvs_19_11_2005
postgresql 8.0.4

Comments

ralfm’s picture

Title: Problems voting from poll-block » Problems voting from poll-block .... problems with postgresql maybe?

I get another error when trying to vote from poll-block if I am in the "?q=admin/settings" page as an administrator:

* Invalid argument supplied for foreach() in /www/drupal-cvs_19_11_2005/modules/node.module on line 356.

* implode(): Bad arguments. in /www/drupal-cvs_19_11_2005/modules/node.module on line 359.

* pg_query(): Query failed: ERROR: syntax error at end of input at character 317 in /www/drupal-cvs_19_11_2005/includes/database.pgsql.inc on line 78.

* query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /www/drupal-cvs_19_11_2005/includes/database.pgsql.inc on line 95.

Cvbge’s picture

Title: Problems voting from poll-block .... problems with postgresql maybe? » Problems voting from poll-block - db_rewrite_sql() mangles query?

The bug happens also on mysql. Looks like db_rewrite_sql breaks the query.

ralfm’s picture

chx’s picture

Status: Active » Closed (duplicate)