If you have a support question or comment, click the Post New Topic link below. Sytist Manual | Sytist Articles | Facebook Page.

Missing Order Info

 
Please log in or Create an account to post or reply to topics.
 
Kris Harvey
Tue Aug 22, 17
11:17 AM
Hi Tim,

I recently migrated our site to new hosting. Everything seems to be working fine but I did notice that some of my archived orders are missing details about the products in the order. This could cause problems with accounting and record keeping. Is there a way to export/import the data base again now to recover those details without overwriting the current data base entirely? Do you know what table I would be missing info from that would cause me to just be missing the products in the order and not the entire order.

thanks!
Wendy Reed
Baby Bloom Photography
 
 
 
 
 
Tim - PicturesPro.com
admin
Tue Aug 22, 17
1:04 PM
The order items are located in the ms_cart and ms_cart _archive tables. You might want to reference those 2 tables from the old installation and the new.

If you were to export / import those tables though, it would overwrite the new data in the new database. But if you find missing rows in those tables, you might be able to just export those rows and import into the new database.
 
 
 
 
 
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com
Kris Harvey
Tue Aug 22, 17
1:51 PM
We have over 20k rows....but since the migration is fairly new I can export the last week of orders to the old data base and then export the combined databases to the new hosting. right?

However, I can seem to figure out how to export just the rows I want to export. I keeps telling me I have a duplicate key error:
Error
MySQL said: Documentation

#1062 - Duplicate entry '376' for key 1

Do you know why it would tell me this?

Thanks! - Wendy
 
 
 
 
 
Tim - PicturesPro.com
admin
Wed Aug 23, 17
7:18 AM
I don't know why it would be doing that on the export. If it was on the import, it might be because there is already a row with that ID in the table.
 
 
 
 
 
Tim Grissett, DIA - PicturesPro.com || My Email Address: info@picturespro.com
Kris Harvey
Wed Aug 23, 17
9:13 AM
OK, thank you. I'll try it again. Have a great day!
 
 
 
 
 

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