Customizing ProductCart - Problem with /store/pc/gwReturn.asp

Print Page | Close Window

Problem with /store/pc/gwReturn.asp

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=2580
Printed Date: 25-July-2025 at 9:07pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Problem with /store/pc/gwReturn.asp

Posted By: rogerenelson
Subject: Problem with /store/pc/gwReturn.asp
Date Posted: 23-March-2009 at 3:12pm

I am getting an:

Invalid procedure call or argument<p>query=SELECT email,name,lastName,idCustomer,customerCompany FROM customers WHERE idcustomer=...snip...</p>

I can take the SQL and run it against the database so the SQL is good, can't think why this is returning an error.

Roger

Replies:

Posted By: Greg Dinger
Date Posted: 23-March-2009 at 3:34pm

gwReturn.asp is the script that takes over the checkout process when your customer has submitted their payment information. orderVerify.asp presents payment method options, the next page prompts (for example) for the credit card number, they click submit - that causes the flow to go to the gateway (such as authorize.net) and when the gateway interface concludes the process returns to gwreturn.asp which then decides what to do next.

A good starting point to find a resolution would be to select the "troubleshooting utility" on the help menu in your admin. Check to see if there are any warnings. I'm hoping EI might chime in but this may be an issue with the XML parser needing to be upgraded, but I'm not totally certain.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: Matt
Date Posted: 23-March-2009 at 3:45pm

Going by your previous post I suspect you are making some customizations. Is that correct? If so, revert to the original file and add you changes one by one until you trigger the error. If this is not a customization you should open a support ticket.

Posted By: rogerenelson
Date Posted: 24-March-2009 at 1:51pm

Customizations you say, that is a help,

Here is what the trouble shooting utility says about parsers:

XML Parser

Current XML Parser
Your store is currently using the following XML Parser: MSXML2 v6.0 parser.

Available XML Parsers on Server

< = value="" name=ChangeParser>	MSXML Parser	INSTALLED
< = value=.2.6 name=ChangeParser>	MSXML2 v2.6 Parser	INSTALLED with Errors - 006~ASP 0177~Server.CreateObject Failed~800401f3
< = value=.3.0 name=ChangeParser>	MSXML2 v3.0 Parser	INSTALLED
< = value=.4.0 name=ChangeParser>	MSXML2 v4.0 Parser	NOT INSTALLED
< = value=.5.0 name=ChangeParser>	MSXML2 v5.0 Parser	NOT INSTALLED
< = value=.6.0 name=ChangeParser>	MSXML2 v6.0 Parser	INSTALLED

The required XML Parsers are installed.

I see there is a problem, with the V2.4 parser. However, I am thinking that this should be fine since I have selected on the V6.0 Parser.

I just migrated the the site to a new server and have taken over the support, now this error seems to have been going on for some time before I arrived and it would seem to related to the original customizations.

The site is using ProductCart v3.5-BETA016rbrbrb where can I get the original code? Is there a place where I can download it?

Roger

Posted By: rogerenelson
Date Posted: 16-April-2009 at 6:37pm

So I checked the code against prod version 3.5 and although there is a subscription module tracking inserted in the package, this part of the code has not been customized. I did notice that the users that encounter this error are usually using some flavour of MOzilla the most recent case was: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.17) Gecko/20080829 Firefox/2.0.0.17 (.NET CLR 3.5.30729). The problem never happens with a Java user agent.

I get this error on an order about once in every 30 orders.

Posted By: Hamish
Date Posted: 16-April-2009 at 6:45pm

Hi Roger,
Your right about the XML Parser, it's only the one you have selected that is used and its very common that not all the parsers are installed without errors, but it's not a problem.

I suggest upgrading to V3.51 from the Beta V3.5 if at all possible.

-------------
Editing ProductCart Code?

See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code