Closed (fixed)
Project:
Webform
Version:
6.x-3.4
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
27 Oct 2010 at 22:02 UTC
Updated:
12 Jan 2011 at 23:30 UTC
Jump to comment: Most recent file
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.
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | 955024_2.patch | 679 bytes | sammys |
Comments
Comment #1
quicksketchThanks, 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.
Comment #2
sammys commentedHere's a patch for those of us needing a fix.
Comment #3
davidwhthomas commentedThanks, had same issue here and the patch fixed it.
DT
Comment #4
gmh04 commentedsubscribe
Comment #5
quicksketchThis has been fixed as part of #1003228: PostgreSQL fix to db_placeholders().