Need ecart help inserting to database and with fatal error

I am having an issue with ecart. I am trying to set up ecart to use PayPal Express with entry into a db. I am unsure of the page flow of ecart. My fuzzy idea of how ecart works is that from the cart page (if you are logged in) you go to the checkout page. On the checkout page, you enter the billing, and shipping information into a form to hold/send to PayPal in a session variable. From the checkout page you would go to the confirm or confirm-cart page, click another checkout button on that page and then be sent to the PayPal gateway to pay. The billing, and shipping information collected on the checkout form would persist onto PayPal's payment form. After paying, PayPal would return you to the checkout success or failure page.

I think I am failing to understand the whole process here. I ran the Cart Wizard, included my db info, and checked the no shipping box. The Cart Wizard created the pages it said it would, but the checkout page has only a form for shipping and not billing on it. Why does the form ask for shipping and not billing information if I selected no shipping in the Wizard? Or does selecting no shipping just relate to no shipping charges?

When I click on the checkout button on the cart page in the browser (I am testing on my local server), I am sent directly to PayPal CheckoutNow without entering any billing, shipping, or cart confirmation information. PayPal took my penny purchase without complaint charging my purchasing account a penny and crediting my business account and sending my business account an email notifying me of the purchase. However, I didn't reach the checkout failure or success page. Instead, I got a notice in the browser stating, "Fatal Error: Call to undefined function WA_getSavedFormValue() in /User/..../confirm_cart.php on line 146 in FireFox and line 155 in Safari. Unfortunately, this wasn't enough information for me to figure out what the error meant relating to those lines because, primarily, I don't know what I'm doing. Nothing was entered into the db.

I deleted all the pages created by the Checkout Wizard and have rerun the Wizard several times with the same result. Is this the way the cart is supposed to work (minus the error)? Is the cart checkout button supposed to go directly to PayPal? How, and when, does the billing and order information get inserted into the db? And what, and how, do I fix the error being shown to make it all work? Thank you for your time and your patience helping me sort all this out!

It sounds like you have an older version of eCart.

the most recent version of eCart is 6.1.0. this sounds like a bug that was in a previous version that has since been corrected.

uninstall the previous eCart version from the Extension Manager, then install the newer one that is available for download in your account.

When you open DW, it should launch the WebAssist installer, if that does not launch automatically, open a php page to force it to start.

After the WebAssist installer completes, make sure to restart DW.

Then delete the existing checkout pages and run the checkout wizard again to recreate them.

Thanks for your reply. I am running the current version (6.1.0) of eCart. However, I did as you suggested in case there was a problem with the installation. I uninstalled eCart, downloaded eCart again, and reinstalled eCart. I deleted the MacFileCache. I quit and reopened DW CS6 after installing. I rebooted between each step. I rebuilt the forms from the Checkout Wizard which I had deleted. I have done these steps twice now. The checkout still goes straight to PayPal bypassing all the other pages. I am not sure what to do now. Do you have any more suggestions?

I did notice that in the Checkout Wizard on the orders tab I had problems getting the wizard to select the correct tables. I could select the correct connection, but the wizard had a problem finding the orders table and would consistently default to the first table in the db after I selected "define" to see whether the bindings were correct. Selecting the orders table would then delete all the preexisting bindings. I made a new preset by copying over the preexisting bindings to the orders table, but I'm not sure if I got them all correct or whether the wizard recognizes the new preset. Once I made a new preset for the orders table, the wizard recognized my orderdetail table and showed values for that table. (Mac 10.6.8, DW CS6)

I will look into this further tomorrow when I call to look into the menu writer issue.

Thank you! I was hoping to finish this project up this weekend which would be great!

we fixed this in a connect session

Thanks for your help! I greatly appreciated it.

you're welcome

Hi Jason, I now have most of the ecart installation working, however, I have a problem with the database entries into the orders table that I hoped you would take a look at. Only some data enter the table and I am unsure what to do to fix the problem. I am reluctant to experiment extensively because of the problem generating the ecart pages.

I assumed the issue is with the pp_confirm.php page. All the fields that use WA_coalesce(array(WA_getSavedFormValue are correctly entered while the fields beginning with WA_eCDB_ConvertNumber("".$eCart1 (Order Amount, Shipping, Tax, Discounts, Charges, Subtotal) have a 0 value. I might have done the binding or the db setup incorrectly? Would you please tell me what I need to do to fix this? I am enclosing my cart pages if that helps any. Thanks so much!

on the pp_comnfirm page, try adding the following code at line 159, just before the store order summary code.



<?php
$eCart1->GetContent();
?>