Switching from Paypal Standard to Paypal Pro Getting Error on confirm page

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

see private message.

It looks like you are doing a database insert on that page and have columns specified as 'numeric' when they should be 'text'

Your right for some reason they all defaulted to numeric
I did a test and it seemed to go through, however I did not get an email from paypal for the transaction?
I see the transaction did go through but no emails were fired off.
Do I need to configure eCart to send the confirmation email or in pay pal pro settings?
If eCart which page do I put this on and how?

Paypal should send a receipt. You may have a setting in your paypal profile that prevents sending. If you send me a copy of your confirm.php page I can make sure you aren't disabling the email there.

thanks for checking.

It looks like this should send a receipt to me. We can look into it further in our screen sharing session tomorrow.