Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

These support forums are now closed for new topics and comments.
Please head on over to for support.

  • Cathy Pank 21 posts 41 karma points
    Nov 13, 2013 @ 20:35
    Cathy Pank

    Database omissions after server error


    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.



  • Jesper Nielsen 141 posts 498 karma points
    Nov 15, 2013 @ 11:06
    Jesper Nielsen

    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,


Please Sign in or register to post replies

Write your reply to: