AbanteCart Community

Shopping Cart Operations => Support => Topic started by: jcschott on March 06, 2017, 02:16:59 PM

Title: Extracts not working after store move
Post by: jcschott on March 06, 2017, 02:16:59 PM: We just moved our cart to a new host. Everything works well and followed the steps in http://forum.abantecart.com/index.php/topic,426.0.html. I am trying to do a product extract to do some bulk pricing updates and it will download the tar.gz file but it comes through as a corrupted page. Winzip & 7ZIP won't open the file (no errors while downloading).
I've tried other exports and the same error. My old cart has no issues exporting the product file and I've tried 3 different computers with 3 different firewalls with no success. Have any ideas why the export suddenly fails after a server move?
Title: Re: Extracts not working after store move
Post by: Basara on March 07, 2017, 12:46:04 AM: Hi.
Check export file size if it is zero it may indicate export not work at all.
And check errors/warnings in the log
Title: Re: Extracts not working after store move
Post by: jcschott on March 07, 2017, 09:37:35 AM: The file size looks about right (comparing to my previous store) and if i try just exporting a few products using the file soze goes way down so it appears the extract is working but generating a corupt file.
Title: Re: Extracts not working after store move
Post by: abolabo on March 08, 2017, 03:15:51 AM: what about anti-virus software on your side? Can it corrupt file?
Title: Re: Extracts not working after store move
Post by: jcschott on March 08, 2017, 06:31:19 PM: Still had no impacts as all three had different AV and I tried disabling it on one to download. I can extract on the old site still just not the new site.
Title: Re: Extracts not working after store move
Post by: jcschott on March 11, 2017, 07:38:47 PM: Any other ideas? I am close to try a fresh install and re-importing the data set of about 1800 products but don't really want to start fresh with a live site (however the lack of being able to extract is a big issue for bulk update). I've attached a sample of about 15 product export corrupted file.
Title: Re: Extracts not working after store move
Post by: jcschott on March 13, 2017, 12:34:19 AM: I ended up doing a fresh install, after installing another install on the same domain but different directory and successfully downloading products after the database restore. But after pulling in the configuration files again it corrupts the file on export.

Here are the steps I did:
1) Rename folder of store installed (/shop to shop1)
2) Install new abantecart through CPANEL softacuolous using the same table prefix as the original install
3) Truncated all tables through phpmyadmin (get rid of sample data)
4) Restored database through phpmydmin
5) Update system/config.php
updated salt and Encryption key
6)    Upload following files from other directory:
   ○ Resources/image
      ○ storefront/view/default/image
      ○ image/thumbnails
      ○ storefront/view/default/stylesheet/style.css
7) Try to export again and it corrupted.
Title: Re: Extracts not working after store move
Post by: jcschott on March 13, 2017, 10:59:56 PM: SOLVED: (not sure of the root cause) I did realize my error the second time. On the second reinstall I copied over the config file instead of just replacing the salt/encryption keys so it was still pulling from the old database. Once I corrected it everything seems to be working correctly. Still not sure what was causing the issue with the original install but a reinstall did actually correct the problem
Title: Re: Extracts not working after store move
Post by: Basara on March 14, 2017, 01:08:52 AM: Thank you, jcschott for update