Ok, got a little farther still Jason :)
I removed the "Authentication for PayPal Express Checkout Behavior" on the confirm page and ran a test. The credit card info was added and when I hit checkout I was directed to the confirm page AWESOME! I saw the last four digits of the credit card, exp/year came across as well YEAH! I changed the shipping method and hit update, now the shipping updates but the credit card information is gone? Hit the back button and my CC info was still in place - hit checkout again and once on the confirm page with everything where it should be I hit submit order and I get the same error message "Unknown column 'ExistingCustomer' in 'field list' "? I do have a column for this in my database and it is currently working on the live site as well.
So to test further, I went back to create a new order, this time I clicked on the paypal button to test this payment method with the behavior changes and it takes me to the confirm page? So the problem before was that if I entered a cc or hit the paypal button I was redirected to paypal - Now everything just goes to confirm and submit order still does not work?
So am I suppose to add a "Authentication for PayPal Express Checkout Behavior" somewhere as this is what seemed to take me to paypal? Now I am even more confused than before :(
Confirm Page has a "local checkout ecart paypal direct behavior" and the checkout page has a "Authentication for PayPal Express Checkout Behavior" what am I missing here?
Please help if you can - Thank you in advance!