search

lightspeedretail / webstore

Web Store eCommerce solution for Lightspeed
http://www.lightspeedpos.com/webstore
Open Software License 3.0
85 stars 63 forks source link

Cancelling PayPal payment results in an error #587

Closed hakonorri closed 9 years ago

hakonorri commented 10 years ago

I get this error when I return to webstore from PayPal (if I click "Cancel and return to Storenamexxx").

Error 500 CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (hakon_lalujo3.xlsws_customer, CONSTRAINT xlsws_customer_ibfk_1 FOREIGN KEY (default_billing_id) REFERENCES xlsws_customer_address (id))

No payment was done.

I would like to go to the active cart again.

ktwbc commented 10 years ago

Hi,

can you provide us with some more information on this? Are you checking out in guest mode or are you a logged in user on checkout? If you are logged in, is this a new address you're entering or one chosen from the address book? This will affect the sequence of events and the issue you are seeing.

hakonorri commented 10 years ago

Hi. doesn't matter if I'm loggin in to Lightspeed or not. This happens when I check out as a "PayPal guest" and pay with a credit card (not a PayPal account). There is a link on PayPal called "Cancel and return to XXX". When I click this link, this happens. 6 screenshots and more info in Support Request #23741. If you don't have access to Support Requests I can upload the screenshots again.

euoia commented 9 years ago

Fixed in 3.1.0 (ref: WS-751).