To post a new support question, click the Post New Topic button below.
Current Version: 4.9.3 | Sytist Manual | Common Issues | Feature Requests
Please log in or Create an account to post or reply to topics.
You will still receive notifications of replies to topics you are part of even if you do not subscribe to new topic emails.
Missing Order Info
Kris Harvey
59 posts
Tue Aug 22, 17 11:17 AM CST
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
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
16,271 posts
(admin)
Tue Aug 22, 17 1:04 PM CST
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.
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
My Email Address: info@picturespro.com
Kris Harvey
59 posts
Tue Aug 22, 17 1:51 PM CST
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
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
16,271 posts
(admin)
Wed Aug 23, 17 7:18 AM CST
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
My Email Address: info@picturespro.com
Kris Harvey
59 posts
Wed Aug 23, 17 9:13 AM CST
OK, thank you. I'll try it again. Have a great day!
Please log in or Create an account to post or reply to topics.
Loading more pages