Paypal is not redirecting me to a my intended confirmation page set in the 'Confirmation Status Page Setup (After Payment)'. It's sending me back to the Buy Now page with a 'critical error has occurred. An unexpected error has occurred' message at the top.

Also, the 'Enable OnCheckout Complete Event (Stored Procedure)' is not triggering my procedure (I've verified that it works in SQL).

What am I doing incorrectly?

I'm using Smith Cart 4.86 on DNN 6.00.2 with SQL 2005

Thank you. I'm in Paypal test mode, so I don't see that feature, but I'll assume it's there when I go live.