Results 1 to 7 of 7
  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

  2. #2
    Join Date
    Jan 2004
    Posts
    64,748
    Blog Entries
    6
    Plugin Contributions
    74

    Default Re: Database anomalies after relocating between Mac Mini colocation sites

    Quote Originally Posted by ronlee67 View Post
    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 ''
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Jan 2004
    Posts
    64,748
    Blog Entries
    6
    Plugin Contributions
    74

    Default Re: Trouble with linkpoint module after relocating colocation site

    Quote Originally Posted by ronlee67 View Post
    • 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
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

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

    Default 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).
    www.aspenshopsonline.com - ZenCart 1.3.9h
    www.wilkssupply.com - ZenCart 1.3.9h
    www.un-du.net - ZenCart 1.3.8a

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

    Default 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.
    Last edited by ronlee67; 18 Aug 2013 at 10:41 AM.
    www.aspenshopsonline.com - ZenCart 1.3.9h
    www.wilkssupply.com - ZenCart 1.3.9h
    www.un-du.net - ZenCart 1.3.8a

  6. #6
    Join Date
    Jan 2004
    Posts
    64,748
    Blog Entries
    6
    Plugin Contributions
    74

    Default Re: Trouble with linkpoint module after relocating colocation site

    Quote Originally Posted by ronlee67 View Post
    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.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  7. #7
    Join Date
    Jan 2004
    Posts
    64,748
    Blog Entries
    6
    Plugin Contributions
    74

    Default Re: Trouble with linkpoint module after relocating colocation site

    Quote Originally Posted by DrByte View Post
    Quote Originally Posted by ronlee67 View Post
    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 View Post
    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 ''
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

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