I have 3 outstanding re-creatable Linkpoint API errors. Each slightly different in their basket make-ups. A customer encountered this combination yesterday:

Error Message:

Subtotal miscalculation. Please notify the storeowner.
SGS-002301: Charge total must be the sum of subtotal, tax, value added tax, and shipping.

Linkpoint Debug Data - FAILURE
Sep-15-2008 03:12:29

Response Code:

Sending to Gateway:
result = LIVE
oid = 1071-VnvCJQ
ip = <removed>
ponumber =
subtotal = 39.425
tax = 0
shipping = 4.95
chargetotal = 44.375
cardnumber = ******
cardexpmonth = 11
cardexpyear = 08
cvmindicator = provided
cvmvalue = ******
userid = 552
customerid = 552
name = <removed>
company =
address1 = <removed>
address2 =
city = <removed>
state = Arizona
country = US
phone = <removed>
email = <removed>
addrnum = <removed>
zip = <removed>
sname = <removed>
saddress1 = <removed>
saddress2 =
scity = <removed>
sstate = <removed>
szip = <removed>
scountry = US
comments = Website Order
ordertype = SALE
host = secure.linkpt.net
port = 1129
keyfile = /home/admin/public_html/includes/modules/payment/linkpoint_api/<removed>
configfile = <removed>
transactionorigin = ECI
terminaltype = UNSPECIFIED

Result:
(
[r_csp] =>
[r_time] => Mon Sep 15 16:12:32 2008
[r_ref] =>
[r_error] => SGS-002301: Charge total must be the sum of subtotal, tax, value added tax, and shipping.
[r_ordernum] => 1071-VnvCJQ
[r_message] =>
[r_code] =>
[r_tdate] =>
[r_score] =>
[r_authresponse] =>
[r_approved] =>
[r_avs] =>
)

I have set up a testing database where I took this customer's order configuration and was able to re-create her error as well as the previous errors.

The other error is located in this thread:
http://www.zen-cart.com/forum/showthread.php?t=103208

This latest instance is the most simple in construct. No sales tax and no coupon codes involved. No sale products either.

I'm really hoping someone can get to the bottom of this.

As a side question: Should I consider dropping my credit card provider and finding a new one that uses a different API?

Thank you!

Kathy

Additional information on this transaction:

Shopping cart had the following items:

Product ID Qty Products Price
53 .5 9.00
125 .5 9.00
136 .5 9.00
232 .5 9.00
350 .5 15.95
354 .5 17.95
357 .5 8.95

No discount codes, no items were on sale, no sales tax applied to this customer.

I have a testing area set up that contains a sample customer with this shopping cart and I can re-create the error.

I would really like to get this fixed if anyone can take a look.

Thank you!

Kathy

I have 4 different Linkpoint API failures which I can re-produce. To consolidate and make this easier to see all in a single place I created a spreadsheet with the product cart information for each scenario and other characteristics of the customer's checkout that may be contributing to the errors.

I've attached that file to this post.

I have 3 of the 4 Linkpoint log files which I can provide on request. They contain personal customer information so I'm not attaching them.

The one common thread across all 4 cases is that they contain a partial quantity of a product (either .5, 1.25 or 1.5) and the calculated cost of that partial quantity (product price x quantity ordered) results in an amount that has more than 2 places to the right of the decimal.

I have many successful checkouts of products that contain partial quantities where the final amount is more than 2 places to the right of the decimal so that can't be the only driving force behind a failure.

Thank you!

Kathy
Pink Chalk Fabrics

I've experienced two more of these failures in the past week. It's driving me nuts and costing me money to see orders lost!

Can someone please let me know if this can be fixed within a reasonable time frame and if so what that time frame is?

Can I pay someone to fix this error? Is this the type of job I should post on the thread in the forums? I'm concerned about finding someone with the skill to repair this but I'm more than willing to pay to have it fixed.

If that is not reasonable can I please get a recommendation on whether I should move to Paypal for my integrated credit card processing or look for a credit card vendor that uses the authorize.net gateway. I don't want to migrate to a new vendor only to encounter similar problems with the stability of the module.

I don't want to be a nag but I need to move forward on a solution. I realize it's difficult to debug and repair this error but I need to make a decision on how to proceed as my business grows.

Thank you!

Kathy

I've been working on this off and on for some time.

The attached file is STRICTLY a beta which will hopefully address the problem you reported. I'd be interested in your test results.

My preliminary test seems to show it to be okay. However, I've not tested it with every possible combination of things, including extra order-total addon mods etc.

Thanks Dr. Byte! I'll test this out as soon as I get my kids off to school! I have 6 cases set up in my testing environment and they're all a bit different. I'll let you know the results.

Kathy

:clap::hug:

Thank you Dr. Byte! 6 for 6 test cases went through successfully. I can't even begin to tell you how happy this makes me. I've moved the fix into my production environment.

Have a fabulous week!

Kathy

pinkchalkstudio:

:clap::hug:

Thank you Dr. Byte! 6 for 6 test cases went through successfully. I can't even begin to tell you how happy this makes me. I've moved the fix into my production environment.

Have a fabulous week!

Kathy

I just opened my store and have the same error and I use Linkpoint. Before I install file from Dr. Byte...Have you had any more errors? And do you use additional payment options like Paypal? I have only Linkpoint and was getting ready to install paypay.

Thanks,
Kim

Hi Kim,

No errors! Yay! This fix definitely did the trick. I was averaging several of those failures a month and I've had no problems for the last 30 days.

I also take Paypal (the one where the customer leaves the shop to go pay and then they come back).

Good luck!

Kathy

pinkchalkstudio:

Hi Kim,

No errors! Yay! This fix definitely did the trick. I was averaging several of those failures a month and I've had no problems for the last 30 days.

I also take Paypal (the one where the customer leaves the shop to go pay and then they come back).

Good luck!

Kathy

I just installed. Thanks for the reply. I am getting ready to add paypal too.

DrByte:

I've been working on this off and on for some time.

The attached file is STRICTLY a beta which will hopefully address the problem you reported. I'd be interested in your test results.

My preliminary test seems to show it to be okay. However, I've not tested it with every possible combination of things, including extra order-total addon mods etc.

DrByte: I just posted a new thread. I loaded the attached files after getting the 2301 error. Now, I have a blank page with checkout. I loaded error debug mod and found error to be....[30-Nov-2008 17:31:25] PHP Fatal error: Cannot redeclare class linkpoint_api in /public_html/includes/modules/payment/linkpoint_api.php on line 13.

The includes/modules/payment/linkpoint_api.php file for lines 13, 14 & 15 are here....

class linkpoint_api {
var $code, $title, $description, $enabled, $payment_status, $auth_code, $transaction_id;
var $_logDir = DIR_FS_SQL_CACHE;

I do not know php well enough to see the problem. Can you help?
Thanks, Kim

That error is a classic symptom of loading the module file into the languages folder.

DrByte:

That error is a classic symptom of loading the module file into the languages folder.

I re-loaded this file several times. How can I fix?
Thanks, Kim

kburner:

I re-loaded this file several times. How can I fix?
Thanks, Kim

I still have blank screen at checkout. What can I do to fix? I loaded the file several times and even re-loaded original file and still blank.? I am losing sales....:frusty:

It worked several months ago while testing. I have all files loaded with pem, etc.

Thanks, Kim

DrByte:

I've been working on this off and on for some time.

The attached file is STRICTLY a beta which will hopefully address the problem you reported. I'd be interested in your test results.

My preliminary test seems to show it to be okay. However, I've not tested it with every possible combination of things, including extra order-total addon mods etc.

I loaded the same zip file to three different areas:

includes/languages/templatename/english/modules/payment
includes/languages/english/modules/payment
includes/modules/payment

I am wondering if I loaded wrong? and that is why getting blank screen at checkout?

Any ideas?:frusty:

Kim

kburner:

I loaded the same zip file to three different areas:

includes/languages/templatename/english/modules/payment
includes/languages/english/modules/payment
includes/modules/payment

I am wondering if I loaded wrong? and that is why getting blank screen at checkout?

Huh? "to three different areas"? You mean, you put the SAME file in 3 different places?
That's exactly what I meant in my earlier post about putting a module in a folder where a language file is expected.

The zip file posted above on Oct 22 contains a single .php file which replaces ONLY the /includes/modules/payment/linkpoint_api.php file.
Any other files by the same name should not be touched. You'll have to restore those from your backups.

Remember, this file has not been vetted for official implementation, and was offered as a preliminary aid to work around a particular problem reported by one person. The zip is not a complete update for multiple features or fixes, and should be considered use-at-own-risk.

DrByte:

Huh? "to three different areas"? You mean, you put the SAME file in 3 different places?
That's exactly what I meant in my earlier post about putting a module in a folder where a language file is expected.

The zip file posted above on Oct 22 contains a single .php file which replaces ONLY the /includes/modules/payment/linkpoint_api.php file.
Any other files by the same name should not be touched. You'll have to restore those from your backups.

Remember, this file has not been vetted for official implementation, and was offered as a preliminary aid to work around a particular problem reported by one person. The zip is not a complete update for multiple features or fixes, and should be considered use-at-own-risk.

DrByte: Thank you so much! I re-loaded original files. I sent order thru and checkout worked! :clap:

Thanks, Kim

DrByte:

I've been working on this off and on for some time.

The attached file is STRICTLY a beta which will hopefully address the problem you reported. I'd be interested in your test results.

My preliminary test seems to show it to be okay. However, I've not tested it with every possible combination of things, including extra order-total addon mods etc.

Thank you for posting this updated code. Our store was getting some SGS-002301: Invalid subtotal errors and this seems to have fixed it.

The error was caused when using a discount + GV.

One question, is there a web site or something I can bookmark to keep track of releases of the Linkpoint API? It's hard to keep track of them just here in the forums.

Thanks again to the good Dr. for fixing what needs to be fixed, you rock!

-Darren

DrByte:

I've been working on this off and on for some time.

The attached file is STRICTLY a beta which will hopefully address the problem you reported. I'd be interested in your test results.

My preliminary test seems to show it to be okay. However, I've not tested it with every possible combination of things, including extra order-total addon mods etc.

Thanks DrByte. Fixed another happy customer!

Chuck

DrByte:

I've been working on this off and on for some time.

The attached file is STRICTLY a beta which will hopefully address the problem you reported. I'd be interested in your test results.

My preliminary test seems to show it to be okay. However, I've not tested it with every possible combination of things, including extra order-total addon mods etc.

Thank You Dr Byte. I was also getting ERROR (SGS-002301: Invalid subtotal) and your patch fixed it, though I was using Version 1.3.9e

I am wondering why they have not implemented your fix in the latest versions... ?