Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Continue with PayPal immediately direting to checkout_failure.php?

View all replies to this thread

Continue with PayPal immediately direting to checkout_failure.php?

Thread began 2/27/2019 7:00 pm by Nathon Jones Web Design | Last modified 3/12/2019 9:18 pm by Nathon Jones Web Design | 161 views | 31 replies

3/07/2019 4:10 pmNathon Jones Web Design

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

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.