Posted by bendiy on October 29, 2009 at 11:48pm
3 followers
Jump to:
| Project: | Homebox |
| Version: | 6.x-1.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
| Issue tags: | db_query, pgsql, PostgreSQL |
Issue Summary
I just installed Home Box on a fresh install of the new Drupal 6.14 and I get the following Error after creating a Home Box Page and adding two Blocks to it, Navigation and Who's Online.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: character varying = integer LINE 1: ...FROM blocks_roles WHERE module = 'user' AND delta = 1 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in \includes\database.pgsql.inc on line 139.
* user warning: query: SELECT rid FROM blocks_roles WHERE module = 'user' AND delta = 1 in \sites\all\modules\homebox\homebox.module on line 255.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: character varying = integer LINE 1: ...FROM blocks_roles WHERE module = 'user' AND delta = 3 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in \includes\database.pgsql.inc on line 139.
* user warning: query: SELECT rid FROM drupal_blocks_roles WHERE module = 'user' AND delta = 3 in \sites\all\modules\homebox\homebox.module on line 255.In homebox.module line 255, I've changed:
$allowed_roles = db_query("SELECT rid FROM {blocks_roles} WHERE module = '%s' AND delta = %d", $block->module, $block->delta);To...
$allowed_roles = db_query("SELECT rid FROM {blocks_roles} WHERE module = '%s' AND delta = '%s'", $block->module, $block->delta);And it's working.
My blocks_roles table is using data type "character varying(32)" for the delta column, not data type "integer".
Comments
#1
Thanks, committed!
#2
Automatically closed -- issue fixed for 2 weeks with no activity.