Totally Zenned
- Join Date:
- Sep 2006
- Location:
- Colorado Springs CO USA
- Posts:
- 519
- Plugin Contributions:
- 0
Trouble with linkpoint module after relocating colocation site
We are in the process of relocating our MacMini to a new colocation facility.
We uploaded a backup of our site to a loaner machine at the new location and enabled curl, SOAP etc. and put it online.
Customer's get the following error while placing orders and selecting linkpoint to pay by credit card. Error occurs after they press the confirm order button on the "Step 3 - Confirm Order" screen:
1265 Data truncated for column 'lp_trans_num' at row 1
in:
[update aso_orders set lp_trans_num ='67886-7L1p7I' where orders_id = '67886']
- Linkpoint transaction completes properly.
- orders_total table fields are properly posted.
- orders_products and orders_products_attributes are not getting posted with products ordered.
- All entries as viewed in Admin for the order are correct except that the line items of products ordered is missing.
- Payment details section shows all the Linkpoint data as expected.
- Zencart 1.3.9h
- Two other Zencarts (1.3.8a and 1.3.9h) on that machine are throwing "Cannot connect to credit card company" messages after customer hits the "Confirm order" button.
- None of these anomalies are showing up with other payment modules.
A review of the database tables reveals that the full order number that is submitted to linkpoint (which includes the Zencart issued number plus a dash and several random characters) have never been posted in the lp_trans_num field, only the basic order number has been posted there in the past. That explains to me why the error message reports that the data is truncated (likely on purpose.) What I don't understand is why this is throwing an error message to the customer and why the products are not showing up in the order.
