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

jchatard’s picture

Status: Active » Fixed

Thanks, committed!

Status: Fixed » Closed (fixed)

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

Liam Morland’s picture