I woke up this morning to an email from the client asking me to move an order from this week's deliveries to last week's because he filled it last week.
Instead, I moved every order to last week. Almost two hundred of them. Ouch.
I immediately turned to my local backup of the database and created a file to correct the problem, which wiped out the order timestamp as well due to another mistake. I finally got things worked out and corrected all of the orders except the five most recent. I corrected those manually from the information in the email notifications I get sent every time a customer makes an order.
I hope this will teach me not to make updates to my databases immediately upon getting out of bed. Hmph. Probably not.
Instead, I moved every order to last week. Almost two hundred of them. Ouch.
I immediately turned to my local backup of the database and created a file to correct the problem, which wiped out the order timestamp as well due to another mistake. I finally got things worked out and corrected all of the orders except the five most recent. I corrected those manually from the information in the email notifications I get sent every time a customer makes an order.
I hope this will teach me not to make updates to my databases immediately upon getting out of bed. Hmph. Probably not.