The latest hook_update_N() in uc_cart includes "WHERE ... delta=0", treating delta as an integer field, when it is really a varchar field. PostgreSQL does not automatically convert numbers to strings, and fails with the error message:

ERROR:  operator does not exist: character varying = integer               [warning]
LINE 1: ...ending Registrations' WHERE module = 'uc_cart'
AND delta = 0

Attached patch fixes the issue.

CommentFileSizeAuthor
uc_cart-update-pgsql.patch528 bytesjohn franklin

Comments

john franklin’s picture

john franklin commented
Status: Active » Needs review

Patch was attached.

Status: Needs review » Needs work

The last submitted patch, uc_cart-update-pgsql.patch, failed testing.

longwave’s picture

longwave
he/him
Primary language English
Location UK
commented
Status: Needs work » Fixed

Committed, thanks for the patch.

Status: Fixed » Closed (fixed)

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