Zen Cart Logo
Forums / General Questions / New order lost on database restore

New order lost on database restore

Locked

Views: 784

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
28 Jan 2009, 2:45 AM
#1
ryanb4614 avatar

ryanb4614

Totally Zenned

Join Date:
Feb 2008
Posts:
556
Plugin Contributions:
0

New order lost on database restore

I had to restore my database to 10 days ago, I had an order Processing, but it is now gone from the list... Any way to get this back? Or remake it and put it in the customer's account, she has order from me before.

1.3.8a

28 Jan 2009, 5:28 AM
#2
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,288
Plugin Contributions:
39

Re: New order lost on database restore

Did you backup the old DB before you restored?

If so just add the order i phpmyadmin.

~Melanie

28 Jan 2009, 6:14 AM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: New order lost on database restore

A restore of the database WIPES OUT any and all existing data.

So, yes, whatever happened in the database AFTER your backup is now lost since you DELETED it all by replacing it with your backup.

If you need the order in the database, it's best to place the order by logging in as the customer and entering it as they did.

(Manually attempting to force order (or any other) data into the database is dangerous unless you've studied all the related database tables and fully comprehend what you're doing there and why.)

28 Jan 2009, 2:53 PM
#4
ryanb4614 avatar

ryanb4614

Totally Zenned

Join Date:
Feb 2008
Posts:
556
Plugin Contributions:
0

Re: New order lost on database restore

Okay so if I download master password and login as the customer, but what do I do about the payment method, if they used a credit card?

28 Jan 2009, 3:08 PM
#5
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Location:
Woodbine, Georgia, United States
Posts:
4,288
Plugin Contributions:
39

Re: New order lost on database restore

Temporarily turn on your check or money order (if not already) and place the order using check... Then note the transaction with the trans ID and a short note describing the issue for the customer.

~Melanie