Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Time Clash


monkeymoo

Recommended Posts

Hi

 

Can anyone tell me if their has been a fix for this.

 

We have a busy Oscommerce site and if some one places an order at the exactly the same time as another (I.E. at the same second) the two orders are added to the database under the same order number. The orders are then displayed with two sets of TAX two sets of shipping and you have to edit one of the orders data in all the tables in the database to split the data and show the two orders correctly.

 

The system omits the next order number so this is handy when editing the table. So the two orders that are made at that same second may have the number 1004 and then the third order has the number 1006.

 

Any ideas?

 

Thanks

Link to comment
Share on other sites

Thanks for the reply. Unfortunatly persistant connections grinds our server to a standstill so isnt an option.

 

If we were to implement a lock on the table, will it just queue the update of the second order until the first is finished. Last thing I want is to lose order data due to errors.

 

Thanks

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...