Time Clash

[monkeymoo]

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

[oschellas]

If you use persistent connections in your config file, you could try without. Read also an article posted by Mibble. Another possibility would be to lock your tables until an action has been completed.

[monkeymoo]

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