Printable View
Hi All,
This problem is intermittent, and I have no firm idea why it happens...sometimes (perhaps 5% of the time) I get two order conformation emails (but payment is taken from the customers card only once).
This can give me –ve stock levels and also screws up my sales report for the month:(
Any ideas what may be causing this? I can see no real 'link' between 'single' and 'duplicated' orders. (N.B. All my card transactions are done on-line)
Running v1.3.7
Cheers!
Beer_man.
I am having the same problem...I have had it happen when they used paypal as a payment and when using the CC module on zen cart.
Does anyone have a fix?
Thanks!
I, too, had this happen today for the very first time.
A duplicate order was created 14 seconds after the original order.
The duplicate went to the "Pending" category whereas the original went to "Processing".
The duplicate shows cc as the payment module, but the original shows linkpoint_api (as it should). For the record, I've never used the cc module.
Okay, something is going on, now I am getting 3 copies of each order! Does anyone have any idea what could be the problem?
I am using 1.3.7, lots of add on modules!, cc module, paypal express....note that the last 3 orders where with the cc module (I am not sure if the orders double or triple in PP)
Now I need to figure out how to fix this without deleting orders, no red flags needed here!
This just happened to us today as well, it produced three order numbers and confirmations(for the same order), but only registered one payment.
Any ideas?
I have this happened to me on the 2 websites i am managing, i got 3 order numbers and one email confirmation from each (happened once on each site).
in one site it happened when a customer used Google checkout and the other when local checkout with CC was used.
Both carts are 1.3.7
Any Idea?
Hi
This has happened to me six times in the last two weeks - does anyone have any ideas why?
Mine just stopped doing it!! I don't understand, I didn't do anything to fix it, at least not that I know of...hopefully it doesn't start up again!
I have this problem already years, and nobody can help, once or twice a week I get double order with different number, only 1-4 sec. diffencies in time. CAN PLEASE ANYBODY in this planet help? How can I stop this? I am using finnish bankmodules.
Thanks!
This has just started happening to me, both with Google checkout and Paypal. I am having double orders for the same customer i.e 214 and 215 and the cart is sending out two confirmation e-mails however, the customer has only order one item, what i have notice that one order has all the information transmitted from both Google check out and PayPal, where as the duplicate order only looks like a invoice type format does show order number ect. but doesn't show the Google and PayPal return information. Any one working on this fix?
Mine just stopped doing this as quick as it started....I don't know why.
Anyone information about the cause of this problem??
I'm also now getting this. This is for CoD payment.
To all the folk who had this - did they do anything to stop it?
Hey everyone... I dont post here very often, but I will try to help.
This happened to me a long time ago... I dont know if this may fix your problem or not...
Check your settings in Configurations --> Sessions --->
Cookie Domain --> True
Prevent Spider Sessions --> True
Recreate Session --> True
After I changed these, I had no problems.
Happy hunting!
That's the settings I have.
odd.
We are having the same issue. It is intermittent, some days we will have 2 or three orders that will duplicate the orders, but not the pay. We also have some orders that generate 3 to 5 order #'s and confirmations, but only one pay.
We are using paypal ipn and paypal direct.
Any ideas on how to fix this? The customers are panicking until they realize they haven't paid but only once.
Please, help!
Thank you
Our site (1.3.7) displayed this duplicate order issue yesterday. PayPal only charged once, but the order itself was duplicated a few seconds later. (Actually happened twice yesterday; it has also happened intermittently in the past.)Quote:
Originally Posted by texasemt
I checked our Configuration settings (as referenced in the post quoted above) and they match the suggested settings.
Any thoughts on whether I should change some of these settings, and if so—which ones?
Thanks in advance; looks like this is a slippery one.
I was about to launch and tested the checkout process with IE and ran into this issue. I am running 1.3.8a. Orders in FireFox are fine.
Cal
I did a bit more tracking and this is what I came up with. These are my web server logs for Firefox and Internet Explorer.
Internet Explorer...
Code:[23/Feb/2008:12:40:17 -0600] "POST /index.php?main_page=checkout_shipping HTTP/1.1" 302 5 "http://dev.modernmunchkin.com/index.php?main_page=checkout_shipping" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2)"
[23/Feb/2008:12:40:17 -0600] "GET /index.php?main_page=checkout_payment HTTP/1.1" 200 20987 "http://dev.modernmunchkin.com/index.php?main_page=checkout_shipping" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2)"
[23/Feb/2008:12:40:26 -0600] "POST /index.php?main_page=checkout_confirmation HTTP/1.1" 200 16897 "http://dev.modernmunchkin.com/index.php?main_page=checkout_payment" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2)"
[23/Feb/2008:12:40:37 -0600] "POST /index.php?main_page=checkout_process HTTP/1.1" 302 5 "http://dev.modernmunchkin.com/index.php?main_page=checkout_confirmation" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2)"
[23/Feb/2008:12:40:37 -0600] "POST /index.php?main_page=checkout_process HTTP/1.1" 302 5 "http://dev.modernmunchkin.com/index.php?main_page=checkout_confirmation" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2)"
[23/Feb/2008:12:40:37 -0600] "GET /index.php?main_page=checkout_success HTTP/1.1" 200 13712 "http://dev.modernmunchkin.com/index.php?main_page=checkout_confirmation" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2)"
Firefox...
Code:[23/Feb/2008:12:41:35 -0600] "GET /index.php?main_page=checkout_shipping HTTP/1.1" 200 14747 "http://dev.modernmunchkin.com/index.php?main_page=product_info&cPath=1_2&products_id=45&number_of_uploads=0" "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12"
[23/Feb/2008:12:41:48 -0600] "POST /index.php?main_page=checkout_shipping HTTP/1.1" 302 5 "http://dev.modernmunchkin.com/index.php?main_page=checkout_shipping" "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12"
[23/Feb/2008:12:41:48 -0600] "GET /index.php?main_page=checkout_payment HTTP/1.1" 200 20986 "http://dev.modernmunchkin.com/index.php?main_page=checkout_shipping" "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12"
[23/Feb/2008:12:41:56 -0600] "POST /index.php?main_page=checkout_confirmation HTTP/1.1" 200 16898 "http://dev.modernmunchkin.com/index.php?main_page=checkout_payment" "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12"
[23/Feb/2008:12:42:01 -0600] "POST /index.php?main_page=checkout_process HTTP/1.1" 302 5 "http://dev.modernmunchkin.com/index.php?main_page=checkout_confirmation" "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12"
[23/Feb/2008:12:42:02 -0600] "GET /index.php?main_page=checkout_success HTTP/1.1" 200 13712 "http://dev.modernmunchkin.com/index.php?main_page=checkout_confirmation" "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12"
The problem most likely is due to Internet Explorer submitting a POST twice for the checkout_process function. Any help would be greatly appreciated. We have spent 3 months getting prepared for launch and this is a major blow for us.
Cal
Just got the same problem today. I am running version 1.3.8. Using Firefox - no problem; using IE 7 - every order is doubled (in the admin backend, confirmation mails, etc.) although I only clicked once on the submit button.
In my case, the problem was exactly this submitonce()-function ; with IE7, the form is submitted twice to the server (I see two POST requests in the server logfile; with Firefox only one). It seems to be a strange behaviour of IE7. I will try to figure out why...
Quick fix:
Remove the javascript function in
search line 174, and remove theCode:includes/templates/[TEMPLATE]/templates/tpl_checkout_confirmation_default.php
part.Code:onsubmit="submitonce();"
Doing so, you will lose the functionality, that the user cannot click twice on the submit button, but orders are not doubled any more.
Excellent find. I can also confirm this happens in Internet Explorer 6.
Quote:
Originally Posted by alex42
Since a couple weeks have passed can it be confirmed that this has fixed the issue without any side effects? What if a customer does actually double click?
This is very interesting and looks like it might well be on the right track.
Can any of the Zen Gurus enlighten us as to the purpose of this code? Why would removing code that is (at first sight) supposed to *prevent* double clicks the cause of them happening?
I'm wondering if it shouldn't be changed from this;
Quote:
Originally Posted by alex42
To this;
Ideas anyone?Code:onsubmit="submitonce(this);"
I have been live for 2 weeks now and have no problems since the change :-)
modernm, do you mean this change?
onsubmit="submitonce(this);"
or do you mean by removing that piece of code.
Bram
Interesting!
I had the same issue and found out that the session data was overwritten in those cases. This is possible because zen cart does not lock the sessions when they are stored into the database. And the double POST submit now explains why it happened so often.
Since I store the sessions in files (then session locking works automaticly), I haven't had any double orders in about 4 months (before I had at least several a week). I also described it previously here: http://www.zen-cart.com/forum/showthread.php?t=82029
Note that it might not be safe to use file based sessions on shared servers.
I've had errors before when I used file based sessions in a shared environment. Once it even came up with another sites customer logged in and their current cart. Since I switched to sql based sessions I've never had that problem.
On versions previous to 1.37 I never had double order issues but then again the volume at the time was much lower on the site as well. Volume has increased over the last 3 months and that is when the duplicate order problem appeared.
Currently I am using 1.37 and also building a 1.38a version to put in place once I get the code modified and I'd really like to verify the source of the problem and get it corrected before I put 1.38a in place.
Hi,
I'm using v.1.3.8, IE 7.
I'm having the Duplicate Order problem too, but noticed one thing REALLY interesting:
It charged me twice (as two orders) as well!
* I noticed this when I logged into the store owner's paypal account, and saw it hit me twice within the 9 seconds.
* I noticed it also listed two orders (as two separate orders) in the admin of the Zen Cart.
BUT REALLY, REALLY INTERESTING:
** Paypal, after about an hour, corrected itself... and removed the duplicates. (Then later in the evening, on another test, only charged it once).
** ZenCart, after a few hours, somehow took out the duplicate orders!!! I'm not kidding on this one. They were there for me to see in the admin control panel, now they're gone... leaving just the real order (even still, it left the order count # as a later count #).
It does this regardless of if it is Paypal Express, or just the regular Paypal Api. I have the credit card method turned 'off' on the site, but do accept check/money order.
Could someone really, really high up at ZenCart look into all this... since I'd imagine it is super, super important?? Payment is pretty darn key when it comes to e-commerce.
I have the log emails from the debug, I'm willing to give some access to someone high up at ZenCart if it will help them look into the problem for a fix.
(Also a note to the high-up cool people at ZenCart: Test ZenCart v.1.3.8 in Firefox, you'll see a lot of funny things going on, duplicate listings, etc.).
Thanks! :-)
- Brian
Brian02138
I think I found the problem!
I decided to write write a small testscript which included the submitonce function and I did lots of tests. And in IE7 the following happened:
- If the user clicks very fast, before the page is fully loaded: no problem, the form is submitted once.
- If the user waits until after the page is fully loaded: no problem: the form is submitted once.
- But if the user clicks just about the time the page finishes loading: the form is submitted twice!
(using IE7, in FF everything works fine)
Now if you open:
/includes/modules/pages/checkout_confirmation/jscript_main.php
You can find the function:
Take a look at this line:Code:function submitonce(){
if (document.checkout_confirmation.btn_submit) {
document.checkout_confirmation.btn_submit.disabled = true;
setTimeout('button_timeout()', 4000);
document.checkout_confirmation.submit();
}
}
I don't know much about Javascript, but it looks like we just submitted the form, then disabled the submit, and then try to submit it here again!? Maybe this line was added to test the submitonce function?Code:document.checkout_confirmation.submit();
So I decided to comment out the above line like this:
After that I have done lots of tests again and I didn't get any duplicate submissions.Code:function submitonce(){
if (document.checkout_confirmation.btn_submit) {
document.checkout_confirmation.btn_submit.disabled = true;
setTimeout('button_timeout()', 4000);
/* document.checkout_confirmation.submit(); */
}
}
And while you're at it you might as well fix another small error in the same file.
Change:
To:Code:function button_timeout() {
document.checkout_confirmation.submit.disabled = false;
}
Code:function button_timeout() {
document.checkout_confirmation.btn_submit.disabled = false;
}
Since I have made the changes to my live shop (and switched back the session saving from files to database) we have had no duplicate orders.
Also another issue I had with a typical Dutch payment method seems to be solved. Before I often had two transactions per order with this module (which did not lead to duplicate orders, so it was not a big problem). The first of the two transactions always expired and the second always was the "real" transaction. Until now I have not seen this happening anymore.
Maybe it's a bit early to draw conclusions after a couple of days and a limited amount of orders, but so far it looks very good :smile:
I attached a fixed file to this post for 1.3.6 - 1.3.8, and possibly other versions.
(of course you need to put back the onsubmit="submitonce();" if it has been removed, if you don't the fix won't make any difference).
G'day,
Just where does one switch session saving from files to database?
Best Regards, Lloyd Borrett.
Hi Lloyd,
you would need to edit your includes/configure.php file (the is a setting for it somewhere at the bottom).
But are you sure your sessions are saved into files currently? By default the sessions are saved into the database, and then there is no need to change it.
(I only mentioned it because I had said earlier that I changed this setting to fix the duplicate orders problem, but after the submitonce fix I changed it back to the default)
Happening to me also. I get an order that does not show the items and then the next order number with the items and Paypal payment info.. Really strange.
I applied the fix file and have the sessions going to the database. I am going to try file sessions.
Steve
Same problem with file sessions. It looks like Paypal is creating a new session on the return???
Steve
Just noticed that none of the notification emails are being sent on the lower order number.
If I enter an order, I get an order number 10 that has no products itemized. It only shows totals and no email order is generated.
I will also get an order number 11 that will have the products itemized and all the Paypal info in it. It also sends the order email.
Any Thoughts???
Steve
I think the issue you have is not related to the topic of this thread (although the issue may seem similar maybe) and so it's probably better to start a new thread about it?
I decided to start a thread about this issue in bug reports:
http://www.zen-cart.com/forum/showthread.php?p=544255
And I will move the attachment with the fixed js file to that thread.
Hi,
I am still having the issue of duplicate payments on every order that is processed via Zen Cart on Paypal IPN. I have tried all the fixes mentioned and still happening in all browsers including FF.
Any help would be greatly received.
Many Thanks
Richard
Just happened to me too. Two orders, with two different order numbers were placed 1 second after each other. Paypal IPN payment. Both paypal payments in both orders show same Trans. ID.
In PayPal account only one payment shows up. So it seems like two orders got generated with the same payment applied and the customer got charged only once. (at least this)!
Interesting that no team member has posted on this one. Seems to be a pretty crucial problem. :unsure:
Hi. I am also getting this problem on one site since I upgraded to 1.3.8a. Can someone from Zencart help out please. Thanks.
I think its just when Paypal processes the payment. Seems if paying by "I will call by payment" ort something similar that doesnt require Paypal, it works OK, but when using Paypal, 2 orders get added (sometimes 3).
I tried this solution http://www.zen-cart.com/forum/showthread.php?t=95195 and it seems to have worked so far. It says the problem is only in IE and not Firefox, but in fact I had the problem in Firefox too but this seems to have fixed it for me so far.
Thanks
I spoke too soon. It seemed to work but it has not. The problem has come back. Please can someone at Zencart help us out?
Thanks
I found this thread also http://www.zen-cart.com/forum/showth...622#post575622. This is interesting. Perhaps its the Paypal timeout issue and so it sends another request, rather than a Zencart issue?
Okay, I have been trying to figure this one out myself. The store has been running on 1.3.8a for nearly a year when about two months ago it began to create duplicate and now triple order .... same products, same buyer but with different order number and sent through Authorize.net.
My client spoke with Authorize.net and he says they do not feel it's on their side because of the different order numbers.
How can zencart duplicate an order and give it a new order number?
I am at a loss. I used the patch from another thread for the submit, and also made sure I'm using file based caching.
The problem is random. Several orders will come through okay, then BAM it does a triplicate!
HELP??
BTW this was with credit card and authorized.net AIM module, not paypal
We just received two sets of triplicate orders on 07/25!! This really screws things up. I'm using 1.3.8a and SecurePay. Luckily SecurePay caught most of them as duplicates.Quote:
Originally Posted by rubear
:censored:
The SecurePay and authorize.net modules are implemented in similar ways. This has me intrigued: http://www.zen-cart.com/forum/showpost.php?p=532773 , but I'd like to do my own research first.Quote:
Originally Posted by chadderuski
I just tried this fix on my site w/IE7.. ..it didn't even prevent the submit from being clicked more than once. I submitted three orders without any prevention. I'm certain I waited for the form to be fully loaded the first time. Perhaps I had the javascript cached?Quote:
Originally Posted by paulm
I did a 'view source' to make sure I saw the change in the javascript. It's the new one, and the btn_submit matches the form code too. It doesn't prevent two submits!
...the view source shows the javascript content is commented out! I can't find out where this is included or commented out yet.
ignore that post. i would delete it except for this stupid 7 minute limit. I was thrown by the syntax:Quote:
Originally Posted by dhcernese
I thought it was all commented out.Code:<script language="javascript" type="text/javascript"><!--
Hi all,
Has anyone found a confirmed fix for this problem?
My store has started duplicating orders from PAYPAL today...
I receive (2) orders with unique order numbers in my backend,
also (2) confirmations to my email but only one payment is submitted
from paypal (which is a bit reassuring)
But all in all its a very weird problem because i didn't change anything at all...
My main concern is messing up my stock counts because i rely on
zen cart to track my inventory. :shocking:
I havn't tried any of the fixes on this thread yet due to little feedback..
Just want to be sure before i start messing with code.
Thanks to everyone in advance.
Some thing is strange in the file, line 11 or 12....
PHP Code:<?php
/**
* jscript_main
*
* @package page
* @copyright Copyright 2003-2006 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license [url]http://www.zen-cart.com/license/2_0.txt[/url] GNU Public License V2.0
* @version $Id: jscript_main.php 3234 2006-03-21 20:13:20Z drbyte $
*/
?>
<script language="javascript" type="text/javascript"><!--
var submitter = null;
function popupWindow(url) {
window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=450,height=280,screenX=150,screenY=150,top=150,left=150')
}
function submitFunction($gv,$total) {
if ($gv >=$total) {
submitter = 1;
}
}
function submitonce(){
if (document.checkout_confirmation.btn_submit) {
document.checkout_confirmation.btn_submit.disabled = true;
setTimeout('button_timeout()', 4000);
/* document.checkout_confirmation.submit(); */
}
}
function button_timeout() {
document.checkout_confirmation.btn_submit.disabled = false;
}
/
Quote:
Originally Posted by janks
PayPal is the only payment option in my two stores where I saw this yesterday. Do you have other payment methods that did not cause this to happen? If so, that would be very interesting. I too changed nothing in either of the client's stores where I saw this happen yesterday.
I also have had this problem for the first time today on ZC 1.37
I have Paypal IPN and Nochex as payment options, and the problem only seems to be with Paypal.
Two order numbers were created, with identical time stamps, and transaction ID's, but only one payment received.
I have only had the one Paypal order this weekend, so I will see if it continues to happen.
clarify what you mean by "strange" ??Quote:
Originally Posted by janks
The PayPal issue is a system bug on the PayPal end, which was resolved this morning: http://www.pdncommunity.com/pdn/blog...sage.uid=92385
Does that mean we donot have to do anything on our side? Because I just received yet another duplicate order (5 min. ago ) .Quote:
Originally Posted by DrByte
Thank you!
I recieved a dublicated order today and it was approx 28hours btw the original!
Order payed with Paypal
so how is it fixed?
Last time it was PayPal's error. They have a postboard where you can see all the updates. Good luck!
Hi
I seem to be getting more and more duplicate orders about 1 or 2 a day out of 3 to 4 orders. It is throwing all of my stock out of sync.
We are using PayPal Website Payments Standard.
Any solutions anyone?
Thanks,
Phil
If this is a problem in Paypal's end how long will it take before it gets fixed. So I guess I shouldn't try anything on my end to fix it and wait until Paypal has resolved the problem, correct?
I got a duplicate order today.
in my paypal ipn there are 2 instances.
First says, Trans. Type: web_accept and says Number of entries in Status History: 0
second says, Trans. Type: unique and says Number of entries in Status History: 1
I am getting duplicate orders too - and have been for the past week or so.
I just got *two* duplicate orders today, where before I got only one. I double-checked that these particular customers didn't have multiple accounts: they didn't (some of my customers do:P).
I have Zen-Cart 1.3.8a, install date 2008-09-04, running on a Linux server
I just started having this error in the past few days myself. Very random from what I have seen. It has worked flawlessly since I installed it over a year ago. I just in the past week moved from nightmare host (dreamhost) to an ubuntu shared server at my office. I am getting duplicate order numbers an duplicate payments in paypal. The paypal payments have different ID's but the zenid= field is the same on both payments. I have searched and I don't believe it to be a paypal issue but it is possible I guess. Anyone care to tackle this one? I am using 1.3.8a on an ubuntu 8.04 server running ISPConfig. Thanks in advance.
I will add my name to this list .. I am getting Duplicates on Paypal and On Sagepay , sometimes I get duplicate payments on both providers othertimes its Two orders and one payment. I am running latest zen-cart. would be nice to hear from an official source. I am also persuing this issue with Paypal and Sagepay.
I am getting duplicate orders and emails. Even an email from the contact us page sends two emails. Anyone find a fix for this?
Been getting the same problem intermittently. Is this a Paypal problem, a Zen Cart problem? Interesting that the Paypal transaction information is the same in both orders.
HELP!!!
We also have had an increase in duplicate orders and confirmation. Deleting and restocking used to resolve this but we discovered that sometimes stock is taken out, sometimes not and now it appears that sometimes it's taking some of the items and not other items in the same order. Now we have to check inventory in every duplicate order.
Just to clarify, it's only Paypal orders that this happens with.
Well now I just had a customer pay with Paypal and nothing showed up in ZenCart at all! I wouldn't have noticed if he hadn't sent me an e-mail because he couldn't check the status of the order...
Yes I had the same issue earlier this week. I had an order placed that the only reason I know it was placed was because I received the paypal notification of payment. I checked everywhere in zen cart and nothing. Only where the customer signed up for an account. I promptly sent the customer an email asking to verify the order and all was well.
The only thing I can figure that caused my issue was that paypal did not return to the cart the "all ok" sign to allow zencart to do it's thing.
Did that happen to you on the 14th? Maybe PayPal was having problems?
Yes happened on the 14th. I fully blame paypal. ;)
I had the double orders occur on October 30th and November 2nd - transaction IDs are identical, but order numbers are consecutive. Customers were only charged once, but recieved two order confirmations and so were concerned that their orders had processed twice. Transaction types show as "unique" for one order and "web_accept" for the second. I am running the very latest version of ZenCart.
Hi everybody, i too get a lot of duplicate orders even with the fix listed in the page three (www.acousticsamples.net). It seems that there are no solution to this but still i may try something in javascript.
In the fix, you try to disable an input type=image which works in firefox, but not in safari or IE... So there are other solutions even if i will try to find something better. It's simply to remove that button :)
so the script now looks like this:
I will add a little ajax message as i use mootools on my website to make it look a little better, but at least i'm sure that this prevents the double clicking in the major web rowsers.PHP Code:function submitonce()
{
var button = document.getElementById("btn_submit").style.display = 'none';
alert("");
//button.style.color = "red";
setTimeout('button_timeout()', 1000);
return false;
}
function button_timeout() {
var button = document.getElementById("btn_submit").style.display = 'true';
//button.style.color = "black";
}
By the way if you use the css butons, i just checked the code and there is no more id to the button so the fix just can't work...
Don't forget to remove the alert(""); line that was just here for testing.
Oh and by the way i'm not sure that this will work just like people want it to, but it does for me at least, i will test a little more on my local test site and the put it online to see if it truly fixes it.
Following this with interest. I have latest versions and getting intermittant duplicate orders following the common pattern:
web_submit and unique only difference being the order id #
I also note that turning off the PDT as recommended elsewhere removed the duplicate notice in the IPN listings in ZC but not the duplicate orders themselves - ie still coming through in email. Seems that only the second one actually "Takes" for me.
I have just made the changes suggested in page 3.
I also have duplicate orders on my shop, happens randomly with either PayPal or iDeal (Dutch system).
I wonder if it has anything to do with the version of PHP on the hosting server. Mine has php 5.2 and maybe soon One.com will upgrade to PHP 5.3 will that be of any help?
If you also have these double orders, please let's find out if the version of PHP could be causing this issue. Since nobody has a really good working solution? Let's try to fix this one way or another. :lamo:
In Admin you can click on Version and on the left side it shows PHP 5.2 What's your version?
Mine shows :
PHP Version: 5.2.5
But i really don't think that's the problem...
I'm still having the double orders once in a while. I did every suggestion from this forum, but still no solution. I really hope someone comes up with a fix as I think that this is one of the basic functions of a webshop. Is everyone having this issue? This issue has been on my mind and still is for the last 2 months. Each time I receive an order, I cross my fingers it's not doubled.
Please people, how can we fix this??
Interesting. Today I got a duplicate order that was actually a FREE file. I run a digital download store and I have one product that is free. Someone "purchased" it and I got two order numbers for it, a few seconds apart. I think this might be a case of the user clicking more then once, but I'm not sure.
PHP Version: 5.2.8
Zen Cart 1.3.8a
Patch: 1::
Database Patch Level: 1.3.8
Interesting, I saw this post and was getting ready to say that I haven't had a duplicate order in quite a while. Then I got a duplicate order a few minutes ago....sigh...
So if sykadelx had the duplicate order issue and the customer didn't check out through PayPal, then this is probably a Zen Cart issue?
I am convinced that this is a Zen-Cart issue, not a Paypal issue as I've had this with both my paying methods.
How about we add a script to the order.php that will check if there has already been an order for this customer in the last minute? How hard would it be to add this?
So if it's not the php version, maybe we can compare the session settings we're using. In Configuration - Sessions, these are my settings:
Session Directory /<customerfolder>/httpd.www/cache
Cookie Domain True
Force Cookie Use False
Check SSL Session ID False
Check User Agent False
Check IP Address False
Prevent Spider Sessions True
Recreate Session True
IP to Host Conversion Status true
If you have the same issues as I do, please let me know if you're using the same settings?
Did you follow the fix over in http://www.zen-cart.com/forum/showthread.php?p=544255 ?Quote:
Originally Posted by KnowNoneSince
I am using an upgraded 1.3.9h from 1.3.8.
I have installed the Ultimate SEO URLS plugin and a facebook "like" button.
HTTP Server: Apache/2.0.54
PHP Version: 5.2.14
I am also getting occasional double orders, where both myself and the customer recieve double order confirmations with different confimation #s however the customer will only be charged once. Customers email with concern that they may have been doubly charged. This happened occasionally prior to upgrading, and I thought it was fixed in the new version (I've seen the code change in jscript_main.php, but it didn't fix the problem). I have gone through this entire post for fixes, and have found no working answers.
I appreciate any help, Thanks!
I was having very similar issues and I was able to fix it. See this and this for my OG post.
I had changed from the PHP email method to SMTP/SMTPAUTH and duplicate orders started. Changed it back and not a single duplicate order.
Despite not being as secure and spam friendly as SMTP/SMTPAUTH, it works as it has for three years.
Anyone get definitive answer to this yet? I have 1.3.9g, and am also getting occasional duplicate orders with web paypal pro. I am looking at going to 1.3.9h, but don't see that this will have any affect in the area.
Looking at logs for recent triplicate: there are different transaction ids, and timestamp is 14 secs apart for each of the 3.
I'm guessing from reading posts that this is multiple clicks. In pages/checkout_confirmation/jscript_main.php, I have the submitonce stuff in. Just wondering, why have 4 sec timeout on disable? Can this just never reenable the submit button? Presumably, on error they'd have to do something else anyway.
According to the logs you shared, yours looks very much like the button was pressed repeatedly, or the customer thought it was taking too long to respond and they refreshed the page in their browser and clicked submit again.Quote:
Originally Posted by dlcohenzc
Zen Cart isn't going to submit the transactions multiple times on its own. That has to be initiated by the customer.
Others in this discussion are typically reporting the duplicates which are occurring from a different cause. Your logs show that yours are pretty clearly a result of the customer submitting multiple times.
I still recommend doing the simple upgrade from 1.3.9g to 1.3.9h.
Thanks much for the reply. Duplicate clicking was my guess as well. I am going to add a message to only click once, and also in submitonce function not reenable the button after 4 second timeout, just leave it disabled. (Sound reasonable?)
I just upgraded to 1.3.9h
BTW, after working with new customer on their 2 ZC stores, I think I am an old-time osCommerce convert (I did massive osc customizations that ZC gives me for free now...)
- Dave
In which log-file and how can it be seen?Quote:
Originally Posted by DrByte
I am asking because I experience the same problem sometimes since around 10 days. I am using version 1.3.9h and nothing has been changed from my side. Just suddenly this problem occured.
The point which is really annoying is that I can not simply delete the order and do an auto-restock. Some items are deducted, others are not. So every item of the deleted double order has to be checked manually.
Just had 6 duplicate orders in a row but 4 were PayPal the other was Google checkout so this looks like a zen issue not a paypal issue dose anyone have a fix on this yet ?
I have lost a bit of money for this happening as I missed some of them to start with.
Sounds more like a template issue. The default template automatically disables the Submit button once it's clicked the first time. If you've changed things in a way that breaks that normal functionality then it's possible that your customers are clicking multiple times, resulting in multiple charges.
I looked at info regarding the submit button and it is in the template to stop multi clicks emailed one of the customers and he said he hit the back button on his mouse by accident after he clicked submit.
Google order is showing first order as Google processing the second is showing as Google new with no data.
So, user error.Quote:
Originally Posted by klevans
Those are normal symptoms.Quote:
Originally Posted by klevans
I belie the reason is too many REQUEST coming to ipn_main_handler.php for same Checkout. so it start to process all POST request parallel and this causes duplicate order.
because the code ipn_main_handler.php already have duplicate request check control. so why this control not works lets see step by step
PHP Code:$lookupData = ipn_lookup_transaction($_POST);
.....
$new_record_needed = ($txn_type == 'unique' ? true : false);
1.POST1 comes to ipn_main_handler.php
2.POST1 start processing check is there same PayPal request processed NO (check paypal table)
3.POST1 INSERT New Order to orders table
4.POST2 comes to ipn_main_handler.php
5.POST2 start processing check is there same PayPal request processed NO (check paypal table) (NO Because We haven't Insert POST1 row to paypal table
6.POST1 INSERT New Order to orders table
7.POST1 insert row to paypal table
8.POST2 insert row to paypal table
as you can see there is time lag between 7. step and 5. step. because of this parallel processing, is unique papal order checking fails and system process both post data as a new order.
i checked the Apache behavior with following code. when i send a two request from different browsers it procesed same page at same time(paralley).
and solution for this problem is using a table which keeps txn_id | (and process status)PHP Code:for($i=0;$i<8;$i++)
{
echo "$i. ".date("H:i:s", time())." <br>";
sleep(1);
}
and before start to process
1.update table txn_id|inprogress
2.second Post data checks if its in in progress then wait 5 seconds and check again until first process changed to txn_id|done
it have same weakness but if you don't use auto increment key. sytem have to wait for eacother because of SQL insert integrity or it gives duplicate key error.
This is my Theory of Duplicate orders. if you have any comments or different views on this analyze i love to hear. i have to solve duplicate problem.
anyone solved the problem ?? please share your solution...
thanks