I had a virtual server go wobbly for a couple of days. The website is back on line now but I apparently had one order placed in this time. There is a paypal payment received with an invoice id attached - its definitely a generated order number from within uCommerce, however there is no trace of this order number within ucommerce. Subsequent orders have been generated with the next ids so something knows this ID has been used but there is no basket record for the time period no order, order line or record in the payment table.
I am trying to locate further information for this order but drawing a blank.
It is possible that the host restored a snapshot from earlier in the morning without telling me so removed the db entries but if this was the case, how did the ordering system know to skip this order number for the next order.
Could you possibly send a copy of the database to us?
The order number is generated by a stored procedure based upon the data in the OrderNumberSeries table, i think. So restoring the database would reset the order numbering as well, I would guess.
Database omissions after server error
Hi,
I had a virtual server go wobbly for a couple of days. The website is back on line now but I apparently had one order placed in this time. There is a paypal payment received with an invoice id attached - its definitely a generated order number from within uCommerce, however there is no trace of this order number within ucommerce. Subsequent orders have been generated with the next ids so something knows this ID has been used but there is no basket record for the time period no order, order line or record in the payment table.
I am trying to locate further information for this order but drawing a blank.
It is possible that the host restored a snapshot from earlier in the morning without telling me so removed the db entries but if this was the case, how did the ordering system know to skip this order number for the next order.
Any advice on this would be great.
Thank
Cathy
Hi Cathy,
It sounds very wierd.
Could you possibly send a copy of the database to us?
The order number is generated by a stored procedure based upon the data in the OrderNumberSeries table, i think. So restoring the database would reset the order numbering as well, I would guess.
Kind regards,
Jesper
is working on a reply...