pp_confirm.php not inserting records

PAYPAL receives "payments" but once "customer" is redirected to "confirm" and update PHP MYSQL Database following error is given:

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 ( ** INFORMATION GIVEN BY PAYPAL **) at line 1 - See private message...

I have search through the threads and couldn't find any solution to fix this error,

It looks like the server behavior has columns specified as numbers where they are actually text. Update the Store Cart Summary in Database and Store Cart Details in Database server behaviors on that page and make sure that columns that aren't numeric are properly specified as "Text"

This is what I have in database fields..

The issue is in the server behaviors on the php pages, not the database itself.

I am going to do another test and dumb $_SESSION if this works to see what the problem...

Please attach a copy of the pp_confirm.php file and I can tell you where the issue is. I think you just have to update the Store Cart Summary in Database server behavior on that page.

Go to the Server Behaviors window and double click on "Store Cart Summary In Database" Then click through all of the columns on the second tab and set them to "Text" instead of "Number" for any columns that should have text in them.

You will have to do the same thing for the "Store Cart Details in Database" server behavior because I see they are set incorrectly there as well.

Thank you, Woot working small bug only but a few data entries in shipping info (Name, Phone, Fax) not being inserted.

Do you have a list of paypal php mysql field varibles like paypal->fullname...