Missing Approx 300 Orders From May To Aug?

 
Please log in or Create an account to post or reply to topics.
 
Luke Trottier
Wed Oct 04, 17
11:32 AM
We lost approx. 300 orders from the past few months. We can not pull accurate sales reports, manually searching for the missing order numbers shows "That Order Does Not Exist" We can see new orders now, but the block of 300 orders from May to Aug are missing.
Tim - PicturesPro.com
admin
Thu Oct 05, 17
6:22 AM
The only way that could really happen is if a database backup was restored from an old backup. Photo Cart won't just delete orders. Has there been any backups restored?
 
 
 
 
 
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com
Luke Trottier
Thu Oct 05, 17
6:54 AM
No, but we did have to run a repair on a few tables that crashed in MySQL. Apparently the repair is not lossless.
Tim - PicturesPro.com
admin
Thu Oct 05, 17
8:47 AM
I don't think a repair would cause data loss, but I don't know for sure.

If you have received orders that ended up being duplicate order numbers from the past, that is a telltale sign the database had been restored from an older backup,
 
 
 
 
 
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com
Luke Trottier
Thu Oct 05, 17
8:54 AM
The missing orders are from May to Aug however the events we added between May and Aug are still there. Everything except the orders from May to Aug is there. The order numbers missing are 24958-25232. In Sept we pick up at 25233, there are no duplicate order numbers. The events we added from May-Aug as stated are there but they show zero sales which is inaccurate as the missing 300 orders account for the sales from those events. Had the database been restored I would have thought more then the orders would be missing.
Tim - PicturesPro.com
admin
Thu Oct 05, 17
12:36 PM
I don't have any idea then what happened to them. You can go into the PHPMyAdmin in your hosting control panel and look in the pc_orders table in your Photo Cart database and search the order id field for one of those order numbers and see if they are there.
 
 
 
 
 
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com

Loading more pages
Sign up for email promotions.
Your information is safe with us and won't be shared.
Thank you for signing up!
 
©2003 - 2017 Grissett, LLC. All Rights Reserved.
Loading More Photos
Scroll To Top
Close Window
Loading
Close