close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Need ecart help inserting to database and with fatal error

Thread began 11/19/2014 4:32 pm by jurinski334466 | Last modified 12/26/2014 9:38 am by Jason Byrnes | 1723 views | 19 replies |

jurinski334466

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!

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

jurinski334466

eCart problems still

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)

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

jurinski334466

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

Sign in to reply to this post

Jason ByrnesWebAssist

we fixed this in a connect session

Sign in to reply to this post

jurinski334466

Thanks for your help! I greatly appreciated it.

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome

Sign in to reply to this post

jurinski334466

Lingering on...

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!

Sign in to reply to this post

Jason ByrnesWebAssist

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



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

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...