on checkout when uc attempts to insert payment record in db I get the following exception, im using sagepay as payment provider.

"Data too long for column 'comment' at row 1 query: INSERT INTO uc_payment_receipts (order_id, method, amount, uid, data, comment, received)..."

Why?

Comments

keyoke’s picture

keyoke CreditAttribution: keyoke commented

it doesnt happen with the builtin test uc gateway

longwave’s picture

longwave
he/him
Primary language English
Location UK
CreditAttribution: longwave commented
Status: Active » Closed (duplicate)

Duplicate of #1176484: Data too long for column Exception on Checkout as this only apparently affects Sage Pay.

longwave’s picture

longwave
he/him
Primary language English
Location UK
CreditAttribution: longwave commented
Version: 6.x-2.4 » 7.x-3.x-dev
Status: Closed (duplicate) » Active

Reopening this as it can occur in 7.x. I don't see a problem with changing comment from varchar to text for gateways that provide lots of transaction data.

longwave’s picture

longwave
he/him
Primary language English
Location UK
CreditAttribution: longwave commented
Version: 7.x-3.x-dev » 6.x-2.x-dev
Status: Active » Patch (to be ported)

Fix committed to 7.x: http://drupalcode.org/project/ubercart.git/commitdiff/050ab86

longwave’s picture

longwave
he/him
Primary language English
Location UK
CreditAttribution: longwave commented
Status: Patch (to be ported) » Fixed

Ported and committed to 6.x: http://drupalcode.org/project/ubercart.git/commitdiff/8a510a7

Status: Fixed » Closed (fixed)

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