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

Store Summary/Details Behaviors

Thread began 3/16/2010 7:30 pm by dave349445 | Last modified 3/17/2010 4:17 pm by Jason Byrnes | 2026 views | 5 replies |

dave349445

Store Summary/Details Behaviors

Using eCart 4.5.2 and not able to get the eCart Store Summary and Details Behaviors to execute off a button trigger. The behaviors work using the default "any form post" trigger. Downside with "any form post" is the behaviors are executing when the confirm page loads instead of when the user clicks "submit order". So when a user reaches my confirm page the database gets populated with summary and detail records. If the user decides to go back and modify billing info then returns the detail records are again populated.

This is my first attempt with eCart so could very easily have done something wrong on my end but just cannot identify why setting trigger to the submit order button will not work.

Sign in to reply to this post

dave349445

Store Summary/Details Behaviors - new error

Modified the store details server behavior in the confirm page by trying a new trigger. Did not work and set it back to "any form post" which is the same as store summary behavior. Now when user attempts to load confirm page the following error appears:

Access denied for user 'xxxxxx'@'%' to database 'yyyyyyy'

The error appears to be caused by the store details behavior as the store summary behavior successfully creates the new DB record.

Any suggestions? I read a similar thread but no resolution was given since it went to a support ticket.

Regards,
Dave

Sign in to reply to this post

Jason ByrnesWebAssist

It sounds to me like you are using PayPal Payments standard.

When using paypal standard, the confirm page posts information directly to the paypal servers, this is why the Store Order summary and Details behaviors will not trigger off the submit order button. When a form submits to another page, it is not possible to use that form to trigger an action on the page that contains the form.

with paypal standard, the order summary table should have an order status column that is set to pending when the summary is first stored in the database.

You will need to set up an IPN page that can update the order status after the transaction is processed through paypal. More information on IPN can be found here:
ipn

For the error you are getting, you should double check a few things:

1) are there any server behaviors on your page that are using a different connection from the Store Order Summary behavior? specificly check the Store Order Details behavior, make sure they are using the same connection.

2) In the database, double check the privileges for the user, i am including a screen shot that shows how to set privileges in phpMyAdmin.

Sign in to reply to this post

dave349445

Hello Jason,
Thanks for replying.

Regarding the connection error there is only one connection being used on the page. What's interesting is the details behavior was working fine with the same connection. Just modified trigger on the behavior then error appeared. User rights are good (setup with update, select and insert privileges for the database).

I am using PayPal Standard and do have IPN in place. How can I prevent duplicate detail order records from being inserted each time the user chooses to modify billing info from the confirm page then returns to confirm page?

Dave

Sign in to reply to this post

dave349445

My order status in the order summary taple is not being set to pending so I may have missed a step.
Dave

Update: added "Pending" to the status field using the store summary behavior. Now the order confirmation page won't appear for the user (blank white page, no error message) but the summary order is being inserted. Currently have details behavior set to button trigger to prevent connection error. Using DW CS3, Win7. Uninstalled and reinstalled eCart extension and deleted DW cache file.

Sign in to reply to this post

Jason ByrnesWebAssist

I have created a technical support ticket so we can look into this issue.

to view and update your support ticket, please log into your support history:
forums/

Sign in to reply to this post

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...