pp_confirm.php is now reporting...
"There is an error in your SQL syntax."
...when using a Sandbox PayPal account and opting to pay with PayPal.
The full URL producing this error is:
https://www.sportsmedicalcertificates.com/pp_confirm.php?token=EC-9BA9359744842612D&PayerID=7Z5MAA6W5C7SG
I had edited the Store Database Summary behaviour to include the fields I need from "Transaction Response from PayPal Express Checkout". I don't know how to diagnose this error though as there is very little detail.
Hope you can help.
Regards
NJ
EDIT: I changed the queryobj.php file Debug to true and I'm now getting this:
INSERT INTO SMCorders (`SMCorderSTATUSID`, `SMCorderPAYPALRESP`, `SMCorderPAYPALID`, `SMCorderPAYPALDATE`) VALUES (4, 0, 0, 2019)
Incorrect datetime value: '2019' for column 'SMCorderPAYPALDATE' at row 1
