Error on Checkout
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=3544
Printed Date: 09-May-2024 at 11:17am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Error on Checkout
Posted By: lcameron
Subject: Error on Checkout
Date Posted: 24-March-2010 at 12:01am
Customer was just contacted by a lady who got an error when trying to checkout. I've checked the error log and received this...
Customer Reference Number: 152055880-0183
Date/Time: 3/24/2010
Session ID: 152055880
Error Number: -2147217900
Source: Microsoft SQL Native Client
Description: Incorrect syntax near ';'.
query=UPDATE Customers SET [name]='Carla',lastName='XXXX',customerCompany='',phone='XXXX',address='57 XXXX Street',zip='XXXX',stateCode='NSW',state='',city='Sydney',countryCode='AU',address2='XXXX',fax='' WHERE idcustomer=44 AND pcCust_Guest=;
Request Method: POST
Server Port: 80
HTTPS: off
Local Address: 69.46.27.193
Host Address: 124.189.24.112
User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.8) Gecko/20100202 Firefox/3.5.8
URL: /store/pc/opc_UpdBillAddr.asp
HTTP Headers: 69.46.27.193, en-us,en;q=0.5
Anyone have any ideas? (customer name, number and address changed to "XXXX", they were correct in the error)
|
Replies:
Posted By: ProductCart
Date Posted: 24-March-2010 at 12:22am
Please submit support requests through our Support Ticket System, which is only available by logging into your account on our store and using the button at the bottom of the page to submit your ticket.
In this case, I believe your client has run into an issue that was just discovered and fixed by one of our developers earlier today and we can provide you with the files that should resolve the problem.
-------------
The ProductCart Team
Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software
|
|