Hi Max Headroom

Thanks for making this great sounding module. I am getting some errors with trying to connect to setcom

This is the error I get when my info get passed over to https://www.setcom.com/secure/

Setcom Secure Shopping Cart
All amounts are listed in South Africa Rand (ZAR)
Payments are Processed by Setcom. We accept Visa and MasterCard.
The following error occurred:

A required argument is missing.

A required argument is missing and we can not setup the seller's secure shopping cart.

# If you are a buyer receiving this error, please contact our highly trained support staff and provide them with the following information:The seller or website you were trying to purchase from
# What browser and operating system you are using.
# The approximate date and time you received this error.

If you are a seller testing your implementation and received this error, please visit our Help Center and download the Setcom Implementation Guide. In this instance the LIDPrice1 argument is missing.

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ','.

Resources:

* Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debug Output Settings, and select the Robust Exception Information option.
* Check the ColdFusion documentation to verify that you are using the correct syntax.
* Search the Knowledge Base to find a solution to your problem.

Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.0.10) Gecko/2009042315 Firefox/3.0.10
Remote Address 41.145.44.245
Referrer http://www.africanfootballstock.com/cart/checkout/review
Date/Time 09-May-09 08:18 PM

CommentFileSizeAuthor
#5 setcom_error.png124.09 KBB4n7o

Comments

iaminawe’s picture

iaminawe commented

bump bump

Max_Headroom’s picture

Max_Headroom commented

It sounds like that the information send to Setcom has an error in it.
Please check if your name, address or product details on checkout contain characters like a comma, etc.
You can send me those details (private) if you want me to have a look at it.

Let me know if you found something like that and in which field.

jlab’s picture

jlab commented

Getting the same error over here.

No weird characters is visible in any of our fields.

Max_Headroom’s picture

Max_Headroom commented
Status: Active » Needs review

I have made some changes. It all works on my test server. But it was difficult to reproduce before.
Please test the updated Dev version.

B4n7o’s picture

B4n7o commented
StatusFileSize
new setcom_error.png124.09 KB

hi, im getting the same error, i though it might be the currency codes, as in setcom's documentation south africa is ZA, not ZAR, so i though that might fix it, but it clearly wasn't because i still get the same error, am i doing something wrong, or is there a an issue bigger than me?

How did others resolve the issue?

Max_Headroom’s picture

Max_Headroom commented

Hi
The screenshot shows a different error. And it looks like it could be your settings.
Are you using the test account?

Please send me a personal message where I can help you with the setup.

Max_Headroom’s picture

Max_Headroom commented
Version: 6.x-1.x-dev » 6.x-1.0
Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.