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.

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

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.

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

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.

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/