Error on Checkout

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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)

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
lcameron Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 08-May-2006 Status: Offline Points: 47	Post Options Post Reply Quote lcameron Report Post Thanks(0) Quote Reply Topic: Error on Checkout 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)

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply 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 shopping cart software