ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Customizing ProductCart
  New Posts New Posts RSS Feed - Problem with /store/pc/gwReturn.asp
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Problem with /store/pc/gwReturn.asp
 Post Reply Post Reply
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
rogerenelson View Drop Down
Newbie
Newbie


Joined: 23-March-2009
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote rogerenelson Quote  Post ReplyReply Direct Link To This Post Topic: Problem with /store/pc/gwReturn.asp
    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
Back to Top
Greg Dinger View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers
Avatar

Joined: 23-September-2006
Location: United States
Status: Offline
Points: 238 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Greg Dinger Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Matt View Drop Down
Moderator Group
Moderator Group


Joined: 20-July-2006
Location: United States
Status: Offline
Points: 73 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Matt Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
rogerenelson View Drop Down
Newbie
Newbie


Joined: 23-March-2009
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote rogerenelson Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
rogerenelson View Drop Down
Newbie
Newbie


Joined: 23-March-2009
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote rogerenelson Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Hamish View Drop Down
Admin Group
Admin Group


Joined: 12-October-2006
Location: United Kingdom
Status: Offline
Points: 56 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamish Quote  Post ReplyReply Direct Link To This Post 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 WIKI Guidelines for Editing ProductCart's ASP Source Code
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.063 seconds.