close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

some orders not going into the database

Thread began 2/27/2018 10:23 am by Jamie | Last modified 3/19/2018 10:14 pm by Ray Borduin | 117 views | 7 replies |

Jamie

some orders not going into the database

Hey Ray

On an existing ecart installation, strangely an occasional order will be added but the summary is not added to the database (the details are).

I really dont know how to troubleshoot this one as I have no idea why most are fine yet there is the occasional error....

all help gratefully received

Have added info to the PM

Sign in to reply to this post

Ray BorduinWebAssist

Unfortunately I can't spot any issues that would cause this. We would have to first reproduce it. Without being able to reproduce it, we wouldn't be able to test if it was fixed if we did make changes.

Try maybe a second order without logging out? Using a phone? I'm afraid I wouldn't know were to start without reproducing it.

Sign in to reply to this post

Jamie

thanks Ray. I just cant replicate it... any suggestions on a methodological approach to testing the possible causes to try and replicate it?

Sign in to reply to this post

Ray BorduinWebAssist

If it is inserting in wrong and not updating it wrong later, you could probably prevent it without reproducing it.

It isn't the way I like to do things, because the underlying problem remains, but without reproducing it that might be your best option.

On line 29-30 of confirm.php you have:

if (isset($_POST["Payment_submit"]) || isset($_POST["Payment_submit_x"])) // Trigger
{



That is the trigger that does the insert summary. Below that you could add another final check:

php:
<?php require_once("webassist/form_validations/wavt_scripts_php.php"); ?>

<?php 
 
if (isset($_POST["Payment_submit"]) || isset($_POST["Payment_submit_x"]))  {
   
$WAFV_Redirect "checkout.php";
   
$_SESSION['WAVT_payment_Errors'] = "";
   if (
$WAFV_Redirect == "")  {
     
$WAFV_Redirect $_SERVER["PHP_SELF"];
   }
   
$WAFV_Errors "";
   
$WAFV_Errors .= WAValidateRQ(WA_getSavedFormValue('CheckoutWizard_NewFromBlank_Default','First_Name') . "",true,1);

   if (
$WAFV_Errors != "")  {
     
PostResult($WAFV_Redirect,$WAFV_Errors,"payment");
   }
 }
 
?>



That way if it ever gets to that point without a First Name value being set, it will redirect to the checkout page and start the checkout process over. It should prevent the problem even without understanding it. Then if you ever find a case where you can't checkout and it keeps starting over you have reproduced the problem.

Sign in to reply to this post

Jamie

ok thanks, so does that block of code go on line 88 (between store summary and store details)?

So I am assuming that we need to keep an eye out for a customer that says they keep getting thrown back to the start of the checkout process and we need to find out from them what/how they are doing to try and then replicate the issue?

Sign in to reply to this post

Ray BorduinWebAssist

It should go above the store summary... so above both. And yes look out for a customer or in your testing if it ever gets stuck going back to the checkout page you have reproduced it.

Sign in to reply to this post

Jamie

ok, many thanks Ray

Sign in to reply to this post

Jamie

This post has been deleted.

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