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:
Quote:
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.
Re: Database anomalies after relocating between Mac Mini colocation sites
Quote:
Originally Posted by
ronlee67
1265 Data truncated for column 'lp_trans_num' at row 1
What's the field definition for that field in the database? It's supposed to be: varchar(64) NOT NULL DEFAULT ''
Re: Trouble with linkpoint module after relocating colocation site
Quote:
Originally Posted by
ronlee67
- 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.
Sounds like ports aren't set properly: http://www.zen-cart.com/content.php?...payment-module
Re: Trouble with linkpoint module after relocating colocation site
Thank you my friend (Dr. Byte). That fixed that issue. Have no idea how that field "type" got changed. I found it set to int(11).
Re: Trouble with linkpoint module after relocating colocation site
I think you are right about the port... we haven't quite figured what's going on with port 1129. It is configured open, but when we test it from an offsite test site their report says it is closed. Working that issue now. Any suggestions are welcome.
Re: Trouble with linkpoint module after relocating colocation site
Quote:
Originally Posted by
ronlee67
I think you are right about the port... we haven't quite figured what's going on with port 1129. It is configured open, but when we test it from an offsite test site their report says it is closed. Working that issue now. Any suggestions are welcome.
Actually, it only needs to be open for outbound communication, not inbound.
Re: Trouble with linkpoint module after relocating colocation site
Quote:
Originally Posted by
DrByte
Quote:
Originally Posted by
ronlee67
1265 Data truncated for column 'lp_trans_num' at row 1
What's the field definition for that field in the database? It's supposed to be: varchar(64) NOT NULL DEFAULT ''
Quote:
Originally Posted by
ronlee67
Thank you my friend (Dr. Byte). That fixed that issue. Have no idea how that field "type" got changed. I found it set to int(11).
Um, int(11) is not varchar(64) not null default ''