* warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: character varying = integer LINE 1: SELECT * FROM actions WHERE ( aid = 1) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Please see the suggested patch:

http://gitprivate.catalyst.net.nz/gw?p=drupal.git;a=commit;h=b07b21f7476...

CommentFileSizeAuthor
#2 actions-postgres83.patch3.46 KBned0r

Comments

ned0r’s picture

ned0r commented

Postgres 8.3 has become more strict about type checking.

The current actions module is using %d place holders to do updates to a VARCHAR field in the database, and postgres is throwing warnings about it.

The patch simply alters the updates to use '%s' placeholders instead :-)

ned0r’s picture

ned0r commented
StatusFileSize
new actions-postgres83.patch3.46 KB

Attached patch

dpearcefl’s picture

dpearcefl commented

Is this still an issue using current Drupal 6? Is the patch still needed?

Status: Active » Closed (outdated)

Automatically closed because Drupal 6 is no longer supported. If the issue verifiably applies to later versions, please reopen with details and update the version.