I'm getting following error while accessing Drupal Blocks panel:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: character varying = integer LINE 1: ... node n ON w.nid = n.nid WHERE w.block = 1 AND n.type IN (0) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /usr/share/drupal6/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT n.title, n.nid FROM webform w LEFT JOIN node n ON w.nid = n.nid WHERE w.block = 1 AND n.type IN (0) in /etc/drupal/6/sites/all/modules/webform/webform.module on line 1385.

The problem seems to be in $placeholders = db_placeholders($webform_node_types) assigment.
Changing it to $placeholders = db_placeholders($webform_node_types, 'varchar') solves it.

CommentFileSizeAuthor
#2 955024_2.patch679 bytessammys

Comments

quicksketch’s picture

Status: Active » Needs review

Thanks, I'll make this change next time I'm working on Webform. We do a similar check in several places, all of them will need to be updated.

sammys’s picture

StatusFileSize
new679 bytes

Here's a patch for those of us needing a fix.

davidwhthomas’s picture

Status: Needs review » Reviewed & tested by the community

Thanks, had same issue here and the patch fixed it.
DT

gmh04’s picture

subscribe

quicksketch’s picture

Status: Reviewed & tested by the community » Fixed

This has been fixed as part of #1003228: PostgreSQL fix to db_placeholders().

Status: Fixed » Closed (fixed)

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