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:
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.
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