Gift Certificate Coupon codes mangled with padding

[Guest neilski]

Hi all,

I have a live store, 4.2.3 (not upgraded yet to 4.3) -I'm on Linux/PHP5.2.5/Mysql-5.0.67

I am having a major headache with Gift Certificates.

I've enabled them, and they can be purchased, they are emailed ok to the recipient, but there seems to be a major problem.

The sendCoupon function in classes/orders.php creates the code, and inserts it into the db, but the db table CubeCart_Coupons has a CODE column of type varbinary, this is causing the code to be padded to its length(25) with 0/ (zero-slashes). The code then appears mangled in the ORDER overview on the admin side, and when I try to use the code in checkout as acustomer, I get Sorry code not found

Anyone else had this problem? Or can suggest a workaround?

All I could think of was manually padding the code to 25chars, but dont want to go modding, if I have this wrong?

Could I be missing anything??

Any help or ideas would be great!!

Cheers

Neil.

[kinetic]

Interesting problem I havent seen this behavior on my clients 4.2.3 or 4.3 installs

but will keep an eye on them

have you submitted a ticket or bug report about this?

let us know what happens id be real interested to kow if this needs fixing or not

Sorry I couldnt be more helpful

Kinetic