Results 1 to 7 of 7

Threaded View

  1. #1
    Join Date
    Sep 2006
    Location
    Colorado Springs CO USA
    Posts
    516
    Plugin Contributions
    2

    Default 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.
    Last edited by ronlee67; 17 Aug 2013 at 09:14 PM. Reason: fix typos
    www.aspenshopsonline.com - ZenCart 1.3.9h
    www.wilkssupply.com - ZenCart 1.3.9h
    www.un-du.net - ZenCart 1.3.8a

 

 

Similar Threads

  1. Coupon trouble with Linkpoint
    By engine411 in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 5
    Last Post: 2 Nov 2010, 09:28 PM
  2. trouble relocating downloads folder
    By dreadlocks1221 in forum General Questions
    Replies: 2
    Last Post: 15 Oct 2009, 08:19 PM
  3. Trouble with Linkpoint
    By rebekah in forum Built-in Shipping and Payment Modules
    Replies: 14
    Last Post: 21 Nov 2008, 07:08 PM
  4. Trouble with linkpoint
    By deals_24 in forum Built-in Shipping and Payment Modules
    Replies: 16
    Last Post: 21 Oct 2007, 01:34 AM
  5. Linkpoint API - Module is in testing mode? after upgrade
    By Zeit in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 26 Apr 2007, 03:36 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR