News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Duplicate Orders

Started by drukman2000, July 18, 2013, 12:15:46 PM

Previous topic - Next topic

drukman2000

Quote from: Milbo on August 02, 2013, 14:30:46 PM
I do not understand this "Confirmed" & "Confirmed by shopper"
Do you mean, you set some orders to confirmed and others to "confirmed by shopper" and then you used the update button and all of them are doubled?

Just found another configuration that cause duplicate orders to appear....

The next configuration causes Duplicate Orders to appear:

1. "agreed" uder the Shopper Fields is mandatory & published.
2.  "Show Terms of Service on the cart/checkout?" is active.

Checked with Firefox & Chrome.
Can someone confirm this problem ?
For now we must deactivate TOS on checkout.

Drukman.

Jörgen

Hell Drukman

Are sure that You are getting duplicate orders for every order done with this configuration ?

Because of this behaviour shows with different configurations, then the problem is maybe not only connected to the configuration. It could be some kind of timing issue with the sql sequences storing these orders. This configuration generates maybe several updates of the order data that could give these problems.

I am currently using the old VM 1.1.3 and with CertiTrade card payment I get duplicate orders from time to time.
I suspect that this is a timing problem together with a heavily loaded sql server. I am not reporting a bug with the older VM 1.1 I am only trying to give You another view of this bug in VM 2.x.

This could be happening when the customer several times repeatedly presses the button on Certirades safe website that sends them back to my webshop.
My guess is that several requests of storing the updated data for the purchase are getting processed. There are probably checks that should prevent this, but i guess that they must be done before the first request is stored in the database.

I have actually had an order that got three copies (with consecutive ordernumbers), a total of four orders !

I could confirm this behaviour at that time. But later I couldn´t repeat the behaviour and because of this I stopped looking for the bug. I still happens, but I now simply erase the duplicate order and tell the customer that money has only been transferred once and that it otherwise is OK.

This could also be the case here. A check that  the order actually doesn´t already exists under a different ordernumber performed when updating payment data could prevent this.

This is of curse only an educated guess, but maybe someone could check if my theory pans out.

my two cents

Jörgen @ Kreativ Fotografi

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

drukman2000

Quote from: Jörgen on August 11, 2013, 11:05:58 AM
Hell Drukman

Are sure that You are getting duplicate orders for every order done with this configuration ?

Because of this behaviour shows with different configurations, then the problem is maybe not only connected to the configuration. It could be some kind of timing issue with the sql sequences storing these orders. This configuration generates maybe several updates of the order data that could give these problems.

I am currently using the old VM 1.1.3 and with CertiTrade card payment I get duplicate orders from time to time.
I suspect that this is a timing problem together with a heavily loaded sql server. I am not reporting a bug with the older VM 1.1 I am only trying to give You another view of this bug in VM 2.x.

This could be happening when the customer several times repeatedly presses the button on Certirades safe website that sends them back to my webshop.
My guess is that several requests of storing the updated data for the purchase are getting processed. There are probably checks that should prevent this, but i guess that they must be done before the first request is stored in the database.

I have actually had an order that got three copies (with consecutive ordernumbers), a total of four orders !

I could confirm this behaviour at that time. But later I couldn´t repeat the behaviour and because of this I stopped looking for the bug. I still happens, but I now simply erase the duplicate order and tell the customer that money has only been transferred once and that it otherwise is OK.

This could also be the case here. A check that  the order actually doesn´t already exists under a different ordernumber performed when updating payment data could prevent this.

This is of curse only an educated guess, but maybe someone could check if my theory pans out.

my two cents

Jörgen @ Kreativ Fotografi



Jörgen,
My problem happens locally while the order is stored & NOT after the payment is done.
I saw other scenarios that it happened & I think your TIMING db theory might explain it.

Interestingly - it never happened with IE ! only FF & Chrome !
But how this can be tested ? specially when most VM "veterans" posting on the forum says it's an old problem & most of them can't reproduce it !

Drukman.

Maxim Pishnyak

You can support Community by voting for Project on the JED
https://extensions.joomla.org/extension/virtuemart/#reviews
Join us at
https://twitter.com/virtuemart

drukman2000

Quote from: Maxim Pishnyak on August 21, 2013, 15:56:59 PM
Quote from: drukman2000 on August 11, 2013, 09:03:21 AM
We are very far from being "bug free" -)).
A bit of searching for 'duplicate order' could give you an answer.
http://forum.virtuemart.net/index.php?topic=114154
http://forum.virtuemart.net/index.php?topic=95380

Jörgen,
I already read these posts before.
Do you find that it gives any new info ?
Drukman.

Jörgen

He he

...that post was not from me  ;D

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

Maxim Pishnyak

Quote from: drukman2000 on August 21, 2013, 16:40:03 PM
I already read these posts before.
Do you find that it gives any new info ?
Is it not clear enough that bad paypal behavior is responsible for observed issue? Alatak confirmed that it's not simple to find workaround for paypal attacks at poor VM orders.
You can support Community by voting for Project on the JED
https://extensions.joomla.org/extension/virtuemart/#reviews
Join us at
https://twitter.com/virtuemart

drukman2000

Quote from: Maxim Pishnyak on August 21, 2013, 17:05:52 PM
Quote from: drukman2000 on August 21, 2013, 16:40:03 PM
I already read these posts before.
Do you find that it gives any new info ?
Is it not clear enough that bad paypal behavior is responsible for observed issue? Alatak confirmed that it's not simple to find workaround for paypal attacks at poor VM orders.
I tested with other payment methods (Jörgen also isn't using PayPal) - and the problem is there.
So it's definitely VM and not PayPal.

drukman2000

Quote from: Jörgen on August 21, 2013, 16:56:59 PM
He he
...that post was not from me  ;D
Jörgen @ Kreativ Fotografi
I know.
But was wondering if you find any new info in those links.

Maxim Pishnyak

Quote from: drukman2000 on August 21, 2013, 17:12:30 PM
I tested with other payment methods (Jörgen also isn't using PayPal) - and the problem is there.
This is can't surprise me.
http://forum.virtuemart.net/index.php?topic=116110
You can support Community by voting for Project on the JED
https://extensions.joomla.org/extension/virtuemart/#reviews
Join us at
https://twitter.com/virtuemart