Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
jchatard CreditAttribution: jchatard commentedThanks, committed!
Comment #3
Liam Morland